Fatal error: Uncaught Exception: Error: 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 'lead ld
LEFT JOIN lead_transaction ldt ON ldt.lead_id=ld.lead_id
Wh' at line 1<br />Error No: 1064<br />Select GROUP_CONCAT(ld.category_id) as category_id from lead ld
LEFT JOIN lead_transaction ldt ON ldt.lead_id=ld.lead_id
Where ld.date_added >= DATE_ADD(NOW(),INTERVAL -7 DAY) And ld.date_added <= NOW() And ldt.is_duplicate = 0 and ldt.order_status_id = 19 in /home/jebkharc/kanjusee.com/system/library/db/mysqli.php:40
Stack trace:
#0 /home/jebkharc/kanjusee.com/system/library/db.php(17): DB\MySQLi->query('Select GROUP_CO...', Array)
#1 /home/jebkharc/kanjusee.com/catalog/model/extension/module/tradingleads.php(241): DB->query('Select GROUP_CO...')
#2 /home/jebkharc/kanjusee.com/vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(395): ModelExtensionModuleTradingleads->getCategoryByTradingLeads()
#3 /home in /home/jebkharc/kanjusee.com/system/library/db/mysqli.php on line 40