Advertisement
Guest User

Untitled

a guest
Feb 16th, 2020
19
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT comments.comment_id AS comments_comment_id, comments.comment_id_xyz AS comments_comment_id_xyz, comments.post_id AS comments_post_id, comments.parent_id AS comments_parent_id, comments.user_id AS comments_user_id, comments.text AS comments_text, comments.text_tsv AS comments_text_tsv, comments.posted AS comments_posted, comments.vote_plus AS comments_vote_plus, comments.vote_minus AS comments_vote_minus, comments.rating AS comments_rating, comments.source AS comments_source, comments_1.comment_id AS comments_1_comment_id, comments_1.comment_id_xyz AS comments_1_comment_id_xyz, comments_1.post_id AS comments_1_post_id, comments_1.parent_id AS comments_1_parent_id, comments_1.user_id AS comments_1_user_id, comments_1.text AS comments_1_text, comments_1.text_tsv AS comments_1_text_tsv, comments_1.posted AS comments_1_posted, comments_1.vote_plus AS comments_1_vote_plus, comments_1.vote_minus AS comments_1_vote_minus, comments_1.rating AS comments_1_rating, comments_1.source AS comments_1_source, users_1.user_id AS users_1_user_id, users_1.name AS users_1_name, users_1.avatar_hash AS users_1_avatar_hash, users_1.source AS users_1_source, posts_1.post_id AS posts_1_post_id, posts_1.comment_list_id AS posts_1_comment_list_id, posts_1.user_id AS posts_1_user_id, posts_1.language AS posts_1_language, posts_1.code AS posts_1_code, posts_1.text AS posts_1_text, posts_1.text_tsv AS posts_1_text_tsv, posts_1.posted AS posts_1_posted, posts_1.vote_plus AS posts_1_vote_plus, posts_1.vote_minus AS posts_1_vote_minus, posts_1.rating AS posts_1_rating, posts_1.source AS posts_1_source, users_2.user_id AS users_2_user_id, users_2.name AS users_2_name, users_2.avatar_hash AS users_2_avatar_hash, users_2.source AS users_2_source, users_3.user_id AS users_3_user_id, users_3.name AS users_3_name, users_3.avatar_hash AS users_3_avatar_hash, users_3.source AS users_3_source, posts_2.post_id AS posts_2_post_id, posts_2.comment_list_id AS posts_2_comment_list_id, posts_2.user_id AS posts_2_user_id, posts_2.language AS posts_2_language, posts_2.code AS posts_2_code, posts_2.text AS posts_2_text, posts_2.text_tsv AS posts_2_text_tsv, posts_2.posted AS posts_2_posted, posts_2.vote_plus AS posts_2_vote_plus, posts_2.vote_minus AS posts_2_vote_minus, posts_2.rating AS posts_2_rating, posts_2.source AS posts_2_source, users_4.user_id AS users_4_user_id, users_4.name AS users_4_name, users_4.avatar_hash AS users_4_avatar_hash, users_4.source AS users_4_source
  2.  
  3. FROM comments JOIN comments AS comments_1 ON comments_1.comment_id = comments.parent_id LEFT OUTER JOIN posts AS posts_1 ON posts_1.post_id = comments.post_id LEFT OUTER JOIN users AS users_1 ON users_1.user_id = posts_1.user_id LEFT OUTER JOIN users AS users_2 ON users_2.user_id = comments.user_id LEFT OUTER JOIN posts AS posts_2 ON posts_2.post_id = comments_1.post_id LEFT OUTER JOIN users AS users_3 ON users_3.user_id = posts_2.user_id LEFT OUTER JOIN users AS users_4 ON users_4.user_id = comments_1.user_id
  4.  
  5. WHERE comments.user_id != 8086 AND comments_1.user_id = 8086 ORDER BY comments.posted DESC
  6.  LIMIT 20;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement