DELETE FROM product WHERE product_id = '$product_id';
DELETE FROM product_attribute WHERE product_id = '$product_id';
DELETE FROM product_description WHERE product_id = '$product_id';
DELETE FROM product_discount WHERE product_id = '$product_id';
DELETE FROM product_filter WHERE product_id = '$product_id';
DELETE FROM product_image WHERE product_id = '$product_id';
DELETE FROM product_option WHERE product_id = '$product_id';
DELETE FROM product_option_value WHERE product_id = '$product_id';
DELETE FROM product_related WHERE product_id = '$product_id';
DELETE FROM product_related WHERE related_id = '$product_id';
DELETE FROM product_reward WHERE product_id = '$product_id';
DELETE FROM product_special WHERE product_id = '$product_id';
DELETE FROM product_to_category WHERE product_id = '$product_id';
DELETE FROM product_to_download WHERE product_id = '$product_id';
DELETE FROM product_to_layout WHERE product_id = '$product_id';
DELETE FROM product_to_store WHERE product_id = '$product_id';
DELETE FROM product_recurring WHERE product_id = '$product_id';
DELETE FROM review WHERE product_id = '$product_id';
DELETE FROM seo_url WHERE query = 'product_id=$product_id';
DELETE FROM coupon_product WHERE product_id = '$product_id';
SELECT p.product_id,
(SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating,
(SELECT price FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '$config_customer_group_id'
AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW())
AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '$config_customer_group_id'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '$config_language_id' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '$config_store_id'
GROUP BY p.product_id