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 12,11
Tappeti Moderni per Divani in Salotto | Morandi Tappeti
0 0
AGRA VECCHIO
Morandi Tappeti In stock
AGRA VECCHIO
cod. 9924
cm 125 x 208

500

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9901
cm 205 x 260

3.000

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

8.500

SHIRVAN
Morandi Tappeti In stock
SHIRVAN
cod. 9922
cm 112 x 183

1.000

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9900
cm 204 x 302

3.000

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9898
cm 200 x 312

3.300

ISFAHAN NAJAFABAD
Morandi Tappeti In stock
ISFAHAN NAJAFABAD
cod. 9920
cm 128 x 193

730

BHADOHI
Morandi Tappeti In stock
BHADOHI
cod. 9897
cm 193 x 303

3.000

KUM SETA
Morandi Tappeti In stock
KUM SETA
cod. 9917
cm 104 x 164

1.000

BREZZA
Morandi Tappeti In stock
BREZZA
cod. 9896
cm 203 x 249

5.000

KUBA
Morandi Tappeti In stock
KUBA
cod. 9916
cm 130 x 195

2.500

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9768
cm 106 x 150

150