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 = '0841476' and urb_activo = '1' AND color = '0017' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0391' 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 = '0841477' and urb_activo = '1' AND color = '2394' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0391' 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 = '0841478' 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 = '0050' 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 = '1471995' and urb_activo = '1' AND color = '0983' GROUP BY talla ORDER BY talla
) as tallas_modelo
LEFT JOIN larpi_0000002570_ecomer.gtallal ON gtallal.gtalla = '0418' 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