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, t5.immagine, 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 LEFT JOIN tbl_hits As t7 ON t3.ID = t7.id_variante WHERE t1.visibile = true AND t4.alias = 'nylon' AND t6.alias = 'rosa' ORDER BY t7.hits DESC, t3.data_modifica DESC LIMIT 0, 12