| SELECT page_title, page_touched, page_len
FROM svwiki_p.page
WHERE... |
9 years ago |
| SELECT DISTINCT tl_title
FROM svwiki_p.templatelinks
WHERE tl_namespace =... |
9 years ago |
| SELECT *
FROM svwiki_p.templatelinks
WHERE tl_namespace = 10
LIMIT 10; |
9 years ago |
| SELECT *
FROM svwiki_p.templatelinks
LIMIT 10; |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT * FROM svwiki_p.page_props
WHERE pp_propname != 'disambiguation'
LIMIT 2;
|
9 years ago |
| SELECT * FROM svwiki_p.page_props
WHERE pp_propname != 'disambiguation'
LIMIT 1;
|
9 years ago |
| SELECT * FROM svwiki_p.page_props
WHERE pp_propname = 'disambiguation'
LIMIT 1;
|
9 years ago |
| SELECT DISTINCT pp_propname FROM svwiki_p.page_props
|
9 years ago |
| SELECT * FROM svwiki_p.page_props
JOIN svwiki_p.page
ON page_id = pp_page
LIMIT 100; |
9 years ago |
| SELECT * FROM svwiki_p.page_props
JOIN svwiki:p.page
ON page_id = pp_page
LIMIT 100; |
9 years ago |
| SELECT * FROM svwiki_p.page_props
LIMIT 100; |
9 years ago |
| SELECT * FROM svwiki_p.page_props
LIMIT 1; |
9 years ago |
| SELECT DISTINCT pp_propname FROM svwiki_p.page_props; |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
|
SELECT DISTINCT pp_propname FROM page_props; |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT DISTINCT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT *
FROM svwiki_p.page_props
LIMIT 1; |
9 years ago |
|
SELECT DISTINCT pp_propname FROM svwiki_p.page_props; |
9 years ago |
|
SELECT DISTINCT svwiki_p.pp_propname FROM page_props; |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
JOIN... |
9 years ago |
| SELECT page_title, page_len, page_touched
FROM svwiki_p.page
WHERE... |
9 years ago |
| SELECT page_title, page_touched, page_len
FROM svwiki_p.page
WHERE... |
9 years ago |
| SELECT *
FROM svwiki_p.page
WHERE page_namespace = 0 AND page_is_redirect =... |
9 years ago |
| SELECT *
FROM svwiki_p.page
WHERE page_namespace = 0
ORDER BY page_touched... |
9 years ago |
| SELECT *
FROM svwiki_p.page
//WHERE page_namespace = 0
ORDER BY page_touched... |
9 years ago |
| SELECT *
FROM svwiki_p.page
WHERE page_namespace = 0
ORDER BY page_touched... |
9 years ago |
| SELECT *
FROM svwiki_p.page
ORDER BY page_touched ASC
LIMIT 100; |
9 years ago |
| SELECT *
FROM svwiki_p.page
ORDER BY page_counter DESC
LIMIT 100; |
9 years ago |
| SELECT *
FROM svwiki_p.page
LIMIT 1; |
9 years ago |
| SELECT user_id, user_name, user_registration, user_editcount
FROM... |
9 years ago |
| SELECT *
FROM svwiki_p.user
WHERE user_editcount > 9000
ORDER BY user_editcount DESC |
9 years ago |
| SELECT user_name, user_editcount
FROM svwiki_p.user
ORDER BY... |
9 years ago |
| SELECT *
FROM svwiki_p.user
LIMIT 5; |
9 years ago |
| SELECT user_name, edit_count
FROM svwiki_p.user
ORDER BY edit_count DESC
LIMIT 500; |
9 years ago |
| SELECT DISTINCT user_name
FROM svwiki_p.user
JOIN svwiki_p.revision
ON... |
9 years ago |
| SELECT user_name
FROM svwiki_p.revision
JOIN svwiki_p.user
ON rev_user =... |
9 years ago |
| SELECT user_name
FROM svwiki_p.revision
JOIN svwiki_p.user
ON rev_user =... |
9 years ago |
| SELECT user_name, rev_timestamp, page_title
FROM svwiki_p.revision
JOIN... |
9 years ago |
| SELECT *
FROM svwiki_p.revision
LIMIT 1; |
9 years ago |
| SELECT *
FROM svwiki_p.page
LIMIT 1; |
9 years ago |
| SELECT *
FROM svwiki_p.revision
LIMIT 1; |
9 years ago |
| SELECT user_name, rev_timestamp
FROM svwiki_p.revision
JOIN svwiki_p.user
ON... |
9 years ago |
| SELECT user_name, rev_timestamp
FROM svwiki_p.revision
JOIN svwiki_p.user
ON... |
9 years ago |
| SELECT *
FROM svwiki_p.revision
LIMIT 1; |
9 years ago |
| SELECT *
FROM svwiki_p.revision
WHERE user_id = 63577
LIMIT 1; |
9 years ago |
| SELECT *
FROM svwiki_p.user
WHERE user_id = 63577
LIMIT 1; |
9 years ago |
| SELECT *
FROM svwiki_p.revision
LIMIT 1; |
9 years ago |
| SELECT *
FROM svwiki_p.revisions
LIMIT 1; |
9 years ago |
| SELECT *
FROM svwiki_p.page
LIMIT 1; |
9 years ago |
| SELECT user_name
FROM svwiki_p.user
JOIN svwiki_p.page
ON uder_id =... |
9 years ago |
| select *
from svwiki_p.user
where user_name like '%(WMSE)'
LIMIT 20; |
9 years ago |
| select *
from svwiki_p.page
where page_is_new = 1
order by page_touched... |
9 years ago |
| select *
from svwiki_p.page
where page_is_new = 1
LIMIT 20; |
9 years ago |
| select page_title
from svwiki_p.page
where page_is_new = 1
LIMIT 20; |
9 years ago |
| select page_title,
from svwiki_p.page
where page_is_new = 1
LIMIT 20; |
9 years ago |
| select user_id, user_name, user_registration, user_editcount
from... |
9 years ago |
| select user_id, user_name, user_registration, user_editcount from... |
9 years ago |
| select * from svwiki_p.user where user_name like '%(WMSE)' order by... |
9 years ago |
| select * from svwiki_p.user where user_name like '%(WMSE)' order by... |
9 years ago |
| select * from svwiki_p.user order by user_editcount desc LIMIT 10; |
9 years ago |
| select * from svwiki_p.user LIMIT 1; |
9 years ago |
| select * from svwiki_p.page where page_touched > 20140820100000 LIMIT 10; |
9 years ago |
| select page_title from svwiki_p.page where page_touched > 20140820100000 ... |
9 years ago |
| select page_title from svwiki_p.page where page_touched > 20140820100000 LIMIT 10; |
9 years ago |
| select page_title from svwiki_p.page where page_touched > 20140820170000 LIMIT 10; |
9 years ago |
| select page_title from svwiki_p.page where page_touched > 20140820000000 LIMIT 10; |
9 years ago |
| SELECT * FROM revision WHERE rev_user_text='Jan Ainali (WMSE)' LIMIT 1; |
9 years ago |
