SELECT (post.likes / ((1479736269 - post.post_date) / (6060))) as trending_score, post.
,
thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
thread.post_date AS thread_post_date,
post.user_id, post.username, post.post_date,
node.title AS node_title, node.node_name,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
deletion_log.delete_date, deletion_log.delete_reason,
deletion_log.delete_user_id, deletion_log.delete_username,
session_activity.view_date AS last_view_date,
permission.cache_value AS node_permission_cache,
(select max(avf_liked_content.like_date) from xf_liked_content avf_liked_content where avf_liked_content.content_id = post.post_id and avf_liked_content.content_type = 'post') as last_like_date
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
INNER JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)
LEFT JOIN xf_deletion_log AS deletion_log ON
(deletion_log.content_type = 'post' AND deletion_log.content_id = post.post_id)
LEFT JOIN xf_session_activity AS session_activity ON
(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 2829
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
LEFT JOIN xf_liked_content AS avf_liked_content ON
(avf_liked_content.content_id = post.post_id) AND (avf_liked_content.content_type = 'post')
WHERE (thread.node_id IN ('2', '41', '3', '39', '13', '15', '6', '65', '9', '20', '4', '57', '10', '67', '12')) HAVING (last_like_date >= 1479563108)
ORDER BY trending_score DESC