SELECT c.id, c.strapline,c.body, c.headline, c.introline, c.introduction,c.creationdate,c.slug, c.keywords, c.seokeywords, ci.picid, p.caption,c.dateline,wc.sectionid as section_id, wc.supplimentid as suppliment_id,p.name as picname,wc.priority FROM content c INNER JOIN webcontent wc ON wc.contentid = c.id AND wc.supplimentid =91 and wc.sectionid in (798) AND wc.webid = 1 AND (wc.status='a' OR wc.status='r') LEFT JOIN contentimage ci ON c.id = ci.contentid LEFT JOIN picture p ON p.id = ci.picid ORDER BY wc.priority, c.id DESC OFFSET 0 LIMIT 14