Error: Deadlock found when trying to get lock; try restarting transaction
Error No: 1213
CREATE TEMPORARY TABLE mz_temp_common_product SELECT p.product_id, p.manufacturer_id, p.stock_status_id, p.quantity, ((CASE WHEN p.erp_explicit = 1 AND p.erp_explicit_price > 0 THEN p.erp_explicit_price ELSE p.price END) + IFNULL(ftax.total,0) + ((IFNULL(ptax.total,0) * (CASE WHEN p.erp_explicit = 1 AND p.erp_explicit_price > 0 THEN p.erp_explicit_price ELSE p.price END)) / 100)) price, (SELECT price + IFNULL(ftax.total,0) + ((IFNULL(ptax.total,0) * price) / 100) FROM oc_product_discount WHERE product_id = p.product_id AND p.erp_explicit != 1 AND customer_group_id = '1' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1) AS discount, (SELECT price + IFNULL(ftax.total,0) + ((IFNULL(ptax.total,0) * price) / 100) FROM oc_product_special ps WHERE product_id = p.product_id AND p.erp_explicit != 1 AND customer_group_id = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1) AS special FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN (SELECT tax_class_id, SUM(`rate`) total FROM oc_mz_user_ftax_rates GROUP BY tax_class_id) ftax ON (ftax.tax_class_id = p.tax_class_id) LEFT JOIN (SELECT tax_class_id, SUM(`rate`) total FROM oc_mz_user_ptax_rates GROUP BY tax_class_id) ptax ON (ptax.tax_class_id = p.tax_class_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '1280621' GROUP BY p.product_id: in /home/autogkp2/public_html/system/library/db/mysqli.php on line 76