MOCHILA CERNINO 30 ROJO CAPACIDAD 30L NYLON RIPSTOP TIRAS PORTAMATERIALES CORREAS DE COMPRESIÓN ESPALDA ACOLCHADA DE REJILLA TRANSPIRABLE CEÑIDOR AJUSTABLE CON SILBATO DE EMERGENCIA CORREAS ERGONÓMICAS CON CIERRE FRONTAL FUNDA IMPERMEABLE

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 = '3190134' 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 = '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