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 = '0991396' 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 = '0349' 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 = '0991552' 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 = '0349' 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 = '0991587' and urb_activo = '1' AND color = '0101' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0349' 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 = '1111177' and urb_activo = '1' AND color = '0122' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0054' 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 = '1780062' and urb_activo = '1' AND color = '0120' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0012' 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 = '1780172' 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 = '0118' 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 = '1830571' 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 = '0349' 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 = '1220239' 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 = '0349' 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 = '1100042' and urb_activo = '1' AND color = '0011' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0015' 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 = '1100071' and urb_activo = '1' AND color = '0019' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0015' 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 = '1100148' and urb_activo = '1' AND color = '0002' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0015' 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 = '1100149' and urb_activo = '1' AND color = '0006' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0015' 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 = '1100180' and urb_activo = '1' AND color = '0004' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0233' 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 = '1100181' and urb_activo = '1' AND color = '2532' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0233' 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 = '1780186' 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 = '0118' 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