SQL ERROR: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
SELECT DISTINCT p.products_id,p.products_model,pc.categories_id,cd.categories_name, p.products_image,products_image_med ,p.products_image, pd.products_name,
p.products_price, p.products_tax_class_id , p.manufacturers_id, m. manufacturers_name,
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_group_access like '%,G,%' or p.products_group_access like 'G,%' or p.products_group_access like '%,G' or p.products_group_access='G')
and p.products_stock_type NOT IN (9)
AND p.manufacturers_id = 346
and products_parent_id = 0 group by pc.categories_id order by cd.categories_name