SELECT count(*) as num, i.entityid, e.name, e.platform, e.filename, i.thumb_filename as ifilename, i.thumb_width, e.sectionid, company, secondcompany, e.type,i.image_path FROM neoseeker.images i, neoseeker.entities e, neoseeker.products p WHERE e.entityid = i.entityid AND e.pid = p.productid AND e.type = 'Game' AND pair_num <> 1 AND e.platform='DC' AND e.status = 'active' AND (e.name LIKE 'C%' OR e.name LIKE 'the C%') GROUP BY e.name HAVING num > 4 ORDER BY e.name LIMIT 6