SELECT n.news_id AS n_id, n.text_id AS n_tid, n.dates AS n_dates, n.top_images AS n_type, n.order_by AS n_order, n.publish AS n_pub, n.created_stmp AS n_created, n.modified_stmp AS n_modified, nt.title AS n_title, nt.description AS n_desc, nt.url AS n_url, img.ifile AS ifile, img.width_th AS wth, img.height_th AS hth FROM news n INNER JOIN news_trans nt ON n.news_id = nt.news_id AND nt.lang_id = 1 LEFT JOIN news_img ni ON n.news_id = ni.news_id AND ni.order_by = 1 LEFT JOIN img img ON ni.img_id = img.img_id WHERE n.publish = 1 and n.active = 1 and n.dates <= '20250122' ORDER BY n.dates DESC