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 '%,8,%') 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_prezzodef ASC LIMIT 24,11
Tappeti Azzurri Annodati a Mano | Morandi Tappeti
0 0
KIRMAN LAVER
Morandi Tappeti In stock
KIRMAN LAVER
cod. 9590
cm 197 x 300

1.250

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9258
cm 142 x 197

1.500

MESHKIN
Morandi Tappeti In stock
MESHKIN
cod. 8316
cm 112 x 318

1.500

KASHAN
Morandi Tappeti In stock
KASHAN
cod. 9908
cm 304 x 425

1.500

KIRMAN
Morandi Tappeti In stock
KIRMAN
cod. 9906
cm 267 x 376

1.500

ARDEBIL F.S.
Morandi Tappeti In stock
ARDEBIL F.S.
cod. 7817
cm 135 x 186

1.650

MALAYER
Morandi Tappeti In stock
MALAYER
cod. 8647
cm 100 x 182

1.850

KIRMAN
Morandi Tappeti In stock
KIRMAN
cod. 8646
cm 78 x 178

2.100

MISHAN MALAYER
Morandi Tappeti In stock
MISHAN MALAYER
cod. 9934
cm 129 x 170

2.200

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 7722
cm 168 x 239

2.200

MALAYER
Morandi Tappeti In stock
MALAYER
cod. 8641
cm 96 x 178

2.250

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9648
cm 64 x 149

95