SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INNER JOIN `catalog_product_entity_int` AS `at_product_customer_group_default` O' at line 3, query was: SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_category_product` AS `store_cat_index` ON store_cat_index.product_id = e.entity_id AND store_cat_index.category_id=
 INNER JOIN `catalog_product_entity_int` AS `at_product_customer_group_default` ON (`at_product_customer_group_default`.`entity_id` = `e`.`entity_id`) AND (`at_product_customer_group_default`.`attribute_id` = '227') AND `at_product_customer_group_default`.`store_id` = 0
 LEFT JOIN `catalog_product_entity_int` AS `at_product_customer_group` ON (`at_product_customer_group`.`entity_id` = `e`.`entity_id`) AND (`at_product_customer_group`.`attribute_id` = '227') AND (`at_product_customer_group`.`store_id` = 1) WHERE (IF(at_product_customer_group.value_id > 0, at_product_customer_group.value, at_product_customer_group_default.value) != 1) AND (FIND_IN_SET(('1'), `e`.`enabled`))

#0 /var/www/huntsman-tpu.com/htdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/Zend/1.12.9/Db/Statement.php(303): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/Zend/1.12.9/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /var/Zend/1.12.9/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT COUNT(DI...', Array)
#4 /var/www/huntsman-tpu.com/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(DI...', Array)
#5 /var/Zend/1.12.9/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /var/www/huntsman-tpu.com/htdocs/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)
#7 /var/www/huntsman-tpu.com/htdocs/lib/Varien/Data/Collection.php(225): Varien_Data_Collection_Db->getSize()
#8 /var/www/huntsman-tpu.com/htdocs/lib/Varien/Data/Collection.php(211): Varien_Data_Collection->getLastPageNumber()
#9 /var/www/huntsman-tpu.com/htdocs/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1036): Varien_Data_Collection->getCurPage()
#10 /var/www/huntsman-tpu.com/htdocs/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#11 /var/www/huntsman-tpu.com/htdocs/app/code/core/Mage/Catalog/Block/Product/List.php(169): Mage_Eav_Model_Entity_Collection_Abstract->load()
#12 /var/www/huntsman-tpu.com/htdocs/app/code/core/Mage/Core/Block/Abstract.php(918): Mage_Catalog_Block_Product_List->_beforeToHtml()
#13 /var/www/huntsman-tpu.com/htdocs/app/code/core/Mage/Catalog/controllers/CategoryController.php(214): Mage_Core_Block_Abstract->toHtml()
#14 /var/www/huntsman-tpu.com/htdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Catalog_CategoryController->ajaxAction()
#15 /var/www/huntsman-tpu.com/htdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('ajax')
#16 /var/www/huntsman-tpu.com/htdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(170): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 /var/www/huntsman-tpu.com/htdocs/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#18 /var/www/huntsman-tpu.com/htdocs/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#19 /var/www/huntsman-tpu.com/htdocs/index.php(28): Mage::run('', 'store')
#20 {main}