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 ')' at line 1
SELECT 
  COUNT(*) 
FROM 
  `sales_transactions` AS `main_table` 
WHERE 
  (main_table.customer_id =)
#0 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/lib/Zend/Db/Statement.php(320): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #3 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT COUNT(*)...', Array) #4 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/lib/Varien/Db/Adapter/Pdo/Mysql.php(421): Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(*)...', Array) #5 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/lib/Zend/Db/Adapter/Abstract.php(825): Varien_Db_Adapter_Pdo_Mysql->query('SELECT COUNT(*)...', Array) #6 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array) #7 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/lib/Varien/Data/Collection.php(225): Varien_Data_Collection_Db->getSize() #8 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/lib/Varien/Data/Collection.php(211): Varien_Data_Collection->getLastPageNumber() #9 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/lib/Varien/Data/Collection/Db.php(516): Varien_Data_Collection->getCurPage() #10 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/lib/Varien/Data/Collection/Db.php(563): Varien_Data_Collection_Db->_renderLimit() #11 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/app/code/local/Mindbench/Salesinfo/Block/Overview.php(22): Varien_Data_Collection_Db->load() #12 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/var/ait_rewrite/Mage_Core_Block_Abstract.php(244): Mindbench_Salesinfo_Block_Overview->_prepareLayout() #13 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/app/code/core/Mage/Core/Model/Layout.php(456): Aitoc_Aitsys_Model_Rewriter_Mage_Core_Block_Abstract->setLayout(Object(Inchoo_PHP7_Model_Layout)) #14 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/app/code/core/Mage/Core/Model/Layout.php(472): Mage_Core_Model_Layout->createBlock('mindbench_trans...', 'transactions_ov...') #15 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/app/code/core/Mage/Core/Model/Layout.php(239): Mage_Core_Model_Layout->addBlock('mindbench_trans...', 'transactions_ov...') #16 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/app/code/core/Mage/Core/Model/Layout.php(205): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element)) #17 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element)) #18 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/app/code/core/Mage/Core/Controller/Varien/Action.php(344): Mage_Core_Model_Layout->generateBlocks() #19 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/app/code/core/Mage/Core/Controller/Varien/Action.php(269): Mage_Core_Controller_Varien_Action->generateLayoutBlocks() #20 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/app/code/local/Mindbench/Transactions/controllers/IndexController.php(5): Mage_Core_Controller_Varien_Action->loadLayout() #21 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mindbench_Transactions_IndexController->indexAction() #22 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('index') #23 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #24 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() #25 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/app/Mage.php(682): Mage_Core_Model_App->run(Array) #26 /home/shop_production/htdocs/cp.horsecenter.nl/site/web/index.php(88): Mage::run('hch_cp', 'website') #27 {main}