2013 - Lost connection to MySQL server during query
select count(distinct p.products_id) as total from (products p
left join specials s using(products_id) left join products_qextra pq on p.products_id=pq.products_qextra_pid ),
products_description pd where p.products_status = '1'
and pd.products_id = p.products_id
and pd.language_id = '1'
and p.products_group_access like '%g%' and (if(s.status, s.specials_new_products_price, p.products_price) >= 8 and if(s.status, s.specials_new_products_price, p.products_price) < 10)