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_stanze LIKE '%,6,%' OR a.t_stanze LIKE '%6,%') 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 Moderni per Divani in Salotto | Morandi Tappeti
0 0
MAGMA
Morandi Tappeti In stock
MAGMA
cod. 10130
cm 161 x 222

3.800

MAHAJERAN
Morandi Tappeti In stock
MAHAJERAN
cod. 10122
cm 75 x 145

2.250

TIBET JOAN MIRO
Morandi Tappeti In stock
TIBET JOAN MIRO
cod. 10133
cm 143 x 195

2.350

PANDERMA
Morandi Tappeti In stock
PANDERMA
cod. 10084
cm 125 x 180

250

TIBET
Morandi Tappeti In stock
TIBET
cod. 10136
cm 89 x 150

1.000

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 10129
cm 150 x 213

2.200

NEPAL
Morandi Tappeti In stock
NEPAL
cod. 10127
cm 246 x 336

500

KIRMAN
Morandi Tappeti In stock
KIRMAN
cod. 10038
cm 135 x 263

630

KIRMAN
Morandi Tappeti In stock
KIRMAN
cod. 10132
cm 179 x 288

2.000

NEPAL
Morandi Tappeti In stock
NEPAL
cod. 10126
cm 193 x 286

250

TIBET
Morandi Tappeti In stock
TIBET
cod. 10137
cm 92 x 151

1.000

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9772
cm 102 x 145

145