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 b.parent=2 AND a.t_fasciaprezzodef=3 AND FIND_IN_SET('7',a.t_caratteristiche) > 0 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_prezzodef ASC LIMIT 0,12
tappeti tra 500 e 1500 euro con medaglione centrale tappeti persiani su Morandi Tappeti
array(8) { [0]=> array(3) { ["id"]=> string(1) "1" ["nome"]=> string(15) "tappeti moderni" ["url"]=> string(31) "tappeti-moderni-e-contemporanei" } [1]=> array(3) { ["id"]=> string(2) "48" ["nome"]=> string(24) "tappeti di design d'arte" ["url"]=> string(27) "tappeti-design-tappeti-arte" } [2]=> array(3) { ["id"]=> string(1) "2" ["nome"]=> string(16) "tappeti persiani" ["url"]=> string(16) "tappeti-persiani" } [3]=> array(3) { ["id"]=> string(1) "3" ["nome"]=> string(16) "tappeti classici" ["url"]=> string(16) "tappeti-classici" } [4]=> array(3) { ["id"]=> string(1) "4" ["nome"]=> string(17) "tappeti caucasici" ["url"]=> string(17) "tappeti-caucasici" } [5]=> array(3) { ["id"]=> string(1) "5" ["nome"]=> string(29) "tappeti antichi da collezione" ["url"]=> string(29) "tappeti-antichi-da-collezione" } [6]=> array(3) { ["id"]=> string(1) "6" ["nome"]=> string(5) "kilim" ["url"]=> string(5) "kilim" } [7]=> array(3) { ["id"]=> string(2) "52" ["nome"]=> string(23) "tappeti per arredamento" ["url"]=> string(23) "tappeti-per-arredamento" } }
KIRMANSHA
Morandi Tappeti In stock
KIRMANSHA
cod. 4930
cm 132 x 198

700

JOSEGAN
Morandi Tappeti In stock
JOSEGAN
cod. 9904
cm 130 x 202

850

KASHAN
Morandi Tappeti In stock
KASHAN
cod. 8056
cm 147 x 288

1.000

SAROUK FERAHAN
Morandi Tappeti In stock
SAROUK FERAHAN
cod. 8656
cm 46 x 74

1.150

QAZVIN
Morandi Tappeti In stock
QAZVIN
cod. 8657
cm 55 x 75

1.150

BAKHTIARI
Morandi Tappeti In stock
BAKHTIARI
cod. 7861
cm 132 x 204

1.200

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

1.200

KASHAN
Morandi Tappeti In stock
KASHAN
cod. 8059
cm 146 x 262

1.200

SAROUK
Morandi Tappeti In stock
SAROUK
cod. 9542
cm 80 x 90

1.300

HAMADAN
Morandi Tappeti In stock
HAMADAN
cod. 5283
cm 116 x 303

1.450

KIRMAN
Morandi Tappeti In stock
KIRMAN
cod. 3176
cm 70 x 94

1.500

TAFRESH
Morandi Tappeti In stock
TAFRESH
cod. 9231
cm 140 x 194

1.500