Fatal error: Uncaught ErrorException: Error: Deadlock found when trying to get lock; try restarting transaction<br />Error No: 1213<br />CREATE TEMPORARY TABLE oc_bf_found_results (PRIMARY KEY (`product_id`)) ENGINE=MYISAM SELECT p.product_id, p.price, MIN(pd2.price) AS discount, MIN(ps.price) AS special, AVG(rating) AS total, 0 AS fixed_tax, 0 AS percent_tax FROM ( SELECT p.* FROM `oc_product` AS p INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id) INNER JOIN `oc_category_path` AS cp ON (cp.category_id = p2c.category_id) WHERE cp.path_id = '117775') AS p LEFT JOIN `oc_product_discount` AS pd2 ON (pd2.product_id = p.product_id AND pd2.quantity = '1' AND (pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-01-23') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-01-23') AND pd2.customer_group_id = '1') LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id in /var/www/websites/sima-minsk.by/system/database/mysqli.php on line 50