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='2907' or '2899' or nid='2895' or '2882') and a.language ='en' and d.field_news_font_end_value='ใช่' ORDER BY a.nid DESC LIMIT 8 , 4