FREE Standard Shipping on EVERYTHING.  
2013 - Lost connection to MySQL server during query

SELECT DISTINCT p.*, pd.*, IF(s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) AS final_price, p.products_quantity AS in_stock, IF(s.status, 1, 0) AS is_special FROM products p LEFT JOIN specials s ON p.products_id = s.products_id INNER JOIN products_description pd ON p.products_id = pd.products_id INNER JOIN products_to_categories p2c ON p.products_id = p2c.products_id INNER JOIN categories c ON p2c.categories_id = c.categories_id WHERE p.products_status = 1 AND c.parent_id = 6370 AND pd.language_id = 1 ORDER BY p.products_id DESC LIMIT 24