SELECT cg.Description, IF(p.client_flag=1, CONCAT('/uploads/products/', p.thumb), p.thumb) AS Image, mh.Description AS mhDescription, mh.slug AS mhSlug, mh.super_category, cgDescription, cg.slug AS cgSlug, c.pkID AS cID, c.ConsumerDescription, c.slug AS cSlug, c.Category_Group, c.pkID AS cID, IF(bd.CommonBrandName = 'LG Appliances','LG',bd.CommonBrandName) AS CommonBrandName, bd.CommonBrandName AS brandLink, bd.CommonBrandID AS BrandID, bd.video_name, bd.video_thumb, bd.pkID AS id FROM Categories AS c INNER JOIN Category_Groups AS cg ON (c.Category_Group = cg.CategoryCode) INNER JOIN menu_heading AS mh ON (cg.MenuHeading = mh.id) INNER JOIN tbl_products AS p ON (p.cSlug = c.slug AND p.cgSlug = cg.slug AND p.mhSlug = mh.slug) INNER JOIN Brand_Data AS bd ON (bd.pkID = p.pkBrand) INNER JOIN tbl_store_brands AS sb ON (sb.brandID = bd.pkID AND sb.categoryID = c.pkID) INNER JOIN ModelPrice ON (ModelPrice.pkProduct = p.pkID AND ModelPrice.SKU = p.SKU AND ModelPrice.Available = 1) WHERE bd.slug = ? GROUP BY c.slug ORDER BY mh.seq, cg.seq, c.seq<BR><BR>MySQL server has gone away<BR><BR>Commands out of sync; you can't run this command now