Fatal error: Uncaught Exception: Error: Deadlock found when trying to get lock; try restarting transaction<br />Error No: 1213<br />CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) SELECT /*+ MAX_EXECUTION_TIME(10000) */ p.product_id, p.sort_order, "1" AS match_filters, (CASE WHEN MIN(ps.price) IS NOT NULL THEN MIN(ps.price) WHEN MIN(pd2.price) IS NOT NULL THEN MIN(pd2.price) WHEN MIN(psp.percentage) IS NOT NULL THEN (100 - MIN(psp.percentage)) * p.price / 100 WHEN MIN(pdp.percentage) IS NOT NULL THEN (100 - MIN(pdp.percentage)) * p.price / 100 ELSE p.price END * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price FROM `oc_product` AS p INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id) INNER JOIN `oc_bf_filter_guest` AS f ON (p.product_id = f.product_id) 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) LEFT JOIN `oc_product_discou in /var/www/koveikals.lv/web/system/library/db/mysqli.php on line 40