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 = 13 AND a.idDiametro = 1 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Nero
Nero
Nero
Cucito a macchina
Regolabile
Marrone Chiaro
Beige
Marrone Chiaro
Cucito a macchina
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 = 13 AND a.idDiametro = 2 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Nero
Nero
Nero
Cucito a macchina
Regolabile
Marrone Chiaro
Beige
Marrone Chiaro
Cucito a macchina
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 = 13 AND a.idDiametro = 3 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Nero
Nero
Nero
Cucito a macchina
Regolabile
Nero
Nero
Beige
Cucito a macchina
Ardiglione
Nero
Nero
Beige
Cucito a macchina
Ardiglione
Burgundy
Beige
Nero
Cucito a macchina
Ardiglione
Marrone Chiaro
Marrone Chiaro
Marrone Chiaro
Cucito a mano
Ardiglione
Marrone Chiaro
Beige
Marrone Chiaro
Cucito a macchina
Regolabile
Marrone Chiaro
Beige
Marrone Chiaro
Cucito a macchina
Ardiglione
Marrone Chiaro
Beige
Marrone Chiaro
Cucito a mano
Ardiglione
Marrone Chiaro
Beige
Giallo
Cucito a macchina
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 = 13 AND a.idDiametro = 5 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Nero
Nero
Nero
Cucito a mano
Ardiglione
Nero
Nero
Écrue
Cucito a mano
Ardiglione
Burgundy
Beige
Burgundy
Cucito a mano
Ardiglione
Marrone Chiaro
Beige
Marrone Chiaro
Cucito a mano
Ardiglione
Marrone Chiaro
Beige
Écrue
Cucito a mano
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 = 13 AND a.idDiametro = 6 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Nero
Nero
Nero
Cucito a mano
Ardiglione
Nero
Nero
Écrue
Cucito a mano
Ardiglione
Burgundy
Beige
Burgundy
Cucito a mano
Ardiglione
Marrone Chiaro
Beige
Marrone Chiaro
Cucito a mano
Ardiglione
Marrone Chiaro
Beige
Écrue
Cucito a mano
Ardiglione