| SET @group = 'bot';
USE... |
3 years ago |
| SELECT
page_title
FROM page
JOIN redirect
ON page_id = rd_from
WHERE... |
3 years ago |
| USE wikidatawiki_p;
SELECT * FROM page
WHERE page_is_redirect = 1
AND... |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM page
WHERE page_is_redirect = 1
LIMIT 100 |
4 years ago |
| USE wikidatawiki_p;
SELECT * FROM page
LIMIT 100 |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_timestamp,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_timestamp,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_timestamp,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_timestamp,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_timestamp,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_timestamp,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_timestamp,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_timestamp,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_timestamp,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_timestamp,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_timestamp,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_actor,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_actor,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_actor,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_actor,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_actor,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_actor,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_actor,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_actor,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_actor,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_actor,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_actor,... |
4 years ago |
| SELECT revision.rev_page, revision.rev_comment_id, revision.rev_actor,... |
4 years ago |
| SELECT revision.*, comment.* FROM revision
LEFT JOIN comment ON... |
4 years ago |
| SELECT revision.*, comment.* FROM revision
LEFT JOIN comment ON... |
4 years ago |
| SELECT revision.*, comment.* FROM revision
LEFT JOIN comment ON... |
4 years ago |
| SELECT * FROM revision
LEFT JOIN comment ON rev_comment_id =... |
4 years ago |
| SELECT *, comment.* FROM revision
LEFT JOIN comment ON rev_comment_id =... |
4 years ago |
| SELECT *, comment.* FROM revision
LEFT JOIN coment ON rev_comment_id =... |
4 years ago |
| SELECT *, comment.* FROM revision
LEFT JOIN coment ON rev_comment_id =... |
4 years ago |
| SELECT * FROM revision
WHERE rev_page = 26204397
LIMIT 10 |
4 years ago |
| SELECT * FROM logging
WHERE log_action = 'move'
LIMIT 10 |
4 years ago |
| SELECT * FROM logging
WHERE log_action = move
LIMIT 10 |
4 years ago |
| SELECT * FROM logging
WHERE log_action = move
LIMIT 10 |
4 years ago |
| SELECT * FROM logging
WHERE log_action = move
LIMIT 10 |
4 years ago |
| SELECT * FROM logging
WHERE log_type = move
LIMIT 10 |
4 years ago |
| SELECT * FROM logging
WHERE log_action = move
LIMIT 10 |
4 years ago |
| SELECT * FROM page
WHERE page_namespace = 9
AND page_title NOT IN (SELECT... |
4 years ago |
| SELECT * FROM logging
LEFT JOIN comment ON log_comment_id = comment_id
WHERE... |
4 years ago |
| SELECT * FROM logging
LEFT JOIN comment ON log_comment_id = comment_id
WHERE... |
4 years ago |
| SELECT * FROM logging
LEFT JOIN comment ON log_comment_id = comment_id
WHERE... |
4 years ago |
| SELECT * FROM logging
LEFT JOIN comment ON log_comment_id = comment_id
WHERE... |
4 years ago |
| SELECT * FROM logging
LEFT JOIN comment ON log_comment_id = comment_id
WHERE... |
4 years ago |
| SELECT logging.* FROM logging
JOIN comment ON log_comment_id =... |
4 years ago |
| SELECT logging.*, comment.* FROM logging
JOIN comment ON log_comment_id =... |
4 years ago |
| SELECT *, comment.* FROM logging
JOIN comment ON log_comment_id =... |
4 years ago |
| SELECT *, comment.* FROM logging
FULL JOIN comment ON log_comment_id =... |
4 years ago |
| SELECT *, comment.* FROM logging
FULL OUTER JOIN comment ON log_comment_id =... |
4 years ago |
| SELECT *, comment.* FROM logging
LEFT JOIN comment ON log_comment_id =... |
4 years ago |
| SELECT * FROM logging
WHERE log_timestamp > 20190101000000
AND log_type =... |
4 years ago |
| SELECT * FROM logging
WHERE log_timestamp > 20190101000000
AND log_type =... |
4 years ago |
| SELECT * FROM logging
LEFT JOIN comment ON log_comment_id = comment_id
WHERE... |
4 years ago |
| SELECT * FROM logging
LEFT JOIN comment ON log_comment_id = comment_id
WHERE... |
4 years ago |
| SELECT * FROM logging
LEFT JOIN comment ON log_comment_id = comment_id
WHERE... |
4 years ago |
| SELECT *t FROM logging
LEFT JOIN comment ON log_comment_id =... |
4 years ago |
| SELECT *, comment.comment_text FROM logging
LEFT JOIN comment ON... |
4 years ago |
| SELECT *, comment.text FROM logging
LEFT JOIN comment ON log_comment_id =... |
4 years ago |
| SELECT *, comment.text FROM logging
LEFT JOIN comment ON log_comment_id =... |
4 years ago |
| SELECT *, comment.text FROM logging
LEFT JOIN comment ON log_comment_id =... |
4 years ago |
| SELECT *, comment.* FROM logging
LEFT JOIN comment ON log_comment_id =... |
4 years ago |
| SELECT * FROM logging
WHERE log_type = 'move'
AND log_namespace = 2
LIMIT 10 |
4 years ago |
| SELECT * FROM logging
WHERE log_type = 'move'
LIMIT 10 |
4 years ago |
| SELECT * FROM logging
LIMIT 10 |
4 years ago |
| SELECT
DISTINCT cat1.cl_from,
CONCAT('[[', pg1.page_title, ']]') AS... |
4 years ago |
| SELECT
DISTINCT cat1.cl_from,
CONCAT('[[', pg1.page_title, ']]') AS... |
4 years ago |
| SELECT
DISTINCT cat1.cl_from,
CONCAT('[[Talk:', pg1.page_title, ']]') AS... |
4 years ago |
| SELECT * FROM image
WHERE img_name LIKE '%.webp'
OR img_name LIKE '%.webm'
LIMIT 10 |
4 years ago |
| SELECT * FROM image
WHERE img_name LIKE '%.oga'
LIMIT 1 |
4 years ago |
| SELECT * FROM image
WHERE img_name LIKE '%.JpG'
LIMIT 1 |
4 years ago |
| SELECT * FROM image
WHERE img_name LIKE '%.jpG'
LIMIT 1 |
4 years ago |
| SELECT * FROM image
WHERE img_name LIKE '%.jpG' |
4 years ago |
| SELECT * FROM revision
WHERE rev_actor = 2167
LIMIT 100 |
4 years ago |
| SELECT * FROM revision
LIMIT 100 |
4 years ago |
