SELECT
wtalla.sr_recno as id_talla,
tallas_modelo.ref as ref,
tallas_modelo.modelo as modelo,
tallas_modelo.color as color,
tallas_modelo.talla as talla,
wtalla.cod as cod_talla,
if(wtalla.nom1 IS NULL, wtalla.nom, wtalla.nom1) as nom_talla
FROM
(
SELECT ref, modelo, color, talla FROM larpi_0000002570_ecomer.gar WHERE modelo = '2440671' and urb_activo = '1' AND color = '2642' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0387' and gtallal.talla = tallas_modelo.talla
LEFT JOIN larpi_0000002570_ecomer.wtalla ON wtalla.cod = tallas_modelo.talla
ORDER BY
gtallal.orden ASC
,wtalla.cod
SELECT
wtalla.sr_recno as id_talla,
tallas_modelo.ref as ref,
tallas_modelo.modelo as modelo,
tallas_modelo.color as color,
tallas_modelo.talla as talla,
wtalla.cod as cod_talla,
if(wtalla.nom1 IS NULL, wtalla.nom, wtalla.nom1) as nom_talla
FROM
(
SELECT ref, modelo, color, talla FROM larpi_0000002570_ecomer.gar WHERE modelo = '2770313' and urb_activo = '1' AND color = '0009' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0360' and gtallal.talla = tallas_modelo.talla
LEFT JOIN larpi_0000002570_ecomer.wtalla ON wtalla.cod = tallas_modelo.talla
ORDER BY
gtallal.orden ASC
,wtalla.cod
SELECT
wtalla.sr_recno as id_talla,
tallas_modelo.ref as ref,
tallas_modelo.modelo as modelo,
tallas_modelo.color as color,
tallas_modelo.talla as talla,
wtalla.cod as cod_talla,
if(wtalla.nom1 IS NULL, wtalla.nom, wtalla.nom1) as nom_talla
FROM
(
SELECT ref, modelo, color, talla FROM larpi_0000002570_ecomer.gar WHERE modelo = '2860349' and urb_activo = '1' AND color = '0009' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' and gtallal.talla = tallas_modelo.talla
LEFT JOIN larpi_0000002570_ecomer.wtalla ON wtalla.cod = tallas_modelo.talla
ORDER BY
gtallal.orden ASC
,wtalla.cod
SELECT
wtalla.sr_recno as id_talla,
tallas_modelo.ref as ref,
tallas_modelo.modelo as modelo,
tallas_modelo.color as color,
tallas_modelo.talla as talla,
wtalla.cod as cod_talla,
if(wtalla.nom1 IS NULL, wtalla.nom, wtalla.nom1) as nom_talla
FROM
(
SELECT ref, modelo, color, talla FROM larpi_0000002570_ecomer.gar WHERE modelo = '2860350' and urb_activo = '1' AND color = '1653' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' and gtallal.talla = tallas_modelo.talla
LEFT JOIN larpi_0000002570_ecomer.wtalla ON wtalla.cod = tallas_modelo.talla
ORDER BY
gtallal.orden ASC
,wtalla.cod
SELECT
wtalla.sr_recno as id_talla,
tallas_modelo.ref as ref,
tallas_modelo.modelo as modelo,
tallas_modelo.color as color,
tallas_modelo.talla as talla,
wtalla.cod as cod_talla,
if(wtalla.nom1 IS NULL, wtalla.nom, wtalla.nom1) as nom_talla
FROM
(
SELECT ref, modelo, color, talla FROM larpi_0000002570_ecomer.gar WHERE modelo = '2860364' and urb_activo = '1' AND color = '0132' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' and gtallal.talla = tallas_modelo.talla
LEFT JOIN larpi_0000002570_ecomer.wtalla ON wtalla.cod = tallas_modelo.talla
ORDER BY
gtallal.orden ASC
,wtalla.cod
SELECT
wtalla.sr_recno as id_talla,
tallas_modelo.ref as ref,
tallas_modelo.modelo as modelo,
tallas_modelo.color as color,
tallas_modelo.talla as talla,
wtalla.cod as cod_talla,
if(wtalla.nom1 IS NULL, wtalla.nom, wtalla.nom1) as nom_talla
FROM
(
SELECT ref, modelo, color, talla FROM larpi_0000002570_ecomer.gar WHERE modelo = '2860369' and urb_activo = '1' AND color = '0132' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' and gtallal.talla = tallas_modelo.talla
LEFT JOIN larpi_0000002570_ecomer.wtalla ON wtalla.cod = tallas_modelo.talla
ORDER BY
gtallal.orden ASC
,wtalla.cod
SELECT
wtalla.sr_recno as id_talla,
tallas_modelo.ref as ref,
tallas_modelo.modelo as modelo,
tallas_modelo.color as color,
tallas_modelo.talla as talla,
wtalla.cod as cod_talla,
if(wtalla.nom1 IS NULL, wtalla.nom, wtalla.nom1) as nom_talla
FROM
(
SELECT ref, modelo, color, talla FROM larpi_0000002570_ecomer.gar WHERE modelo = '2950099' and urb_activo = '1' AND color = '0001' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0360' and gtallal.talla = tallas_modelo.talla
LEFT JOIN larpi_0000002570_ecomer.wtalla ON wtalla.cod = tallas_modelo.talla
ORDER BY
gtallal.orden ASC
,wtalla.cod
SELECT
wtalla.sr_recno as id_talla,
tallas_modelo.ref as ref,
tallas_modelo.modelo as modelo,
tallas_modelo.color as color,
tallas_modelo.talla as talla,
wtalla.cod as cod_talla,
if(wtalla.nom1 IS NULL, wtalla.nom, wtalla.nom1) as nom_talla
FROM
(
SELECT ref, modelo, color, talla FROM larpi_0000002570_ecomer.gar WHERE modelo = '2950100' and urb_activo = '1' AND color = '0776' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0360' and gtallal.talla = tallas_modelo.talla
LEFT JOIN larpi_0000002570_ecomer.wtalla ON wtalla.cod = tallas_modelo.talla
ORDER BY
gtallal.orden ASC
,wtalla.cod
SELECT
wtalla.sr_recno as id_talla,
tallas_modelo.ref as ref,
tallas_modelo.modelo as modelo,
tallas_modelo.color as color,
tallas_modelo.talla as talla,
wtalla.cod as cod_talla,
if(wtalla.nom1 IS NULL, wtalla.nom, wtalla.nom1) as nom_talla
FROM
(
SELECT ref, modelo, color, talla FROM larpi_0000002570_ecomer.gar WHERE modelo = '2950135' and urb_activo = '1' AND color = '2324' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' and gtallal.talla = tallas_modelo.talla
LEFT JOIN larpi_0000002570_ecomer.wtalla ON wtalla.cod = tallas_modelo.talla
ORDER BY
gtallal.orden ASC
,wtalla.cod
SELECT
wtalla.sr_recno as id_talla,
tallas_modelo.ref as ref,
tallas_modelo.modelo as modelo,
tallas_modelo.color as color,
tallas_modelo.talla as talla,
wtalla.cod as cod_talla,
if(wtalla.nom1 IS NULL, wtalla.nom, wtalla.nom1) as nom_talla
FROM
(
SELECT ref, modelo, color, talla FROM larpi_0000002570_ecomer.gar WHERE modelo = '2950234' and urb_activo = '1' AND color = '0075' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0' and gtallal.talla = tallas_modelo.talla
LEFT JOIN larpi_0000002570_ecomer.wtalla ON wtalla.cod = tallas_modelo.talla
ORDER BY
gtallal.orden ASC
,wtalla.cod
SELECT
wtalla.sr_recno as id_talla,
tallas_modelo.ref as ref,
tallas_modelo.modelo as modelo,
tallas_modelo.color as color,
tallas_modelo.talla as talla,
wtalla.cod as cod_talla,
if(wtalla.nom1 IS NULL, wtalla.nom, wtalla.nom1) as nom_talla
FROM
(
SELECT ref, modelo, color, talla FROM larpi_0000002570_ecomer.gar WHERE modelo = '2950235' and urb_activo = '1' AND color = '0250' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0' and gtallal.talla = tallas_modelo.talla
LEFT JOIN larpi_0000002570_ecomer.wtalla ON wtalla.cod = tallas_modelo.talla
ORDER BY
gtallal.orden ASC
,wtalla.cod