HETAS Training | Solid Fuel Courses

SELECT a.id, status, type, a.name, uri, content, d.name AS image, e.description FROM xd2cms_pages AS a LEFT OUTER JOIN xd2cms_uri AS b ON b.uri_key = a.id LEFT OUTER JOIN xd2cms_pages_content AS c ON c.id = a.id LEFT OUTER JOIN xd2cms_pages_images AS d ON d.page = a.id LEFT OUTER JOIN xd2cms_meta AS e ON e.akey = a.id WHERE a.status = 1 AND a.type = '35' AND b.uri_act = '1' AND d.featured = '1' AND e.act = '1' ORDER BY dorder, name