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_dimricerca LIKE '%,7,%' 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) ASC LIMIT 96,11
tappeti dosar o sejadeh | 110/160 - 170/210 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" } }
HYDERABAD
Morandi Tappeti In stock
HYDERABAD
cod. 5052
cm 143 x 196

1.550

ZANDJAN
Morandi Tappeti In stock
ZANDJAN
cod. 7808
cm 139 x 202

2.150

SENNEH
Morandi Tappeti In stock
SENNEH
cod. 7809
cm 203 x 140

3.500

KASHAN
Morandi Tappeti In stock
KASHAN
cod. 8538
cm 136 x 209

1.500

CI CI
Morandi Tappeti In stock
CI CI
cod. 9552
cm 139 x 205

8.500

KAZAK
Morandi Tappeti In stock
KAZAK
cod. 0402
cm 150 x 191

9.200

UZBEK
Morandi Tappeti In stock
UZBEK
cod. 9090
cm 143 x 201

1.100

PESHAWAR
Morandi Tappeti In stock
PESHAWAR
cod. 6049
cm 153 x 188

2.250

KAMSEH
Morandi Tappeti In stock
KAMSEH
cod. 9218
cm 145 x 200

7.300

ISLAMABAD
ora in outlet
Morandi Tappeti In stock
ISLAMABAD
cod. 8336
cm 137 x 212

€ 700 490

MACRì
Morandi Tappeti In stock
MACRì
cod. 9930
cm 125 x 235

380

KILIM KASKAI
Morandi Tappeti In stock
KILIM KASKAI
cod. 8866
cm 145 x 199

400