SELECT a.t_id, a.t_codice, a.t_nome, a.t_outlet, a.t_sconto_outlet, a.t_larghezza, a.t_lunghezza, a.t_prezzo, a.t_prezzodef, a.t_url, c.nomeITA AS nomecategoria FROM tappeti AS a, categoria AS b, categoria AS c, tappeti_categorie AS d, provenienze AS e WHERE d.tappeto = a.t_id AND d.categoria = b.id AND b.parent = c.id AND a.t_provenienza = e.p_id AND b.parent=2 AND a.t_fasciaprezzodef=5 AND a.t_dimricerca LIKE '%,3,%' AND ( (a.t_codice = 'Isfahan') OR (a.t_nome LIKE '%Isfahan%') OR (b.nomeITA LIKE '%Isfahan%') OR (c.nomeITA LIKE '%Isfahan%') OR (e.p_provenienza LIKE '%Isfahan%')) AND t_stato!=2 AND t_stato!=5 AND t_stato!=3 AND (t_status=1) AND ( (d.categoria != 41) AND (d.categoria != 42) AND (d.categoria != 45) AND (d.categoria != 56) ) ORDER BY (t_larghezza * t_lunghezza) ASC LIMIT 0,12
SELECT a.t_id, a.t_codice, a.t_nome, a.t_outlet, a.t_sconto_outlet, a.t_larghezza, a.t_lunghezza, a.t_prezzo, a.t_prezzodef, a.t_url, c.nomeITA AS nomecategoria FROM tappeti AS a, categoria AS b, categoria AS c, tappeti_categorie AS d, provenienze AS e WHERE d.tappeto = a.t_id AND d.categoria = b.id AND b.parent = c.id AND a.t_provenienza = e.p_id AND b.parent=2 AND a.t_fasciaprezzodef=5 AND a.t_dimricerca LIKE '%,3,%' AND ( (a.t_codice = 'isfahan') OR (a.t_nome LIKE '%isfahan%') OR (b.nomeITA LIKE '%isfahan%') OR (c.nomeITA LIKE '%isfahan%') OR (e.p_provenienza LIKE '%isfahan%')) AND t_stato!=2 AND t_stato!=5 AND t_stato!=3 AND (t_status=1) AND ( (d.categoria != 41) AND (d.categoria != 42) AND (d.categoria != 45) AND (d.categoria != 56) ) ORDER BY (t_larghezza * t_lunghezza) ASC LIMIT 0,12
tappeti Isfahan su Morandi Tappeti

Nessun risultato trovato