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_colore LIKE '%,20,%') 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 Lilla Annodati a Mano | Morandi Tappeti
0 0
TIBET
Morandi Tappeti In stock
TIBET
cod. 10139
cm 91 x 153

1.000

TIBET
Morandi Tappeti In stock
TIBET
cod. 10140
cm 92 x 151

1.000

TIBET
Morandi Tappeti In stock
TIBET
cod. 10138
cm 92 x 152

1.000

TASHPINAR
Morandi Tappeti In stock
TASHPINAR
cod. 10085
cm 130 x 198

450

KIRMAN RAVER
Morandi Tappeti In stock
KIRMAN RAVER
cod. 10075
cm 305 x 364

8.000

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

1.500

NEPAL
Morandi Tappeti In stock
NEPAL
cod. 10113
cm 205 x 290

250

YUNDAG
Morandi Tappeti In stock
YUNDAG
cod. 10080
cm 107 x 325

400

NEPAL
Morandi Tappeti In stock
NEPAL
cod. 10111
cm 200 x 198

200

SAROUK
Morandi Tappeti In stock
SAROUK
cod. 9925
cm 144 x 231

2.500

TIBET
Morandi Tappeti In stock
TIBET
cod. 8686
cm 240 x 240

5.000

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9818
cm 65 x 88

55