SELECT news.*, news.cdate newsdate
FROM
(
SELECT news.newsid
FROM news
WHERE 1 AND news.status = 1 AND '2023-01-27 23:29:36' >= news.publishon AND news.publishon > date_sub(curdate(), INTERVAL 1 WEEK)
ORDER BY news.views DESC
LIMIT 4
) t
INNER JOIN news ON news.newsid = t.newsid ------>>>>> MySQL server has gone away