SQL ERROR:SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
SELECT DISTINCT p.products_image, p.products_model, pd.products_name,
p.products_id,p.products_quantity,
p.products_image,products_image_med , p.products_price,
p.products_tax_class_id,
IF(s.status, IF(ISNULL(pg.customers_group_price), LEAST(s.specials_new_products_price, p.products_price), LEAST(pg.customers_group_price, s.specials_new_products_price)), IF(ISNULL(pg.customers_group_price), p.products_price, LEAST(pg.customers_group_price, p.products_price))) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id )
LEFT JOIN products_groups pg on (p.products_id = pg.products_id)
LEFT JOIN products_description pd on (p.products_id = pd.products_id )
LEFT JOIN products_to_categories pc on (p.products_id = pc.products_id )
LEFT JOIN categories_description cd on (cd.categories_id = pc.categories_id )
LEFT JOIN manufacturers m on (p.manufacturers_id = m.manufacturers_id )
WHERE p.products_status = '1'
AND pd.language_id = '1'
and p.products_stock_type NOT IN (9)
AND p.products_group_access LIKE '%G%'
AND p.manufacturers_id = 346 and products_parent_id = 0 and pc.categories_id in (946,567,726,618,938,954,879,869) group by p.products_family_name order by p.products_id DESC
