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 = 15 AND a.idDiametro = 1 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Nero
Nero
Senza Cucitura
Senza Cucitura
Ardiglione
Nero
Nero
Senza Cucitura
Senza Cucitura
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 = 15 AND a.idDiametro = 2 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Nero
Nero
Senza Cucitura
Senza Cucitura
Ardiglione
Nero
Nero
Senza Cucitura
Senza Cucitura
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 = 15 AND a.idDiametro = 3 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Nero
Nero
Senza Cucitura
Senza Cucitura
Regolabile
Nero
Nero
Senza Cucitura
Senza Cucitura
Ardiglione
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 = 15 AND a.idDiametro = 5 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Nero
Nero
Senza Cucitura
Senza Cucitura
Ardiglione
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 = 15 AND a.idDiametro = 6 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Nero
Nero
Senza Cucitura
Senza Cucitura
Ardiglione