SELECT b.nome as colore, b.chromic_order as ordine1, c.nome as rivestimentoInterno, c.chromic_order as ordine2, d.nome as coloreCucitura, d.chromic_order as ordine3, e.nome as tipoCucitura, f.nome as chiusura, a.texture, a.idDiametro, g.diametro
FROM `#__accessori_content` AS a
LEFT JOIN #__colori AS b ON a.idColore = b.id
LEFT JOIN #__rivestimento_accessori_interno AS c ON c.id = a.idRivestimentoInterno
LEFT JOIN #__colori AS d ON a.idColoreCucitura = d.id
LEFT JOIN #__tipo_cucitura AS e ON a.idTipoCucitura = e.id
LEFT JOIN #__chiusure_type AS f ON a.idChiusura = f.id
LEFT JOIN #__diametri_cassa AS g ON a.idDiametro = g.id
WHERE a.accessorioId = 31 AND a.idDiametro = 4 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Marrone Scuro
Marrone
Beige
Cucito a mano
Ardiglione
Marrone Scuro
Marrone
Beige
Cucito a mano
Regolabile
SELECT b.nome as colore, b.chromic_order as ordine1, c.nome as rivestimentoInterno, c.chromic_order as ordine2, d.nome as coloreCucitura, d.chromic_order as ordine3, e.nome as tipoCucitura, f.nome as chiusura, a.texture, a.idDiametro, g.diametro
FROM `#__accessori_content` AS a
LEFT JOIN #__colori AS b ON a.idColore = b.id
LEFT JOIN #__rivestimento_accessori_interno AS c ON c.id = a.idRivestimentoInterno
LEFT JOIN #__colori AS d ON a.idColoreCucitura = d.id
LEFT JOIN #__tipo_cucitura AS e ON a.idTipoCucitura = e.id
LEFT JOIN #__chiusure_type AS f ON a.idChiusura = f.id
LEFT JOIN #__diametri_cassa AS g ON a.idDiametro = g.id
WHERE a.accessorioId = 31 AND a.idDiametro = 5 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Marrone Scuro
Marrone
Beige
Cucito a mano
Ardiglione
Marrone Scuro
Marrone
Beige
Cucito a mano
Regolabile
SELECT b.nome as colore, b.chromic_order as ordine1, c.nome as rivestimentoInterno, c.chromic_order as ordine2, d.nome as coloreCucitura, d.chromic_order as ordine3, e.nome as tipoCucitura, f.nome as chiusura, a.texture, a.idDiametro, g.diametro
FROM `#__accessori_content` AS a
LEFT JOIN #__colori AS b ON a.idColore = b.id
LEFT JOIN #__rivestimento_accessori_interno AS c ON c.id = a.idRivestimentoInterno
LEFT JOIN #__colori AS d ON a.idColoreCucitura = d.id
LEFT JOIN #__tipo_cucitura AS e ON a.idTipoCucitura = e.id
LEFT JOIN #__chiusure_type AS f ON a.idChiusura = f.id
LEFT JOIN #__diametri_cassa AS g ON a.idDiametro = g.id
WHERE a.accessorioId = 31 AND a.idDiametro = 6 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Marrone Scuro
Marrone
Beige
Cucito a mano
Ardiglione
Marrone Scuro
Marrone
Beige
Cucito a mano
Regolabile