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 = '2840081' 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 = '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 = '2840083' 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 = '0430' 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 = '2840087' and urb_activo = '1' AND color = '0005' 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 = '2840088' and urb_activo = '1' AND color = '0005' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0430' 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 = '2840091' 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 = '0430' 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 = '2840094' 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 = '0186' 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 = '2840098' and urb_activo = '1' AND color = '1330' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0186' 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 = '2840099' and urb_activo = '1' AND color = '2214' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0186' 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 = '2840100' and urb_activo = '1' AND color = '0100' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0186' 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 = '2840114' and urb_activo = '1' AND color = '2530' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0186' 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 = '2840115' and urb_activo = '1' AND color = '2530' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0186' 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 = '2840085' 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 = '0186' 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 = '2840107' and urb_activo = '1' AND color = '2145' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0186' 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 = '2840082' 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 = '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 = '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 = '2840093' and urb_activo = '1' AND color = '0549' 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 = '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 = '2840102' 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 = '0430' 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 = '2840103' 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 = '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 = '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 = '2840106' 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 = '0430' 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 = '2840109' 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 = '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 = '2840111' and urb_activo = '1' AND color = '2528' 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 = '2840112' and urb_activo = '1' AND color = '1787' 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 = '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
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 = '2840116' and urb_activo = '1' AND color = '2530' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0430' 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 = '2840095' 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 = '2840104' 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 = '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 = '2840110' and urb_activo = '1' AND color = '2527' 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