| /*
USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace =... |
4 years ago |
| /*
USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace =... |
4 years ago |
| /*
USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace =... |
4 years ago |
| /*
USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace =... |
4 years ago |
| /*
USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace =... |
4 years ago |
| /*
USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace =... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| USE enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT
CONCAT (
CASE
WHEN tl.tl_namespace = 10 THEN... |
4 years ago |
| use enwikinews_p;
SELECT tl.tl_namespace, tl.tl_title, COUNT(*) FROM... |
4 years ago |
| use enwikinews_p;
SELECT tl.tl_namespace, tl.tl_title, COUNT(*) FROM... |
4 years ago |
| use enwikinews_p;
SELECT tl.tl_namespace, tl.tl_title, COUNT(*) FROM... |
4 years ago |
| use enwikinews_p;
SELECT tl.namespace, tl.tl_title, COUNT(*) FROM... |
4 years ago |
| use enwikinews_p;
SELECT tl.namespace, tl.tl_title, COUNT(*) FROM... |
4 years ago |
| use enwikinews_p;
SELECT tl.tl_title FROM templatelinks tl
WHERE... |
4 years ago |
| use enwikinews_p;
SELECT tl.tl_title, COUNT( * ) FROM templatelinks tl
WHERE... |
4 years ago |
| use enwikinews_p;
SELECT tl.tl_title, COUNT( * ) FROM templatelinks tl
WHERE... |
4 years ago |
| use enwikinews_p;
SELECT tl.tl_title, COUNT( * ) FROM templatelinks tl
WHERE... |
4 years ago |
| use enwikinews_p;
SELECT * FROM templatelinks tl
WHERE tl.tl_namespace =... |
4 years ago |
| use enwikinews_p;
SELECT * FROM templatelinks tl
WHERE tl.tl_namespace =... |
4 years ago |
| use enwikinews_p;
SELECT SUBSTR( pg.page_title, 1, LENGTH( pg.page_title ) -... |
4 years ago |
| use enwikinews_p;
SELECT SUBSTR( pg.page_title, 1, LENGTH( pg.page_title ) -... |
4 years ago |
| use enwikinews_p;
SELECT cl.*, pg.*, SUBSTR( pg.page_title, 1, LENGTH(... |
4 years ago |
| use enwikinews_p;
SELECT cl.*, pg.*, SUBSTR( pg.page_title, 1, LENGTH(... |
4 years ago |
| use enwikinews_p;
SELECT cl.*, pg.*, SUBSTR( pg.page_title, 1, LENGTH(... |
4 years ago |
| use enwikinews_p;
SELECT cl.*, pg.*, SUBSTR( pg.page_title, 1, LENGTH(... |
4 years ago |
| use enwikinews_p;
SELECT cl.*, pg.*
FROM categorylinks cl
JOIN page pg ON... |
4 years ago |
| use enwikinews_p;
SELECT *
FROM categorylinks
JOIN page ON cl_from =... |
4 years ago |
| use enwikinews_p;
SELECT * FROM categorylinks
WHERE cl_to = 'Possible-risk/use-count' |
4 years ago |
| SELECT rev_user_text, COUNT(*) FROM revision_userindex
WHERE rev_timestamp >... |
4 years ago |
| SELECT rev_user_text, COUNT(*) FROM revision_userindex
WHERE rev_id IN... |
4 years ago |
| SELECT rev_user_text, COUNT(*) FROM revision_userindex
WHERE rev_id IN... |
4 years ago |
| SELECT *, COUNT(*) FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id... |
4 years ago |
| SELECT * FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id FROM... |
4 years ago |
| SELECT * FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id FROM... |
4 years ago |
| SELECT *, COUNT(*) FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id... |
4 years ago |
| SELECT *, COUNT(*) FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id... |
4 years ago |
| SELECT *, COUNT(*) FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id... |
4 years ago |
| SELECT *, COUNT(*) FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id... |
4 years ago |
| SELECT *, COUNT(*) FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id... |
4 years ago |
| SELECT * FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id FROM... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT rev_comment_id FROM revision_userindex
LEFT JOIN comment ON... |
4 years ago |
| SELECT rev_user FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT *, comment.comment_text FROM revision_userindex
LEFT JOIN comment ON... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT *, comment.comment_text FROM revision_userindex
LEFT JOIN comment ON... |
4 years ago |
| SELECT rev_id, rev_user_text, rev_timestamp, comment.comment_text FROM... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT rev_id, rev_user_text, rev_timestamp, comment.comment_text FROM... |
4 years ago |
| SELECT rev_user_text, comment.comment_text FROM revision_userindex
LEFT JOIN... |
4 years ago |
| SELECT rev_user_text FROM revision_userindex
LEFT JOIN comment ON comment_id... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
INNER JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
INNER JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
INNER JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
INNER JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
WHERE rev_id IN (SELECT ct_rev_id FROM change_tag... |
4 years ago |
| SELECT * FROM revision
WHERE rev_id IN (SELECT ct_rev_id FROM change_tag... |
4 years ago |
| SELECT * FROM revision
WHERE rev_id IN (SELECT ct_rev_id FROM change_tag... |
4 years ago |
| SELECT * FROM revision
WHERE rev_id IN (SELECT ct_rev_id FROM change_tag... |
4 years ago |
| SELECT * FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id FROM... |
4 years ago |
| SELECT * FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id FROM... |
4 years ago |
| SELECT * FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id FROM... |
4 years ago |
| SELECT * FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id FROM... |
4 years ago |
| SELECT * FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id FROM... |
4 years ago |
| SELECT * FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id FROM... |
4 years ago |
| SELECT * FROM revision_userindex
WHERE rev_timestamp > 201901010000
AND... |
4 years ago |
| SELECT * FROM revision_userindex
WHERE rev_timestamp > 201901010000
AND... |
4 years ago |
| SELECT * FROM revision_userindex
INNER JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT *, comment.comment_text FROM revision_userindex
LEFT JOIN comment ON... |
4 years ago |
| SELECT *, comment.comment_text FROM revision
LEFT JOIN comment ON comment_id... |
4 years ago |
| SELECT *, comment.comment_text FROM revision
LEFT JOIN comment ON comment_id... |
4 years ago |
| SELECT *, comment.comment_text FROM revision
LEFT JOIN comment ON comment_id... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
WHERE rev_id IN (SELECT ct_rev_id FROM change_tag... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM recentchanges_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM recentchanges_userindex
WHERE rc_type = 0
AND rc_bot = 0
AND ... |
4 years ago |
| SELECT * FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id FROM... |
4 years ago |
| SELECT * FROM revision_userindex
WHERE rev_id IN (SELECT ct_rev_id FROM... |
4 years ago |
| SELECT * FROM recentchanges_userindex
WHERE rc_type = 0
AND rc_id IN (SELECT... |
4 years ago |
| SELECT * FROM recentchanges_userindex
WHERE rc_type = 0
AND rc_id IN (SELECT... |
4 years ago |
| SELECT * FROM recentchanges_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM recentchanges_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM recentchanges_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM recentchanges_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM recentchanges_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT rev_user FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision_userindex
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT *, comment.comment_text FROM revision
LEFT JOIN comment ON comment_id... |
4 years ago |
| SELECT rev_user_text, comment.comment_text FROM revision
LEFT JOIN comment... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id =... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id = rev_comment_id
LEFT... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id = rev_comment_id
LEFT... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON comment_id = rev_comment_id
LIMIT 100 |
4 years ago |
| SELECT * FROM revision
LEFT JOIN commen ON comment_id = rev_comment_id
LIMIT 100 |
4 years ago |
| SELECT * FROM revision
LIMIT 100 |
4 years ago |
| SELECT * FROM page
WHERE page_is_new = 0
AND page_is_redirect = 0
AND... |
4 years ago |
| SELECT * FROM page
WHERE page_is_redirect = 0
AND page_is_new = 1
AND... |
4 years ago |
| SELECT * FROM page
WHERE page_is_redirect = 0
AND page_is_new = 1
AND... |
4 years ago |
| SELECT * FROM page
WHERE page_is_redirect = 0
AND page_is_new = 1
AND... |
4 years ago |
| SELECT * FROM page
WHERE page_is_redirect = 0
AND page_is_new = 1
AND... |
4 years ago |
| SELECT * FROM page
WHERE page_is_redirect = 0
AND page_is_new = 1
AND... |
4 years ago |
| SELECT * FROM page
WHERE page_is_redirect = 0
AND page_is_new = 1
AND... |
4 years ago |
| SELECT * FROM page
WHERE page_is_redirect = 0
AND page_is_new = 1
AND... |
4 years ago |
| SELECT * FROM page
WHERE page_is_redirect = 0
AND page_is_new = 1
LIMIT 100 |
4 years ago |
