Raffinare
Categorie
  1. Pizzo
  2. Semplice
  3. Sirena
  4. Taglie forti
Taglio
  1. Trapezio (498)
  2. Sirena (153)
  3. Palloncino (239)
  4. Stile Principessa (217)
  5. Tubino (127)
  6. Naturale (235)
  7. Stile impero (267)
Luoghi Per Matrominio
  1. Spiaggia / Destinazione (99)
  2. Chiesa (289)
  3. Tradizionale (289)
  4. Sala (200)
  5. Giardino / Esterno (179)
Lunghezza / Strascico
  1. Mini/Corto (19)
  2. Al ginocchio (28)
  3. Sopra la caviglia (16)
  4. Alla caviglia (6)
  5. Raso terra (203)
  6. Strascico a terra (421)
  7. Strascico di corte (258)
  8. Strascico da cappella (140)
  9. Strascico da cattedrale (25)
  10. Strascico Watteau (3)
  11. Asimmetrico (27)
Scollatura
  1. Senza Spalline (362)
  2. A cuore (240)
  3. A V (115)
  4. Ad anello (40)
  5. Omerale (66)
  6. Monospalla (43)
  7. Con bretelle (25)
  8. Canotta (29)
  9. A barca (34)
  10. Quadrata (21)
  11. Stondata (79)
  12. A lupetto (14)
  13. Decorata (7)
  14. Bordo ondulato-Edge (23)
Tessuto
  1. Pizzo (301)
  2. Chiffon (167)
  3. Raso (395)
  4. Organza (142)
  5. Tulle (219)
  6. Taffeta (75)
  7. Elasticizzato Raso (11)
  8. Raso di seta-like elastico (6)
  9. Paillettato (1)
  10. Charmeuse (6)
  11. Piume (1)
Lunghezza Maniche
  1. Senza maniche (674)
  2. Maniche corte (64)
  3. Maniche lunghe (96)
  4. Mezza manica (24)
  5. Maniche a 3/4 (24)
Decorazioni
  1. Pizzo (114)
  2. Perline (392)
  3. Dettagli di cristallo (349)
  4. Applique (322)
  5. Fiocco (54)
  6. Fusciacche/nastri (81)
  7. Tiered (16)
  8. Ricami (43)
  9. Increspature (136)
  10. Fiori (90)
  11. Festoni (116)
  12. Bottoni (38)
  13. Perla (32)
  14. Gonna arricciata (293)
  15. Side-Festoni (68)
  16. Spacco frontale (18)
  17. Cristallo Pin floreale (2)
  18. Increspato (92)
  19. Cascata volant (10)
  20. Criss Cross (37)
  21. A paillette (77)
  22. Fantasia/stampa (4)
  23. Spilla di cristallo (10)
  24. Piume/Pelliccia (5)
  25. Pieghettato (15)
Dettagli Della Schiena
  1. Cerniera (586)
  2. Pizzo-up (440)
  3. Nuda (35)
Prezzo
  1. €0.00 - €158.15
  2. €158.15 - €189.78
  3. €189.78 - €207.58
  4. €207.58 - €224.38
  5. €224.38 - €701.83
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_DISPLAY_PRODUCTS_LISTING' at line 9
in:
[select distinct p.products_id,p.products_quantity, p.products_type,p.products_status,p.products_model,p.products_price,p.products_price_retail,p.products_price_sample,p.product_is_wholesale,p.product_wholesale_min,p.products_quantity, p.products_quantity_order_min, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description_it, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and p.products_id in (336,801,823,893,1087,1329,1556,1602,1625,1642,1704,1767,1900,1915,1921,1948,1971,2080,2099,2162,2278,2281,2284,2286,2287,2289,2317,2319,2328,2350,2351,2354,2407,2408,2410,2412,2413,2865,2872,2876,2881,2884,2891,2893,2894,2904,2905,2906,2907,2908,3036,3210,3221,3222,3266,3267,3269,3271,3272,4398,4410,4420,4437,4441,4475,4529,4610,4617,4620,4745,4750,4827,5163,5168,5175,5200,5207,5224,5263,5305,5311,5312,5313,5322,5382,5424,5484,5593,5646,5734,5778,6529,6556,6566,6781,6843,7118,7183,7269,7334,7447,7523,7584,11932,11991,11995,12079,12112,12317,12405,12406,12590,12823,12866,12893,13009,13285,13539,13592,13593,13789,13790,13856,13859,13864,13899,13901,13902,13936,13999,14007,14203,14223,14298,14313,14321) and p.products_quantity <> 0 and pd.language_id = '1' and ( p2c.categories_id =98 or p2c.categories_id =99 or p2c.categories_id =100 or p2c.categories_id =101 or p2c.categories_id =102 or p2c.categories_id =103 or p2c.categories_id =104 or p2c.categories_id =105 or p2c.categories_id =106 or p2c.categories_id =107 or p2c.categories_id =136 or p2c.categories_id =137 or p2c.categories_id =138 or p2c.categories_id =140 or p2c.categories_id =146 or p2c.categories_id =147 or p2c.categories_id =148 or p2c.categories_id =149 or p2c.categories_id =150 or p2c.categories_id =151 or p2c.categories_id =152 or p2c.categories_id =153 or p2c.categories_id =154 or p2c.categories_id =155 or p2c.categories_id =156 or p2c.categories_id =157 or p2c.categories_id =158 or p2c.categories_id =159 or p2c.categories_id =160 or p2c.categories_id =161 or p2c.categories_id =222 or p2c.categories_id =416 or p2c.categories_id =418 or p2c.categories_id =419) order by p.products_sort_order DESC, p.products_ordered DESC, pd.products_viewed DESC, p.products_date_added DESC limit -0, MAX_DISPLAY_PRODUCTS_LISTING]