Renewable Heat Courses

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