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 = '2110186' and urb_activo = '1' AND color = '1114' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0413' 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 = '2110187' 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 = '0413' 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 = '2110191' 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 = '0413' 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 = '2110192' 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 = '0413' 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 = '2110193' 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 = '0128' 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 = '2110194' 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 = '0128' 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 = '2110196' 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 = '0128' 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 = '2110185' 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 = '0413' 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 = '2110188' and urb_activo = '1' AND color = '1069' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0413' 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 = '2110189' and urb_activo = '1' AND color = '2570' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0413' 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 = '2110190' and urb_activo = '1' AND color = '0015' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0413' 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 = '2110000' and urb_activo = '1' AND color = '0511' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0168' 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 = '2110002' and urb_activo = '1' AND color = '0511' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0168' 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 = '2110003' and urb_activo = '1' AND color = '0008' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0168' 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 = '2110010' and urb_activo = '1' AND color = '0511' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0062' 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 = '2110064' and urb_activo = '1' AND color = '1114' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0128' 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 = '2110137' 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 = '0115' 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 = '2110168' 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 = '0010' 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 = '2110169' and urb_activo = '1' AND color = '0172' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0010' 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 = '2110170' 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 = '0010' 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 = '2110171' 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 = '0010' 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 = '2110172' 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 = '0010' 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 = '2110180' and urb_activo = '1' AND color = '0015' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0115' 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 = '2110181' and urb_activo = '1' AND color = '0015' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0049' 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 = '2110182' 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 = '0049' 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 = '2110183' 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 = '0115' 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 = '2110134' 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 = '0115' 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 = '2110173' 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 = '0115' 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 = '2110174' 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 = '0115' 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 = '2110175' 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 = '0115' 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 = '2110177' and urb_activo = '1' AND color = '0140' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0115' 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 = '2110179' and urb_activo = '1' AND color = '0253' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0115' 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