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 '%,29,%') 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_larghezza * t_lunghezza) DESC LIMIT 120,11
Tappeti Rossi Annodati a Mano | Morandi Tappeti
0 0
BELUCI
Morandi Tappeti In stock
BELUCI
cod. 9508
cm 78 x 134

75

BELUCI
Morandi Tappeti In stock
BELUCI
cod. 8570
cm 80 x 129

135

ZIGLER
Morandi Tappeti In stock
ZIGLER
cod. 5758
cm 83 x 121

750

SARYK
Morandi Tappeti In stock
SARYK
cod. 9581
cm 119 x 77

3.200

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 8987
cm 75 x 119

500

LORI GABBEH
Morandi Tappeti In stock
LORI GABBEH
cod. 9847
cm 56 x 149

580

HAMADAN
Morandi Tappeti In stock
HAMADAN
cod. 0465
cm 63 x 81

1.200

YOMUT MAFRASH
Morandi Tappeti In stock
YOMUT MAFRASH
cod. 8748
cm 39 x 75

2.200

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9512
cm 80 x 294

250

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9385
cm 109 x 208

235

DENIZILI KILIM
Morandi Tappeti In stock
DENIZILI KILIM
cod. 8338
cm 94 x 237

500

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9638
cm 95 x 156

150