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 '%,4,%') 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 Ambra Annodati a Mano | Morandi Tappeti
0 0
TABRIZ 70 RAJ
Morandi Tappeti In stock
TABRIZ 70 RAJ
cod. 10067
cm 350 x 450

5.000

KURDISTAN
Morandi Tappeti In stock
KURDISTAN
cod. 9941
cm 100 x 340

950

GHAZNI
Morandi Tappeti In stock
GHAZNI
cod. 9711
cm 173 x 239

2.500

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9332
cm 266 x 365

6.800

KASIM USHAK
Morandi Tappeti In stock
KASIM USHAK
cod. 9011
cm 135 x 183

5.000

TIBET SMERALDO
Morandi Tappeti In stock
TIBET SMERALDO
cod. 8981
cm 245 x 311

6.500

TIBET
Morandi Tappeti In stock
TIBET
cod. 8697
cm 268 x 367

5.000

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

5.000

TIBET
Morandi Tappeti In stock
TIBET
cod. 8675
cm 242 x 307

7.300

MALAYER
Morandi Tappeti In stock
MALAYER
cod. 8639
cm 105 x 142

2.200

AGRA ANTICO
Morandi Tappeti In stock
AGRA ANTICO
cod. 8367
cm 294 x 387

11.700

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9685
cm 106 x 156

150