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=5 AND ( (a.t_codice = '') OR (a.t_nome LIKE '%%') OR (b.nomeITA LIKE '%%') OR (c.nomeITA LIKE '%%') OR (e.p_provenienza LIKE '%%')) AND t_stato!=2 AND t_stato!=5 AND t_stato!=3 AND (t_status=1) ORDER BY t_id DESC LIMIT 0,12
tappeti 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" } }
KARAMAN
Morandi Tappeti In stock
KARAMAN
cod. 9929
cm 139 x 211

3.500

KULA
Morandi Tappeti In stock
KULA
cod. 9921
cm 110 x 178

1.000

YOMUT
Morandi Tappeti In stock
YOMUT
cod. 9853
cm 190 x 315

4.800

PECHINO
Morandi Tappeti In stock
PECHINO
cod. 9872
cm 90 x 146

2.450

BERGAMA
Morandi Tappeti In stock
BERGAMA
cod. 9868
cm 180 x 191

7.850

PECHINO
Morandi Tappeti In stock
PECHINO
cod. 9851
cm 67 x 85

450

PECHINO
Morandi Tappeti In stock
PECHINO
cod. 9849
cm 67 x 85

450

PECHINO
Morandi Tappeti In stock
PECHINO
cod. 9836
cm 150 x 155

4.850

GHIORDES
Morandi Tappeti In stock
GHIORDES
cod. 9830
cm 130 x 175

12.800

SARYK
Morandi Tappeti In stock
SARYK
cod. 9581
cm 119 x 77

3.200

BESHIR
Morandi Tappeti In stock
BESHIR
cod. 9578
cm 158 x 382

8.500

YARKAND
Morandi Tappeti In stock
YARKAND
cod. 9316
cm 210 x 414

12.800