Am deschis magazin in Brasov - str.Carpatilor nr.4 (langa Hacienda)

Carucioare copii

0 Produse

Momentan nu exista produse introduse in aceasta categorie.
In cel mai scurt timp veti putea beneficia de peste 100 de branduri si peste 2000 de produse.
Va rugam reveniti ! :)

PEAR Error 
DB Error: syntax error : SELECT  distinct `eshop_prod_to_attributes`.`opt_id` ,  `eshop_prod_to_attributes`.`attr_id` ,  `eshop_attributes_options_to_lang`.`name` as `opt_name` ,  `eshop_attributes_to_lang`.`name` as `attr_name` ,  `eshop_attributes`.`name` as `attr_ident` ,  `eshop_attributes`.`label` as `label` ,  `eshop_attributes`.`box` as `box` ,  `eshop_attributes_options`.`has_image` as `has_image` ,  `eshop_attributes_options`.`image_name` as `image_name` ,  count(distinct `eshop_products`.`id`) as products  
 FROM `eshop_prod_to_attributes` 

 INNER JOIN `eshop_attributes_options`  ON (`eshop_attributes_options`.`id`=`eshop_prod_to_attributes`.`opt_id`) 
 INNER JOIN `eshop_attributes_options_to_lang`  ON (`eshop_attributes_options_to_lang`.`opt_id`=`eshop_attributes_options`.`id`)  
 INNER JOIN `eshop_attributes`  ON (`eshop_attributes`.`id`=`eshop_attributes_options`.`attr_id`) 
 INNER JOIN `eshop_attributes_to_lang`  ON (`eshop_attributes_to_lang`.`attr_id`=`eshop_attributes`.`id`)    
 INNER JOIN `eshop_products`  ON (`eshop_products`.`id`=`eshop_prod_to_attributes`.`prod_id`)   
 WHERE (  (  ( eshop_attributes_options_to_lang.`lang_id` = 1 )  )  AND (  (  ( eshop_attributes_to_lang.`lang_id` = 1 )  )  AND ( eshop_attributes.`navigable` = '1' ) ) )  AND ( `eshop_products`.`cat_id` in () ) AND ( if (`eshop_products`.`special_start` <= now() and `eshop_products`.`special_start` != '0000-00-00 00:00:00' and (`eshop_products`.`special_end` >= now() or `eshop_products`.`special_end` = '0000-00-00 00:00:00'),`eshop_products`.`special_price`,`eshop_products`.`price`) between 1500 and 2499 ) AND (  ( eshop_products.`published` = 1 )  ) AND (  `eshop_prod_to_attributes`.`lang_id` = 1 ) 
 GROUP BY `eshop_prod_to_attributes`.`opt_id`  
 
 ORDER BY attr_order, `eshop_attributes_options`.`option_order`  
 [nativecode=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 ') ) AND ( if (`eshop_products`.`special_start` <= now() and `eshop_products`.`sp' at line 9]