QUERY: select count(*) as count FROM products p JOIN (
SELECT
products_id FROM products_to_categories
WHERE categories_id in (49)
GROUP BY products_id
) AS p2c ON(p.products_id = p2c.products_id) INNER JOIN products_specifications ps142 ON p.products_id = ps142.products_id WHERE p.products_status = 1 AND ps142.language_id = 1 AND ps142.specifications_id = 142 AND ps142.specification in ('да') and p.manufacturers_id in ('100')
ERROR: MySQL server has gone away