SELECT
AVG(TIMESTAMPDIFF(SECOND, data.created_at, deletion_logs.created_at)) AS 'AvgSecondsToDeletion',
data.feedback_count AS 'FeedbackCount'
FROM
(SELECT
posts.id AS 'id',
posts.created_at AS 'created_at',
COUNT(feedbacks.id) AS 'feedback_count'
FROM posts
LEFT JOIN feedbacks ON feedbacks.post_id = posts.id
WHERE
posts.is_tp = 1 AND
posts.created_at IS NOT NULL GROUP BY posts.id)
AS data
INNER JOIN deletion_logs ON
deletion_logs.post_id = data.id AND