SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
1 year ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
1 year ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT user_name, COUNT(DISTINCT rev_id) AS validated_count
FROM... |
2 years ago |
SELECT user_name, COUNT(DISTINCT rev_id) AS proofread_count
FROM... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
LEFT OUTER JOIN change_tag ON rev_id =... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT actor_name, COUNT(DISTINCT rev_id) as count3
FROM revision
JOIN... |
2 years ago |
SELECT actor_name, COUNT(DISTINCT rev_id) as count3
FROM revision
JOIN... |
2 years ago |
SELECT actor_name, COUNT(DISTINCT rev_id) as count3
FROM revision
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT *
FROM revision
JOIN change_tag ON rev_id = ct_rev_id
JOIN... |
2 years ago |
SELECT user_name, COUNT(DISTINCT rev_id) AS proofread_count
FROM revision... |
2 years ago |
SELECT user_name, COUNT(DISTINCT rev_id) AS proofread_count
FROM revision... |
2 years ago |
SELECT user_name, COUNT(DISTINCT rev_id) AS proofread_count
FROM revision... |
2 years ago |
SELECT *
FROM change_tag_def
LIMIT 10 |
2 years ago |
SELECT user_name, COUNT(DISTINCT rev_id) AS proofread_count
FROM revision... |
2 years ago |
SELECT user_name, COUNT(DISTINCT rev_id) AS proofread_count
FROM revision... |
2 years ago |
SELECT DISTINCT ctd_name
FROM change_tag_def
LIMIT 100 |
2 years ago |
SELECT DISTINCT ctd_name
FROM change_tag_def
LIMIT 100 |
2 years ago |
SELECT DISTINCT ctd_name
FROM change_tag_def
LIMIT 10 |
2 years ago |
SELECT *
FROM change_tag_def
LIMIT 10 |
2 years ago |
SELECT *
FROM change_tag_def
WHERE ctd_name = "Proofread"
LIMIT 10 |
2 years ago |
SELECT *
FROM change_tag_def
WHERE ctd_name = "Not Proofread"
LIMIT 10 |
2 years ago |
SELECT *
FROM change_tag_def
LIMIT 10 |
2 years ago |
SELECT *
FROM change_tag_id
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
WHERE rev_comment_id = "618282"
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
WHERE rev_comment_id = "618282"
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
WHERE rev_comment_id = "618282"
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
WHERE rev_comment_id = "618282"
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
WHERE rev_comment_id = "618282"
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
WHERE rev_page = "1311959"
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
WHERE rev_id = "9327567"
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
WHERE rev_actor = "2849115"
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
WHERE actor_id = "2849115"
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
LIMIT 10 |
2 years ago |
SELECT *
FROM user
where user_id = "2840868"
LIMIT 10 |
2 years ago |
SELECT *
FROM actor
where actor_user = "2840868"
LIMIT 10 |
2 years ago |
SELECT *
FROM user
where user_name = "Nivas10798"
LIMIT 10 |
2 years ago |
SELECT *
FROM user
LIMIT 10 |
2 years ago |
SELECT *
FROM user
LIMIT 10 |
2 years ago |
SELECT *
FROM user |
2 years ago |
SELECT DISTINCT comment_id, comment_text
FROM revision
JOIN comment ON... |
2 years ago |
SELECT DISTINCT comment_id, comment_text
FROM revision
JOIN comment ON... |
2 years ago |
SELECT DISTINCT comment_id, comment_text
FROM revision
JOIN comment ON... |
2 years ago |
SELECT DISTINCT comment_id, comment_text
FROM revision
JOIN comment ON... |
2 years ago |
SELECT DISTINCT comment_id, comment_text
FROM revision
JOIN comment ON... |
2 years ago |
SELECT DISTINCT comment_id, comment_text
FROM revision
JOIN comment ON... |
2 years ago |
SELECT DISTINCT comment_id, comment_text
FROM revision
JOIN comment ON... |
2 years ago |
SELECT DISTINCT comment_id, comment_text
FROM revision
JOIN comment ON... |
2 years ago |
SELECT DISTINCT comment_id, comment_text
FROM revision
JOIN comment ON... |
2 years ago |
SELECT comment_id, comment_text
FROM revision
JOIN comment ON rev_comment_id... |
2 years ago |
SELECT *
FROM revision
JOIN comment ON rev_comment_id = comment_id
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
JOIN comment ON rev_comment_id = comment_id
WHERE... |
2 years ago |
SELECT *
FROM revision
JOIN comment ON rev_comment_id = comment_id
WHERE... |
2 years ago |
SELECT *
FROM revision
JOIN comment ON rev_comment_id = comment_id
WHERE... |
2 years ago |
SELECT *
FROM revision
JOIN comment ON rev_comment_id = comment_id
WHERE... |
2 years ago |
SELECT *
FROM revision
OUTER JOIN comment ON rev_comment_id =... |
2 years ago |
SELECT *
FROM revision
OUTER JOIN comment ON rev_comment_id =... |
2 years ago |
SELECT *
FROM revision
JOIN comment ON rev_comment_id = comment_id
WHERE... |
2 years ago |
SELECT *
FROM revision
JOIN comment ON rev_comment_id = comment_id
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
JOIN comment
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
JOIN comment
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
JOIN comment ON comment_text
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
JOIN comment ON comment_text
WHERE comment_text =... |
2 years ago |
SELECT *
FROM revision
JOIN comment ON comment_text
WHERE comment_text =... |
2 years ago |
SELECT *
FROM revision
JOIN comment ON comment_text
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
LIMIT 10 |
2 years ago |
SELECT *
FROM categorylinks
WHERE cl_to = "Proofread"
LIMIT 10 |
2 years ago |
SELECT *
FROM categorylinks
LIMIT 10
|
2 years ago |
SELECT *
FROM revision
LIMIT 10
|
2 years ago |
SELECT *
FROM page
LIMIT 10
|
2 years ago |
SELECT *
FROM revision
LIMIT 30
|
2 years ago |
SELECT *
FROM page
LIMIT 30
|
2 years ago |
SELECT *
FROM revision
LIMIT 30
|
2 years ago |
SELECT *
FROM categorylinks
LIMIT 30
|
2 years ago |
SELECT cl_to
FROM categorylinks
LIMIT 30
|
2 years ago |
SELECT *
FROM revision
LIMIT 30
|
2 years ago |
SELECT *
FROM page
WHERE page_title = "Main_Page"
LIMIT 30 |
2 years ago |
SELECT *
FROM page
ORDER BY "page_id" DESC
LIMIT 30 |
2 years ago |
SELECT *
FROM page
ORDER BY "page_links_updated" DESC
LIMIT 30 |
2 years ago |
SELECT *
FROM page
ORDER BY "page_touched" DESC
LIMIT 30 |
2 years ago |
SELECT *
FROM page
WHERE page_title = "The_Atlantic_Charter" |
2 years ago |
SELECT *
FROM page
WHERE page_title = "Atlantic_Charter" |
2 years ago |
SELECT *
FROM page
LIMIT 30
|
2 years ago |
SELECT *
FROM page
WHERE page_title =... |
2 years ago |
SELECT *
FROM page
WHERE page_title =... |
2 years ago |
SELECT *
FROM page
LIMIT 10 |
2 years ago |
SELECT *
FROM page
WHERE page_title = "Gettysburg_Address"
LIMIT 10 |
2 years ago |
SELECT *
FROM page
LIMIT 10 |
2 years ago |
SELECT *
FROM page
LIMIT 10 |
2 years ago |
SELECT *
FROM page |
2 years ago |
SELECT COUNT(cl_to) as countd
FROM categorylinks
WHERE cl_to = "Proofread"... |
2 years ago |
SELECT COUNT(DISTINCT cl_to) as countd
FROM categorylinks
WHERE cl_to =... |
2 years ago |
SELECT user_name, COUNT(DISTINCT cl_to) as countd
FROM user
INNER JOIN... |
2 years ago |
SELECT cl_to, COUNT(cl_to)
FROM categorylinks
WHERE cl_to = "Proofread" OR... |
2 years ago |
SELECT cl_to, COUNT(cl_to)
FROM categorylinks
WHERE cl_to = "Proofread" OR... |
2 years ago |
SELECT cl_to, COUNT(cl_to)
FROM categorylinks
WHERE cl_to = "Proofread" OR... |
2 years ago |
SELECT DISTINCT cl_to, COUNT(cl_to)
FROM categorylinks
WHERE cl_to =... |
2 years ago |
SELECT DISTINCT cl_to
FROM categorylinks
LIMIT 100 |
2 years ago |
SELECT DISTINCT cl_to, COUNT(cl_to)
FROM categorylinks
LIMIT 100 |
2 years ago |
SELECT DISTINCT user_name, cl_to as pageCondition
FROM user
INNER JOIN... |
2 years ago |
SELECT DISTINCT user_name, COUNT(DISTINCT cl_to) as pageCondition
FROM... |
2 years ago |
SELECT DISTINCT user_name, COUNT(DISTINCT cl_to) as pageCondition
FROM... |
2 years ago |
SELECT DISTINCT user_name, COUNT(DISTINCT cl_to) as pageCondition
FROM... |
2 years ago |
SELECT DISTINCT user_name, cl_to as pageCondition
FROM user
INNER JOIN... |
2 years ago |
SELECT DISTINCT user_name, cl_to as pageCondition
FROM user
INNER JOIN... |
2 years ago |
SELECT DISTINCT user_name, cl_to as pageCondition, cl_to(*) as count
FROM... |
2 years ago |
SELECT DISTINCT user_name, cl_to as pageCondition
FROM user
INNER JOIN... |
2 years ago |
SELECT *
FROM categorylinks
WHERE cl_to = "Proofread" OR "Validated" OR... |
2 years ago |
SELECT cl_to as page_condition
FROM categorylinks
WHERE cl_to = "Proofread"... |
2 years ago |
SELECT *
FROM categorylinks
WHERE cl_to = "Validated" OR "Without text" OR... |
2 years ago |
SELECT *
FROM categorylinks
WHERE cl_to = "Proofread" OR "Validated" OR... |
2 years ago |
SELECT *
FROM categorylinks
WHERE cl_to = "Proofread" OR "Validated"
LIMIT 100 |
2 years ago |
SELECT *
FROM categorylinks
WHERE cl_to = "Proofread"
LIMIT 100 |
2 years ago |
SELECT *
FROM categorylinks
LIMIT 100 |
2 years ago |