SQL ERROR:SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
select count(distinct p.products_id) as total 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 (624,946,954,618,879,938,726,948,722)
