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 = '1791693' 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 = '0364' 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 = '2750115' and urb_activo = '1' AND color = '2468' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0421' 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 = '2800298' and urb_activo = '1' AND color = '2520' 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 = '2800299' and urb_activo = '1' AND color = '2521' 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 = '2800300' and urb_activo = '1' AND color = '2515' 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 = '2820223' and urb_activo = '1' AND color = '2422' 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 = '2820224' and urb_activo = '1' AND color = '2423' 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 = '2820225' and urb_activo = '1' AND color = '2210' 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 = '2820226' and urb_activo = '1' AND color = '0013' 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 = '2820228' and urb_activo = '1' AND color = '0179' 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 = '2840080' and urb_activo = '1' AND color = '0003' 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 = '2840086' and urb_activo = '1' AND color = '2368' 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 = '2840096' 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 = '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 = '2840097' 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 = '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 = '2860462' and urb_activo = '1' AND color = '2448' 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 = '2860463' and urb_activo = '1' AND color = '1982' 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 = '2860464' and urb_activo = '1' AND color = '2449' 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 = '2860465' and urb_activo = '1' AND color = '2450' 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