| -- - |
1 week ago |
| select user_editcount
from user
where user_name = 'Moheen';
select... |
1 week ago |
| -- - |
1 week ago |
| select user_name, user_editcount
from user
where user_id = 444654;
select... |
1 week ago |
| select COUNT(rev_id) as cnt
from revision
join actor
on rev_actor =... |
1 week ago |
| select *
from revision
join actor
on rev_actor = actor_id
where actor_name =... |
1 week ago |
| select *
from revision
limit 1; |
1 week ago |
| select *
from revision
where actor_name = 'Ahmed Reza Khan'
limit 1; |
1 week ago |
| select *
from revision
where action_name = 'Ahmed Reza Khan'
limit 1; |
1 week ago |
| select user_name, user_editcount
from user
where user_id = 444654; |
1 week ago |
| select user_name, user_editcount
from user
where userid = 444654; |
1 week ago |
| select * from user limit 2; |
1 week ago |
| -- - |
3 months ago |
| select
actor_name as user,
count(rev_id) as cnt
from revision
join actor
on... |
3 months ago |
| select
actor_name as user,
count(rev_id) as cnt
from revision
join actor
on... |
3 months ago |
| select
actor_name as user,
count(rev_id) as cnt
from revision
join actor
on... |
3 months ago |
| select
actor_name as user,
count(rev_id) as edits
from revision
join... |
3 months ago |
| -- - |
3 months ago |
| select
actor_name as usr,
count(rev_id) as cnt
from revision
join comment
on... |
3 months ago |
| select
actor_name as usr
count(rev_id) as cnt
from revision
join comment
on... |
3 months ago |
| -- - |
3 months ago |
| select count(rev_id) from revision
join comment
on rev_comment_id =... |
3 months ago |
| select * from revision
join comment
on rev_comment_id = comment_id
join... |
3 months ago |
| select * from revision
join comment
on rev_comment_id = comment_id
join... |
3 months ago |
| select * from revision
join comment
on rev_comment_id = comment_id
join... |
3 months ago |
| select * from revision
join comment
on rev_comment_id = comment_id
join... |
3 months ago |
| select * from revision
join comment
on rev_comment_id = comment_id
join... |
3 months ago |
| select * from comment
limit 5; |
3 months ago |
| select
actor_name,
count(distinct rev_page) as cnt
from revision
join... |
3 months ago |
| select
actor_name
count(distinct rev_page) as cnt
from revision
join... |
3 months ago |
| select count(distinct rev_page)
from revision
join actor
on rev_actor =... |
3 months ago |
| select count(rev_page)
from revision
join actor
on rev_actor =... |
3 months ago |
| select count(*)
from revision
join actor
on rev_actor = actor_id
where... |
3 months ago |
| select *
from revision
join actor
on rev_actor = actor_id
limit 5; |
3 months ago |
| -- - |
5 months ago |
| SELECT
actor_name as user,
COUNT(*) as cnt
FROM revision_userindex
JOIN... |
5 months ago |
| SELECT page_title FROM
page
WHERE page_namespace = 1
AND page_len = 0; |
6 months ago |
| SELECT * FROM
page
LIMIT 5; |
6 months ago |
| SELECT page_namespace, page_title, page_len, page_is_redirect, page_is_new... |
12 months ago |
| -- -- |
2 years ago |
| SELECT count(page_title)
FROM page
LEFT JOIN imagelinks
ON il_from =... |
3 years ago |
| SELECT page_title
FROM page
LEFT JOIN imagelinks
ON il_from = page_id
WHERE... |
3 years ago |
| SELECT count(page_title)
FROM page
LEFT JOIN imagelinks
ON il_from =... |
3 years ago |
| SELECT count(page_title)
FROM page
LEFT JOIN imagelinks
ON il_from =... |
3 years ago |
| SELECT page_namespace, page_title FROM page
LEFT JOIN imagelinks on il_from... |
3 years ago |
