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

Geci Ski si Snowboard

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  `eshop_prod_to_attributes`.`prod_id`, `eshop_products`.`manufacturer`
                                FROM     `eshop_prod_to_attributes`
                                         INNER JOIN `eshop_products`
                                         ON       `eshop_products`.`id`            = `eshop_prod_to_attributes`.`prod_id`
                                              AND `eshop_products`.`published`     = '1'
                                             and `eshop_products`.`cat_id` in ()
				 
                                WHERE    `opt_id`                                 IN ( 790)
                                GROUP BY `eshop_prod_to_attributes`.`prod_id`
                                HAVING   COUNT(DISTINCT `opt_id`) >= 1
             [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 ')
				 
                                WHERE    `opt_id`                       ' at line 6]
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 (  ( eshop_products.`published` = 1 )  ) AND ( `eshop_products`.`id` in (0) ) 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 (  ( eshop_products.`published` = 1 )  ) AND ( `eshop_products`.`id` in ' at line 9]