SQL
AخA
SELECT *
FROM page p
INNER JOIN category cat
ON p.page_title = cat.cat_title
INNER JOIN (
SELECT rev_page, MIN(rev_id) AS first_rev_id
FROM revision
GROUP BY rev_page) rev_group
ON p.page_id = rev_group.rev_page
INNER JOIN revision first_rev
ON rev_group.rev_page = first_rev.rev_page
AND rev_group.first_rev_id = first_rev.rev_id
INNER JOIN actor first_actor
ON first_rev.rev_actor = first_actor.actor_id
INNER JOIN ipblocks block
ON first_actor.actor_user = block.ipb_user
INNER JOIN comment block_comment
ON block.ipb_reason_id = block_comment.comment_id
WHERE p.page_namespace = 14
AND cat.cat_pages = 0
AND cat.cat_subcats = 0
AND cat.cat_files = 0
AND (block_comment.comment_text LIKE '%Ellsiemall%'
OR block_comment.comment_text LIKE '%ELLS%'
OR block_comment.comment_text LIKE '%Color Actor%'
OR block_comment.comment_text LIKE '%PC%'
OR block_comment.comment_text LIKE '%HEATHROW%'
OR block_comment.comment_text LIKE '%HGTCHDP%'
OR block_comment.comment_text LIKE '%SUZU%'
OR block_comment.comment_text LIKE '%RAYA%'
OR block_comment.comment_text LIKE '%小作%'
/*
OR block_comment.comment_text LIKE '%ILLEGIT%'
OR block_comment.comment_text LIKE '%SCRUTINY%'
*/
)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.