DaoZen.Message: SQLSTATE[42000]: Syntax error or access violation: 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 'FROM `product_item` LEFT JOIN `product_category` cat ON cat.id = `product_' at line 5
DaoZen.Location: /home/customer/000005/site/www.gifts24.pl/www/framework/libs/daozen/queryBuilder.php at 331
DaoZen.Trace: #0 /home/customer/000005/site/www.gifts24.pl/www/framework/libs/daozen/queryBuilder.php(331): PDOStatement->execute() #1 /home/customer/000005/site/www.gifts24.pl/www/framework/libs/daozen/records.php(138): DaoZen_QueryBuilder->select(Object(ProductItemSearch)) #2 /home/customer/000005/site/www.gifts24.pl/www/framework/libs/daozen.php(149): DaoZen_Records->select(Object(ProductItemSearch)) #3 /home/customer/000005/site/www.gifts24.pl/www/framework/libs/daozen/search.php(261): DaoZen->findBy(Object(ProductItemSearch)) #4 /home/customer/000005/site/www.gifts24.pl/www/runtime/admin/app/modules/product/productitem.php(672): DaoZen_Search->findAll() #5 /home/customer/000005/site/www.gifts24.pl/www/runtime/gifts24/app/modules/index/indexApplication.php(284): ProductItem::getProductsCount(Object(ProductCategory), 10000, true, false, 'all', 'szczegoly', 0, 1, NULL, NULL, Array) #6 [internal function]: IndexApplication->actionCategory('dom-i-czas-woln...') #7 /home/customer/000005/site/www.gifts24.pl/www/framework/controller.php(692): call_user_func_array(Array, Array) #8 /home/customer/000005/site/www.gifts24.pl/www/framework/callisto.php(641): Controller->execute() #9 /home/customer/000005/site/www.gifts24.pl/www/framework/callisto.php(714): Callisto->initController() #10 /home/customer/000005/site/www.gifts24.pl/www/index.php(28): Callisto->run() #11 {main}
DaoZen.Query: SELECT `product_item`.id, v.marge as marge, IF (a4 = 1, `product_item`.price, `product_item`.price * (1 + marge /100)) as price, FROM `product_item` LEFT JOIN `product_category` cat ON cat.id = `product_item`.category_id LEFT JOIN `product_vendor` v ON `product_item`.vendor_id = v.id WHERE (`product_item`.`avail`=:where0 AND (`product_item`.`category_id`=:where1 OR (cat.`lft`>=:where2 AND cat.`rgt`<=:where3))) HAVING (`price`>=:where4 AND `price`<=:where5)