SELECT (SELECT GROUP_CONCAT(ia.imageId order by ia.sortOrder asc) FROM store_item_images ia WHERE ia.itemId = t.id) as images, t.*,t2.quantity FROM store_items t LEFT JOIN store_skus t2 ON t2.itemId = t.id WHERE t.id in () and t.hidden <= 0 AND t.businessId = :val0 AND t.new = 0 AND t2.quantity > 0 AND t.disabled <= :val1 LIMIT 0, 15
exception 'PDOException' with 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 ') and t.hidden <= 0 AND t.businessId = '0' AND t.new = 0 AND t2.quantity > 0 AND' at line 1' in /opt/www/jf/2016-12-21/juvo/data/BaseRecord.php:711 Stack trace: #0 /opt/www/jf/2016-12-21/juvo/data/BaseRecord.php(711): PDOStatement->execute() #1 /opt/www/grandmashousepatterns.com/07-20-2015/app/models/StoreItemModel.php(428): juvo\data\BaseRecord::_execute('SELECT (SELECT ...', 0, 0) #2 /opt/www/grandmashousepatterns.com/07-20-2015/app/controllers/StoreController.php(131): app\models\StoreItemModel::fetchFilteredRangeOfItems(0, 15, NULL, 0, 0, Array, NULL) #3 /opt/www/jf/2016-12-21/juvo/controllers/BaseController.php(221): app\controllers\StoreController->indexAction() #4 /opt/www/jf/2016-12-21/juvo/controllers/BaseController.php(353): juvo\controllers\BaseController::linearDispatch(Object(app\controllers\StoreController)) #5 /opt/www/jf/2016-12-21/juvo/core/Application.php(463): juvo\controllers\BaseController->dispatch() #6 /opt/www/grandmashousepatterns.com/07-20-2015/app/public/__index__.php(17): juvo\core\Application->run() #7 {main}
PHP Fatal error:  Uncaught exception 'PDOException' with 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 ') and t.hidden <= 0 AND t.businessId = '0' AND t.new = 0 AND t2.quantity > 0 AND' at line 1' in /opt/www/jf/2016-12-21/juvo/data/BaseRecord.php:711
Stack trace:
#0 /opt/www/jf/2016-12-21/juvo/data/BaseRecord.php(711): execute()
#1 /opt/www/grandmashousepatterns.com/07-20-2015/app/models/StoreItemModel.php(428): _execute(string, integer, integer)
#2 /opt/www/grandmashousepatterns.com/07-20-2015/app/controllers/StoreController.php(131): fetchFilteredRangeOfItems(integer, integer, NULL, integer, integer, array, NULL)
#3 /opt/www/jf/2016-12-21/juvo/controllers/BaseController.php(221): indexAction()
#4 /opt/www/jf/2016-12-21/juvo/controllers/BaseController.php(353): linearDispatch(object)
#5 /opt/www/jf/2016-12-21/juvo/core/Application.php(463): dispatch()
#6 /opt/www/grandmashousepatterns.com/07-20-2015/app/public/__index__.php(17): run()
#7 {main}
  thrown in /opt/www/jf/2016-12-21/juvo/data/BaseRecord.php on line 711