Page MenuHomeMiraheze
Paste P303

(An Untitled Masterwork)
ActivePublic
Actions

Authored by Paladox on Apr 30 2020, 16:55.
Tags
None
Referenced Files
F1150339: raw.txt
Apr 30 2020, 17:02
F1150327: raw.txt
Apr 30 2020, 16:55
Subscribers
None
SELECT Comment_Username,Comment_IP,Comment_Text,Comment_Date,Comment_Date AS timestamp,CommentID,Comment_Parent_ID,vote1.Comment_Vote_Score AS current_vote,SUM(vote2.Comment_Vote_Score) AS comment_score, stats_total_points FROM `Comments`, `user_stats` LEFT JOIN `Comments_Vote` `vote1` ON ((vote1.Comment_Vote_ID = CommentID)) LEFT JOIN `Comments_Vote` `vote2` ON ((vote2.Comment_Vote_ID = CommentID)) LEFT JOIN `Comments` `Comments` ON ((Comment_actor = stats_actor)) WHERE Comment_Page_ID = '22891' GROUP BY CommentID