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 '%,41,%') 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 Senape Annodati a Mano | Morandi Tappeti
0 0
SPARTA
Morandi Tappeti In stock
SPARTA
cod. 10069
cm 286 x 384

2.500

CINA
Morandi Tappeti In stock
CINA
cod. 9975
cm 159 x 159

250

HAMADAN
Morandi Tappeti In stock
HAMADAN
cod. 9957
cm 102 x 318

250

KUM SETA
Morandi Tappeti In stock
KUM SETA
cod. 9933
cm 133 x 197

1.000

KIRMAN RAVER
Morandi Tappeti In stock
KIRMAN RAVER
cod. 9926
cm 132 x 194

2.500

KAZAK LORI PAMPAK
Morandi Tappeti In stock
KAZAK LORI PAMPAK
cod. 9923
cm 128 x 202

8.500

MARASALI
Morandi Tappeti In stock
MARASALI
cod. 9876
cm 120 x 141

5.000

GOOM
Morandi Tappeti In stock
GOOM
cod. 9875
cm 142 x 213

2.400

MARA
Morandi Tappeti In stock
MARA
cod. 9571
cm 160 x 253

5.000

TIBET SMERALDO
Morandi Tappeti In stock
TIBET SMERALDO
cod. 9529
cm 240 x 303

6.500

TIBET
Morandi Tappeti In stock
TIBET
cod. 9163
cm 198 x 288

5.000

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9752
cm 61 x 154

105