Untitled

SELECT mt.media_id, mt.title, sht.share_count, ct.comment
				 FROM '.$grouped_media_table.' mt   
				LEFT JOIN (
				  SELECT media_id,title
				     ,SUM(DISTINCT sht.share) as share_count 
				  FROM '.$share_table.' sht
				  WHERE sht.media_id = %d AND sht.title = %s
				  GROUP BY media_id,title
				  ) sht ON sht.media_id = mt.media_id AND sht.title = mt.title
				LEFT JOIN (
				  SELECT ct.id, ct.media_id, ct.title, comment 
				   ,ct.comment_parent_id, ct.reported, ct.user_id, ct.user_display_name, ct.avatar
				   ,ct.c_date
				   ,vote,user_voted,user_vote
				  FROM '.$comments_table.' as ct
				  LEFT JOIN lateral ( SELECT vt.comment_id, SUM(vt.vote) AS vote, 
				           MAX(vt.user_id = %d) AS user_voted,
				           MAX(CASE WHEN vt.user_id = %d THEN vote END) AS user_vote
				      FROM '.$votes_table.' vt
				      WHERE ct.id = vt.comment_id
				      group by vt.comment_id
				    ) vt on ct.id = vt.comment_id 
				  WHERE ct.media_id = %d AND ct.title = %s 
				) as ct ON ct.media_id = mt.media_id AND ct.title = mt.title
				 WHERE mt.media_id = %d AND mt.title = %s 
				 ORDER BY ct.c_date DESC;