SQL ERROR:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
select p.products_image, p.products_image_med, p.products_image_lrg, p.products_model, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, 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_family_name
from (products p
left join specials_retail_prices s using(products_id) )
left join manufacturers m on p.manufacturers_id = m.manufacturers_id,
products_description pd,
products_to_categories p2c
where p.products_status = '1'
and p.products_id = p2c.products_id
and pd.products_id = p2c.products_id
and p.products_stock_type NOT IN (9)
and pd.language_id = '1'
and p2c.categories_id in (613,672,718,918,946,682,618,957,955) 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_parent_id = 0 group by p.products_family_name order by p.products_date_added DESC,p.products_family_name, p.products_model , pd.products_name