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 = '1791772' 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 = '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 = '3030342' 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 = '0' 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 = '1770419' 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 = '0359' 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 = '1770420' 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 = '0359' 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 = '1770421' 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 = '0359' 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 = '1770425' 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 = '0359' 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 = '1770426' 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 = '0359' 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 = '1770427' 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 = '0359' 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 = '1770446' 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 = '0370' 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 = '1770462' and urb_activo = '1' AND color = '0058' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0370' 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 = '1770469' and urb_activo = '1' AND color = '0116' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0370' 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 = '1770470' 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 = '0370' 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 = '1791267' and urb_activo = '1' AND color = '0174' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0235' 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 = '1791391' and urb_activo = '1' AND color = '0058' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0360' 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 = '1791488' 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 = '0359' 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 = '1791490' 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 = '0359' 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 = '1791493' and urb_activo = '1' AND color = '0058' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' 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 = '1791494' and urb_activo = '1' AND color = '0058' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' 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 = '1791495' and urb_activo = '1' AND color = '0174' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' 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 = '1791496' and urb_activo = '1' AND color = '1810' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' 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 = '1791498' and urb_activo = '1' AND color = '0174' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' 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 = '1791504' and urb_activo = '1' AND color = '0543' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' 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 = '1791515' and urb_activo = '1' AND color = '1463' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' 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 = '1791519' and urb_activo = '1' AND color = '2310' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' 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 = '1791520' and urb_activo = '1' AND color = '0387' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' 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 = '1791522' and urb_activo = '1' AND color = '0058' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' 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 = '1791523' and urb_activo = '1' AND color = '1463' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0359' 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 = '1791526' 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 = '0359' 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 = '1791568' and urb_activo = '1' AND color = '1419' 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 = '1791670' 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 = '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 = '1791673' 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 = '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 = '1791675' 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 = '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 = '1791680' 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 = '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 = '1791684' and urb_activo = '1' AND color = '0070' 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 = '1791689' 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 = '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 = '3030015' 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 = '0360' 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 = '3030016' 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 = '0360' 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 = '3030017' 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 = '0360' 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 = '3030025' and urb_activo = '1' AND color = '0103' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0360' 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 = '3030030' 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 = '0360' 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 = '3030031' 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 = '0360' 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 = '3030032' 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 = '0360' 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 = '3030070' and urb_activo = '1' AND color = '0109' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0360' 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 = '3030071' and urb_activo = '1' AND color = '0298' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0360' 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 = '3030090' 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 = '0360' 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 = '3030091' and urb_activo = '1' AND color = '0435' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0360' 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 = '3030092' and urb_activo = '1' AND color = '0535' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0360' 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 = '3030093' and urb_activo = '1' AND color = '0652' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0360' 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 = '3030094' 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 = '0360' 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 = '3030095' 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 = '0360' 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 = '3030096' and urb_activo = '1' AND color = '0174' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0360' 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