Error: Error: Unknown column 'su.query' in 'ON'
Error No: 1054
SELECT t.*, td.* FROM `oc_topic` t LEFT JOIN `oc_topic_description` td ON (t.topic_id = td.topic_id) LEFT JOIN `oc_seo_url` su ON (su.query = CONCAT('topic_id=', t.topic_id)) WHERE su.keyword = 'cool' AND su.language_id = '1' AND td.language_id = '1' File: /var/www/bvg159/system/library/db/mysqli.php Line: 122 Backtrace: 0 File: /var/www/bvg159/system/library/db.php Line: 54 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: /var/www/bvg159/catalog/controller/cms/amp_topic.php Line: 109 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /var/www/bvg159/catalog/controller/cms/amp_topic.php Line: 16 Class: Opencart\Catalog\Controller\Cms\AmpTopic Function: getTopicBySeoKeyword Backtrace: 3 File: /var/www/bvg159/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Cms\AmpTopic Function: index Backtrace: 4 File: /var/www/bvg159/system/framework.php Line: 259 Class: Opencart\System\Engine\Action Function: execute Backtrace: 5 File: /var/www/bvg159/index.php Line: 24 Function: require_once