SQL
AخA
/*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor = actor_id
WHERE actor_name = 'Ahmad Kanik'
AND rc_source = 'mw.edit';
*/
/*
SELECT p.page_title, pp.pp_value
FROM page p
JOIN page_props pp
ON p.page_id = pp.pp_page
WHERE p.page_is_redirect = 1
AND pp.pp_propname = 'wikibase_item';
*/
/*
SELECT
page_title,
COUNT(*) as cnt,
actor_name
FROM revision
JOIN page
ON rev_page = page_id
JOIN actor
ON rev_actor = actor_id
WHERE page_namespace = 12
AND page_is_redirect = 0
GROUP BY rev_page
ORDER BY cnt
LIMIT 1000;
*/
SELECT
log_id,
user_name,
user_editcount,
comment_text
FROM logging
JOIN actor
ON log_actor = actor_id
JOIN comment
ON log_comment_id = comment_id
JOIN user
ON actor_user = user_id
WHERE log_type = 'move'
AND log_id > 2613287
AND user_editcount < 150
AND comment_text NOT LIKE 'ব্যবহার%নামান্তর%স্বয়ংক্রিয়%'
LIMIT 1000;
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.