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 (a.t_stanze LIKE '%,3,%' OR a.t_stanze LIKE '%3,%') 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_id DESC LIMIT 0,11
Tappeti da Corridoio Moderni | Morandi Tappeti
0 0
KAZAK
Morandi Tappeti In stock
KAZAK
cod. 9999
cm 100 x 150

1.850

MADEN
Morandi Tappeti In stock
MADEN
cod. 10058
cm 156 x 283

1.500

KUM
Morandi Tappeti In stock
KUM
cod. 10056
cm 218 x 334

2.200

SAMARCANDA
Morandi Tappeti In stock
SAMARCANDA
cod. 10105
cm 178 x 275

420

KONIA
Morandi Tappeti In stock
KONIA
cod. 10081
cm 108 x 221

1.500

KHOTAN
Morandi Tappeti In stock
KHOTAN
cod. 10097
cm 92 x 146

150

SAROUK
Morandi Tappeti In stock
SAROUK
cod. 10039
cm 133 x 216

1.200

KASHAN DABIR
Morandi Tappeti In stock
KASHAN DABIR
cod. 10055
cm 121 x 207

2.000

DOROSH
Morandi Tappeti In stock
DOROSH
cod. 10054
cm 117 x 206

1.500

KHOTAN
Morandi Tappeti In stock
KHOTAN
cod. 10096
cm 86 x 170

100

TIBET
Morandi Tappeti In stock
TIBET
cod. 10095
cm 60 x 137

150

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9816
cm 63 x 104

60