SELECT a.nid, a.title, b.uri FROM node a INNER JOIN field_data_field_img_new c ON a.nid = c.entity_id INNER JOIN file_managed b ON c.field_img_new_fid = b.fid left join field_data_field_news_font_end d on a.nid=d.entity_id WHERE a.type = 'news_hot' and ( nid='2983' or '2958' or nid='2933' or '2905') and a.language ='en' and d.field_news_font_end_value='ใช่' ORDER BY a.nid DESC LIMIT 8 , 4