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 = '0841485' and urb_activo = '1' AND color = '2396' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0394' 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 = '0841486' and urb_activo = '1' AND color = '2397' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0394' 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 = '0841487' and urb_activo = '1' AND color = '2396' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0394' 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 = '0841488' and urb_activo = '1' AND color = '0010' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0394' 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 = '0841489' and urb_activo = '1' AND color = '2398' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0394' 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 = '0841490' and urb_activo = '1' AND color = '0053' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0394' 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 = '0841507' and urb_activo = '1' AND color = '2397' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0112' 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 = '1250135' and urb_activo = '1' AND color = '0048' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0082' 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 = '1290217' 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 = '0403' 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 = '1471972' and urb_activo = '1' AND color = '0289' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0082' 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 = '1471973' and urb_activo = '1' AND color = '1477' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0082' 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 = '1471974' and urb_activo = '1' AND color = '0200' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0082' 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 = '1472022' and urb_activo = '1' AND color = '0584' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0082' 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 = '1472023' 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 = '0082' 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 = '1472024' and urb_activo = '1' AND color = '0584' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0082' 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 = '1472025' 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 = '0082' 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 = '1472026' 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 = '0082' 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 = '1472027' 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 = '0082' 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 = '1472028' and urb_activo = '1' AND color = '0200' GROUP BY talla ORDER BY talla ) as tallas_modelo LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0082' 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