| # unreviewed articles by number of external links
SELECT page_title,... |
6 years ago |
| # unreviewed articles by number of external links
SELECT page_title,... |
6 years ago |
| # unreviewed articles by number of external links
SELECT page_title,... |
6 years ago |
| # unreviewed articles by number of external links
SELECT page_title,... |
6 years ago |
| # unreviewed articles by number of external links
SELECT page_title,... |
6 years ago |
| # unreviewed articles by number of external links
SELECT page_title,... |
6 years ago |
| # unreviewed articles by number of external links
SELECT page_title,... |
6 years ago |
| # unreviewed articles by number of external links
SELECT page_title,... |
6 years ago |
| # unreviewed articles by number of external links
SELECT page_title,... |
6 years ago |
| # external links
SELECT page_title, COUNT(*) AS links
# , TRIM(LEADING... |
6 years ago |
| # external links
SELECT COUNT(*) AS links, TRIM(LEADING 'www.' FROM... |
6 years ago |
| # external links
SELECT COUNT(*), TRIM(LEADING 'www.' FROM... |
6 years ago |
| # unreviewed pages that are disambiguation pages
SELECT *
FROM templatelinks... |
6 years ago |
| # unreviewed pages that are disambiguation pages
SELECT *
FROM templatelinks... |
6 years ago |
| # unreviewed pages that are disambiguation pages
SELECT *
FROM templatelinks... |
6 years ago |
| # unreviewed pages that are disambiguation pages
SELECT *
FROM templatelinks... |
6 years ago |
| # unreviewed pages that are disambiguation pages
SELECT *
FROM templatelinks... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT *
FROM... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT *
FROM... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT *
FROM... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT *
FROM... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT *
FROM... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT *
FROM... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT *
FROM... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT *
FROM... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT *
FROM... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT *
FROM... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT *
FROM... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT *
FROM... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages that are redirects to disambiguation pages
SELECT... |
6 years ago |
| # unreviewed pages by template
SELECT *
FROM pagelinks JOIN pagetriage_page... |
6 years ago |
| # unreviewed pages by template
SELECT *
FROM pagelinks JOIN pagetriage_page... |
6 years ago |
| # unreviewed disambiguation pages
SELECT *
FROM pagelinks JOIN... |
6 years ago |
| # unreviewed disambiguation pages
SELECT *
FROM pagelinks JOIN... |
6 years ago |
| # unreviewed disambiguation pages
SELECT *
FROM pagelinks JOIN... |
6 years ago |
| # unreviewed disambiguation pages
SELECT *
FROM pagelinks JOIN... |
6 years ago |
| # unreviewed disambiguation pages
SELECT *
FROM pagelinks JOIN... |
6 years ago |
| # unreviewed disambiguation pages
SELECT *
FROM pagelinks JOIN... |
6 years ago |
| # unreviewed disambiguation pages
SELECT
page_namespace,
page_title
FROM... |
6 years ago |
| SELECT *
FROM revision
WHERE rev_user_text = 'Sid54126'
AND rev_parent_id =... |
6 years ago |
| SELECT page_title
FROM enwiki_p.page JOIN revision ON rev_page=page_id... |
6 years ago |
| SELECT page_title
FROM enwiki_p.page JOIN revision ON rev_page=page_id... |
6 years ago |
| SELECT page_title
FROM enwiki_p.page JOIN revision ON rev_page=page_id... |
6 years ago |
| SELECT page_title, user_name
FROM enwiki_p.page JOIN revision ON... |
6 years ago |
| SELECT page_title, user_name
FROM enwiki_p.page JOIN revision ON... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| SELECT COUNT(*) FROM revision WHERE rev_user = 120801; |
6 years ago |
| SELECT COUNT(*) FROM revision WHERE rev_user = 120801; |
6 years ago |
| SELECT COUNT(*) FROM revision WHERE rev_user = 120801; |
6 years ago |
| SELECT COUNT(*) FROM revision JOIN user WHERE rev_user = 120801; |
6 years ago |
| SELECT COUNT(*) FROM revision JOIN user WHERE rev_user = user_id) editcount
LIMIT 10; |
6 years ago |
| # unreviewed articles by users with less than 15 edits
SELECT user_name,... |
6 years ago |
| # unreviewed articles by users with less than 15 edits
SELECT user_name,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # unreviewed articles by NNPers.
SELECT page_title, rev_user_text,... |
6 years ago |
| # unreviewed articles by NNPers.
SELECT page_title, rev_user_text,... |
6 years ago |
| # unreviewed good articles
SELECT * FROM page JOIN page_props ON pp_page =... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| SELECT log_title
FROM logging_userindex JOIN enwiki_p.page ON page_id =... |
6 years ago |
| SELECT *
FROM logging_userindex JOIN enwiki_p.page ON page_id =... |
6 years ago |
| SELECT COUNT(*)
FROM logging_userindex JOIN enwiki_p.page ON page_id =... |
6 years ago |
| SELECT COUNT(*)
FROM logging_userindex JOIN enwiki_p.page ON page_id =... |
6 years ago |
| SELECT *
FROM logging_userindex JOIN enwiki_p.page ON page_id =... |
6 years ago |
| SELECT *
FROM logging_userindex JOIN enwiki_p.page ON page_id =... |
6 years ago |
| SELECT *
FROM logging_userindex JOIN enwiki_p.page ON page_id =... |
6 years ago |
| SELECT *
FROM logging_userindex
WHERE log_action = 'reviewed'
AND... |
6 years ago |
| SELECT COUNT(*)
FROM logging_userindex
WHERE log_action = 'reviewed'
AND... |
6 years ago |
| SELECT *
FROM logging_userindex
WHERE log_action = 'reviewed'
AND... |
6 years ago |
| SELECT *
FROM logging_userindex
WHERE log_action = 'reviewed'
LIMIT 10 |
6 years ago |
| SELECT *
FROM logging_userindex
WHERE log_user_text IS NOT NULL
LIMIT 10 |
6 years ago |
| SELECT *
FROM logging_userindex
LIMIT 10 |
6 years ago |
| DESCRIBE enwiki_p.pagetriage_tags; |
6 years ago |
| DESCRIBE enwiki_p.pagetriage_log |
6 years ago |
| DESCRIBE pagetriage_log |
6 years ago |
| SHOW TABLES FROM enwiki_p; |
6 years ago |
| SELECT *
FROM pagetriage_page
WHERE ptrp_page_id = 52543001 |
6 years ago |
| DESCRIBE pagetriage_page_tags |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed pages without talk pages that are not dismambiguation... |
6 years ago |
| #reviewed page without talk pages
SELECT page_title
FROM pagetriage_page... |
6 years ago |
| #reviewed page without talk pages
SELECT page_title
FROM pagetriage_page... |
6 years ago |
| #reviewed page without talk pages
SELECT page_title
FROM pagetriage_page... |
6 years ago |
| #reviewed page without talk pages
SELECT page_title
FROM pagetriage_page... |
6 years ago |
| #reviewed page without talk pages
SELECT page_title
FROM pagetriage_page... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| # reviewers of articles by given user
DESCRIBE pagetriage_page
/*SELECT... |
6 years ago |
| # reviewers of articles by given user
SELECT page_title
FROM pagetriage_page... |
6 years ago |
| # reviewers of articles by given user
SELECT page_title
FROM pagetriage_page... |
6 years ago |
| # reviewers of artcles by given user
SELECT page_title, user_name
FROM... |
6 years ago |
| # reviewers of artcles by given user
SELECT page_title, user_name
FROM... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # reviewers of arciles by given user
SELECT page_title, user_name
FROM... |
6 years ago |
| SELECT page_title, user_name
FROM pagetriage_page
JOIN enwiki_p.page ON... |
6 years ago |
| SELECT page title, user_name
FROM pagetriage_page
JOIN enwiki_p.page ON... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page
JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page JOIN enwiki_p.page ON page_id = ptrp_page_id... |
6 years ago |
| SELECT *
FROM pagetriage_page JOIN page ON page_id = ptrp_page_id JOIN... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text user,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text,... |
6 years ago |
| # users by number of unreviewed articles
SELECT rev_user_text,... |
6 years ago |
| # users by number of unreviewed articles
SELECT user_editcount FROM user... |
6 years ago |
| SELECT rev_user_text, COUNT(rev_id)
FROM revision JOIN pagetriage_page ON... |
6 years ago |
| SELECT rev_user_text, COUNT(rev_id)
FROM revision JOIN pagetriage_page ON... |
6 years ago |
| SELECT rev_user_text, COUNT(rev_id)
FROM revision JOIN pagetriage_page ON... |
6 years ago |
| # unreviewed articles by NNPers.
SELECT page_title, rev_user_text,... |
6 years ago |
| SELECT rev_user_text, COUNT(rev_id)
FROM revision JOIN pagetriage_page ON... |
6 years ago |
| SELECT rev_user_text, COUNT(rev_id)
FROM revision JOIN pagetriage_page ON... |
6 years ago |
| SELECT rev_user_text, COUNT(rev_page_id)
FROM revision JOIN pagetriage_page... |
6 years ago |
| SELECT rev_user_text, COUNT(rev_page_id) FROM revision JOIN pagetriage_page... |
6 years ago |
| DESCRIBE revision
/*
SELECT rev_user_text, COUNT(rev_page_id) FROM revision... |
6 years ago |
| #DESCRIBE pagetriage_page
SELECT *
FROM pagetriage_page JOIN page ON... |
6 years ago |
| #DESCRIBE pagetriage_page
SELECT *
FROM pagetriage_page JOIN page ON... |
6 years ago |
| #DESCRIBE pagetriage_page
SELECT *
FROM pagetriage_page JOIN page ON... |
6 years ago |
| DESCRIBE pagetriage_page
/*SELECT *
FROM pagetriage_page JOIN page ON... |
6 years ago |
| SELECT *
FROM pagetriage_page JOIN page ON page_id = prtp_page_id
WHERE... |
6 years ago |
| SELECT *
FROM pagetriage_page JOIN page ON page_id = prtp_page_id
WHERE... |
6 years ago |
| SELECT *
FROM pagetriage_page JOIN page ON page_id = prtp_page_id
WHERE... |
6 years ago |
| SELECT *
FROM pagetriage_page JOIN page ON page_id = prtp_page_id
WHERE... |
6 years ago |
| SELECT *
FROM pagetriage_page
WHERE ptrp_reviewed = 0;
|
6 years ago |
| SELECT * FROM page JOIN page_props ON pp_page = page_id JOIN pagetriage_page... |
6 years ago |
| DESCRIBE enwiki_p.pagetriage_page;
/*SELECT COUNT(ptrp_created),... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT COUNT(ptrp_created),... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT COUNT(rev_parent_id),... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT COUNT(page_id),... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT COUNT(page_id),... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT COUNT(page_id),... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT SELECT COUNT(page_id),... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT SELECT COUNT(page_id),... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT page_title rev_user_text,... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT rev_user_text, COUNT(DISTINCT... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT rev_user_text, COUNT(DISTINCT... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT rev_user_text, COUNT(DISTINCT... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT rev_user_text, page_title,... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT rev_user_text, page_title,... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT rev_user_text, page_title,... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT rev_user_text, page_title,... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT rev_user_text, page_title,... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT rev_user_text, page_title,... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT rev_user_text, page_title
FROM... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT *
FROM revision_userindex
JOIN... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT *
FROM revision_userindex JOIN... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT *
FROM enwiki_p.page JOIN... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT *
FROM enwiki_p.page JOIN... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT enwiki_p.page.page_title
FROM... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT rev_user_text, page_title
FROM... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT rev_user_text, page_title
FROM... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT rev_user_text, page_title,... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT rev_user_text... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT *
FROM enwiki_p.pagetriage_page... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT *
FROM enwiki_p.pagetriage_page... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT COUNT(*)
FROM... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT COUNT(*)
FROM... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT COUNT(*)
FROM... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT COUNT(*)
FROM... |
6 years ago |
| # DESCRIBE enwiki_p.pagetriage_page;
SELECT COUNT(*)
FROM... |
6 years ago |
| DESCRIBE enwiki_p.pagetriage_page;
|
6 years ago |
| # unreviewed by most articles per user
SELECT rev_user_text,... |
6 years ago |
| # unreviewed by most articles per user
SELECT page_title, rev_user_text,... |
6 years ago |
| # unreviewed by most articles per user
SELECT page_title, rev_user_text,... |
6 years ago |
| SELECT *
FROM page JOIN page_restrictions ON page_id = pr_page JOIN... |
6 years ago |
| SELECT *
FROM page JOIN page_restrictions ON page_id = pr_page JOIN... |
6 years ago |
| SELECT *
FROM page JOIN revision ON page_id = rev_page JOIN... |
6 years ago |
| SELECT *
FROM page JOIN revision ON page_id = rev_page JOIN... |
6 years ago |
| SELECT *
FROM page JOIN revision ON page_id = rev_page
WHERE page_title =... |
6 years ago |
| SELECT *
FROM page LEFT JOIN revision ON page_id = rev_page
WHERE... |
6 years ago |
| SELECT *
FROM page LEFT JOIN revision ON page_id = rev_page
WHERE... |
6 years ago |
| SELECT *
FROM page LEFT JOIN revision ON page_id = rev_page
WHERE... |
6 years ago |
| SELECT *
FROM page LEFT JOIN revision ON page_id = rev_page
WHERE... |
6 years ago |
| SELECT *
FROM page
WHERE page_title = 'Conchita Moreno'; |
6 years ago |
| SELECT *
FROM page
WHERE page_id = '58404632'; |
6 years ago |
| use enwiki_p
SELECT *
FROM page
WHERE page_id = '58404632'; |
6 years ago |
| use enwiki_p
SELECT *
FROM enwiki_p.page
WHERE page.page_id = 58404632; |
6 years ago |
| use enwiki_p
SELECT *
FROM enwiki_p.page
WHERE page_id = 58404632; |
6 years ago |
| use enwiki_p
SELECT * from page
WHERE page_id = 58404632; |
6 years ago |
| DESCRIBE enwiki_p.page; |
6 years ago |
| SELECT page_id
FROM page
WHERE page_title = "Gudrun Ensslin"; |
6 years ago |
| SELECT page_id,
FROM page
WHERE page_title = "Gudrun Ensslin"; |
6 years ago |
| SELECT page_id, rev_user_text
FROM revision_userindex JOIN page ON rev_page... |
6 years ago |
| SELECT page_title, page_id, rev_user_text
FROM revision_userindex JOIN page... |
6 years ago |
| SELECT page_title, rev_user_text
FROM revision_userindex JOIN page ON... |
6 years ago |
| SELECT page_title, rev_user_text
FROM revision_userindex JOIN page ON... |
6 years ago |
| SELECT page_title, rev_user_text, COUNT(rev_user)
FROM enwiki_p.revision... |
6 years ago |
| SELECT *
FROM pagelinks
WHERE pl_title = 'Carl_Freedman_Gallery'; |
6 years ago |
| SELECT *
FROM pagelinks
AND pl_title = 'Carl_Freedman_Gallery'; |
6 years ago |
| SELECT
page_namespace,
page_title
FROM page
JOIN pagelinks
ON pl_from =... |
6 years ago |
| SELECT page_title, rev_user_text, COUNT(rev_user)
FROM enwiki_p.revision... |
6 years ago |
| SELECT page_title, rev_user_text, COUNT(rev_user)
FROM enwiki_p.revision
... |
6 years ago |
| # unreviewed disambiguation pages
SELECT * FROM page JOIN page_props ON... |
6 years ago |
| SELECT * FROM page JOIN page_props ON pp_page = page_id JOIN pagetriage_page... |
6 years ago |
| #SHOW TABLES FROM enwiki_p;
# DESCRIBE revision_userindex
SELECT... |
6 years ago |
| #SHOW TABLES FROM enwiki_p;
# DESCRIBE revision_userindex
SELECT... |
6 years ago |
| #SHOW TABLES FROM enwiki_p;
# DESCRIBE revision_userindex
SELECT *
FROM... |
6 years ago |
| #SHOW TABLES FROM enwiki_p;
# DESCRIBE revision_userindex
SELECT *
FROM... |
6 years ago |
| SHOW TABLES FROM enwiki_p;
DESCRIBE revision_userindex
/* SELECT *
FROM... |
6 years ago |
| SHOW TABLES FROM enwiki_p;
# DESCRIBE revision_user_index;
/* SELECT *
FROM... |
6 years ago |
| DESCRIBE revision_user_index;
/* SELECT *
FROM revision_user_index
WHERE... |
6 years ago |
| DESCRIBE enwiki_p.revision_user_index;
/* SELECT *
FROM... |
6 years ago |
| SELECT *
FROM revision_user_index
WHERE rev_user_text = 'Aghachi7'
AND... |
6 years ago |
| DESCRIBE enwiki_p.revision_userindex; |
6 years ago |
| use enwiki_p;
SELECT *
FROM revision
WHERE revision.rev_user_text =... |
6 years ago |
| use enwiki_p;
SELECT page_title
FROM revision JOIN page ON revision.rev_page... |
6 years ago |
| use enwiki_p;
SELECT page_title
FROM revision JOIN page ON revision.rev_page... |
6 years ago |
| SELECT page_title
FROM revision JOIN page ON rev_page = page_id
WHERE... |
6 years ago |
| SELECT page_title
FROM revision JOIN page ON rev_page = page_id
WHERE... |
6 years ago |
| SELECT page_title
FROM revision JOIN page ON rev_page = page_id
WHERE... |
6 years ago |
| SELECT page_title
FROM revision JOIN page ON rev_page = page_id
WHERE... |
6 years ago |
| SELECT page_title
FROM revision JOIN page ON rev_page = page_id
WHERE... |
6 years ago |
| SELECT page_title, rev_user_text, COUNT(rev_user)
FROM enwiki_p.revision... |
6 years ago |
| SELECT page_title, rev_user_text, COUNT(rev_user)
FROM enwiki_p.revision... |
6 years ago |
| SELECT page_title, rev_user_text, COUNT(rev_user)
FROM enwiki_p.revision
... |
6 years ago |
| SELECT * FROM page JOIN page_props ON pp_page = page_id JOIN pagetriage_page... |
6 years ago |
| SELECT * FROM page JOIN page_props ON pp_page = page_id JOIN pagetriage_page... |
6 years ago |
| SELECT * FROM page JOIN page_props ON pp_page = page_id JOIN pagetriage_page... |
6 years ago |
| SELECT * FROM page JOIN page_props ON pp_page = page_id JOIN pagetriage_page... |
6 years ago |
| SELECT * FROM page JOIN page_props ON pp_page = page_id JOIN pagetriage_page... |
6 years ago |
| SELECT * FROM page JOIN page_props ON pp_page = page_id JOIN pagetriage_page... |
6 years ago |
| SELECT * FROM page JOIN page_props ON pp_page = page_id JOIN pagetriage_page... |
6 years ago |
| SELECT * FROM page JOIN page_props ON pp_page = page_id JOIN pagetriage_page... |
6 years ago |
| SELECT * FROM page JOIN page_props ON pp_page = page_id
WHERE pp_propname =... |
6 years ago |
| SELECT * FROM page JOIN pp_page ON pp_page = page_id
WHERE pp_propname =... |
6 years ago |
| SELECT DISTINCT pp_propname FROM page_props; |
6 years ago |
| DESCRIBE wbc_entity_usage;
|
6 years ago |
| SHOW TABLES FROM enwiki_p;
|
6 years ago |
| SELECT page_title, rev_user_text, COUNT(rev_user)
FROM enwiki_p.revision... |
6 years ago |
| SELECT page_title, rev_user_text, COUNT(rev_user)
FROM enwiki_p.revision... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT *... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/*
SELECT... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
SELECT *... |
6 years ago |
| # SHOW TABLES FROM enwiki_p;
DESCRIBE enwiki_p.pagetriage_page; |
6 years ago |
| SHOW TABLES FROM enwiki_p; |
6 years ago |
| SELECT
*
FROM
tables; |
6 years ago |
| SELECT
table_name
FROM
user; |
6 years ago |
| SELECT
table_name
FROM
all_tables; |
6 years ago |
| SELECT page_title, rev_user_text, rev_comment
FROM revision JOIN page ON... |
6 years ago |
| SELECT page_title, rev_user_text, rev_comment
FROM revision JOIN page ON... |
6 years ago |
| SELECT page_title, rev_user_text, rev_comment
FROM revision JOIN page ON... |
6 years ago |
| SELECT page_title, rev_user_text, rev_comment
FROM revision JOIN page ON... |
6 years ago |
| SELECT user_name FROM user JOIN user_groups ON ug_user = user_id WHERE... |
6 years ago |
| SELECT ug_user user_name FROM user_groups JOIN user_groups ON ug_user =... |
6 years ago |
| SELECT ug_user, user_text FROM user_groups WHERE ug_group = 'sysop'
|
6 years ago |
| SELECT ug_user FROM user_groups WHERE ug_group = 'sysop'
|
6 years ago |
| SELECT ptrp_page_id, page_title, page_counter FROM pagetriage_page, page... |
6 years ago |
| SELECT ptrp_page_id, page_title, page_counter FROM pagetriage_page, page... |
6 years ago |
| SELECT ptrp_page_id, page_title, page_views FROM pagetriage_page, page... |
6 years ago |
| SELECT ptrp_page_id, page_title FROM pagetriage_page, page WHERE... |
6 years ago |
| SELECT ptrp_page_id, page_title FROM pagetriage_page, page WHERE... |
6 years ago |
| SELECT ptrp_page_id, page_title FROM pagetriage_page, page WHERE... |
6 years ago |
| SELECT ptrp_page FROM pagetriage_page, page WHERE ptrp_reviewed = 1 AND... |
6 years ago |
| SELECT ptrp_page_id FROM pagetriage_page, page WHERE ptrp_reviewed = 1 AND... |
6 years ago |
| SELECT COUNT(ptrp_page_id) AS reviewed_count FROM pagetriage_page, page... |
6 years ago |
| SELECT COUNT(ptrp_page_id) AS reviewed_count FROM pagetriage_page, page... |
6 years ago |
