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 = '2800382' and urb_activo = '1' AND color = '1725' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0211' 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 = '2800383' 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 = '0211' 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 = '2670104' 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 = '0211' 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 = '2670108' and urb_activo = '1' AND color = '2004' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0211' 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 = '2670109' 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 = '0211' 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 = '2800294' and urb_activo = '1' AND color = '2514' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0211' 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 = '2800295' 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 = '0211' 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 = '2800296' and urb_activo = '1' AND color = '2519' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0211' 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 = '2820218' 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 = '0298' 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 = '2820219' 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 = '0298' 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 = '2840084' and urb_activo = '1' AND color = '0043' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0298' 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 = '2840101' 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 = '0298' 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 = '2840105' and urb_activo = '1' AND color = '1721' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0298' 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 = '2840108' and urb_activo = '1' AND color = '2526' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0298' 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 = '2840113' and urb_activo = '1' AND color = '2529' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0298' 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