Query error: select c.*, count(p.product_id) as `product_count`, c.parent as `parent_id`, if(c.parent > 0, 0, 1) as `root`, concat(c.category_sef, ".html") as `url`, concat("/selection", c.category_sef, ".html") as `selection_url`, if( c.category_thumb_image != "", concat("categories/", c.category_thumb_image), if( c.category_full_image != "", concat("categories/", c.category_full_image), "" ) ) as `category_image` from `jos_vm_category` c left join `jos_vm_product_category_xref` p on p.category_id=c.category_id and p.product_id in (select product_id from jos_vm_product where (product_publish="Y" or product_publish=1) and not is_selection) where c.category_publish="Y"and (is_selection=0) group by p.category_id union select c.*, 0 as `product_count`, c.parent as `parent_id`, if(c.parent > 0, 0, 1) as `root`, concat(c.category_sef, ".html") as `url`, concat("/selection", c.category_sef, ".html") as `selection_url`, if( c.category_thumb_image != "", concat("categories/", c.category_thumb_image), if( c.category_full_image != "", concat("categories/", c.category_full_image), "" ) ) as `category_image` from `jos_vm_category` c where c.category_publish="Y"and (is_selection=0) and c.category_id in (70,39,40, 124, 69, 146,147,148, 63) order by list_order asc
MySQL server has gone away