Error: Error: Unknown column 'a.dynamod_id' in 'on clause'
Error No: 1054
SELECT image_path AS image, `sort_by` AS sort_order
FROM dynamod_product_image a
LEFT JOIN dynamod_product b ON a.dynamod_id=b.id
WHERE b.stock_article_no='9557892200113Q'
ORDER BY `sort_by` ASC
File: /home/icare/public_html/system/library/db/mysqli.php
Line: 122
Backtrace: 0
File: /home/icare/public_html/system/library/db.php
Line: 54
Class: Opencart\System\Library\DB\MySQLi
Function: query
Backtrace: 1
File: /home/icare/public_html/catalog/model/catalog/product.php
Line: 1205
Class: Opencart\System\Library\DB
Function: query
Backtrace: 2
File: /home/icare/public_html/catalog/model/catalog/product.php
Line: 184
Class: Opencart\Catalog\Model\Catalog\Product
Function: getDynamodImage
Backtrace: 3
File: /home/icare/public_html/system/engine/loader.php
Line: 387
Class: Opencart\Catalog\Model\Catalog\Product
Function: getProduct
Backtrace: 4
File: /home/icare/public_html/system/engine/proxy.php
Line: 87
Class: Opencart\System\Engine\Loader
Function: Opencart\System\Engine\{closure}
Backtrace: 5
File: /home/icare/public_html/catalog/controller/logic/productimage.php
Line: 383
Class: Opencart\System\Engine\Proxy
Function: __call
Backtrace: 6
File: /home/icare/public_html/catalog/controller/logic/productimage.php
Line: 346
Class: Opencart\Catalog\Controller\Logic\Productimage
Function: getProductList
Backtrace: 7
File: /home/icare/public_html/system/engine/loader.php
Line: 112
Class: Opencart\Catalog\Controller\Logic\Productimage
Function: getProduct
Backtrace: 8
File: /home/icare/public_html/catalog/controller/logic/product.php
Line: 31
Class: Opencart\System\Engine\Loader
Function: controller
Backtrace: 9
File: /home/icare/public_html/system/engine/loader.php
Line: 112
Class: Opencart\Catalog\Controller\Logic\Product
Function: getProduct
Backtrace: 10
File: /home/icare/public_html/catalog/controller/product/product.php
Line: 29
Class: Opencart\System\Engine\Loader
Function: controller
Backtrace: 11
File: /home/icare/public_html/system/engine/action.php
Line: 96
Class: Opencart\Catalog\Controller\Product\Product
Function: index
Backtrace: 12
File: /home/icare/public_html/system/framework.php
Line: 260
Class: Opencart\System\Engine\Action
Function: execute
Backtrace: 13
File: /home/icare/public_html/index.php
Line: 20
Function: require_once