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 '%,19,%') 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 Grigio scuro Annodati a Mano | Morandi Tappeti
0 0
BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9877
cm 200 x 301

3.000

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9355
cm 120 x 185

1.200

BRONZO FUSO
Morandi Tappeti In stock
BRONZO FUSO
cod. 9197
cm 245 x 301

6.500

TIBET DESTRUTTURATO
Morandi Tappeti In stock
TIBET DESTRUTTURATO
cod. 9206
cm 84 x 121

950

BREZZA
Morandi Tappeti In stock
BREZZA
cod. 9183
cm 186 x 283

5.000

MALAYER
Morandi Tappeti In stock
MALAYER
cod. 9019
cm 101 x 293

2.500

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 8714
cm 174 x 240

2.500

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 8680
cm 252 x 306

3.850

LUSSURIA
Morandi Tappeti In stock
LUSSURIA
cod. 7651
cm 255 x 306

7.200

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 8253
cm 251 x 355

4.650

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 8259
cm 71 x 144

380

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9658
cm 89 x 191

180