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 108,11
Tappeti Rossi Annodati a Mano | Morandi Tappeti
0 0
KUM SETA
Morandi Tappeti In stock
KUM SETA
cod. 9858
cm 107 x 152

1.200

KASKULI
Morandi Tappeti In stock
KASKULI
cod. 3350
cm 82 x 195

960

BELUCI
Morandi Tappeti In stock
BELUCI
cod. 9822
cm 96 x 163

100

YALAMEH
Morandi Tappeti In stock
YALAMEH
cod. 8202
cm 80 x 192

500

LORI GABBEH
Morandi Tappeti In stock
LORI GABBEH
cod. 3931
cm 107 x 141

900

SAROUK
Morandi Tappeti In stock
SAROUK
cod. 9280
cm 101 x 144

1.500

FAKRALO
Morandi Tappeti In stock
FAKRALO
cod. 8348
cm 96 x 147

5.000

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 8993
cm 92 x 152

700

BELUCI
Morandi Tappeti In stock
BELUCI
cod. 9022
cm 94 x 147

320

BUKHARA
Morandi Tappeti In stock
BUKHARA
cod. 6709
cm 97 x 138

860

SRINAGAR SETA
Morandi Tappeti In stock
SRINAGAR SETA
cod. 8582
cm 82 x 152

500

KILIM MODERN
Morandi Tappeti In stock
KILIM MODERN
cod. 9664
cm 150 x 197

310