Nessun risultato trovato per i criteri di ricerca !

SELECT t1.ID As id_modello, t1.nome As modello, t1.alias, t1.novita As mod_novita, t3.ID As id_variante, t3.prezzo, t3.sconto, t3.novita As var_novita, t4.ID As id_tessuto, t4.nome As tessuto, t4.alias As alias_tess, COUNT(t5.ID) As n_col, t6.ID As id_colore, t6.nome As colore, t6.alias As alias_col FROM tbl_modelli As t1 JOIN tbl_varianti As t3 ON t1.ID = t3.id_modello JOIN tbl_tessuti As t4 ON t4.ID = t3.id_tessuto JOIN tbl_varianti_colori As t5 ON t3.ID = t5.id_variante JOIN tbl_colori As t6 ON t6.ID = t5.id_colore JOIN tbl_tags_modelli As t7 ON t7.id_modello = t1.ID JOIN tbl_tags As t8 ON t7.id_tag = t8.ID WHERE t1.visibile = true AND t1.ID <> 4 AND t4.alias = 'nylon' AND t6.alias = 'verde-scuro' AND INSTR('bean bag, poltrona a sacco, poltrona a fagiolo, pouf pera, chaise longue, lettino, sdraio, poggiapiedi, poltrona, pouf, pouff, puff', t8.tag_it) <> 0 GROUP BY t3.id_modello ORDER BY RAND() LIMIT 0, 12