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='2808' or '2770' or nid='2676' or '2665') and a.language ='en' and d.field_news_font_end_value='ใช่' ORDER BY a.nid DESC LIMIT 8 , 4