| SELECT log_timestamp, log_title, log_user_text, log_comment FROM logging... |
5 years ago |
| SELECT * FROM logging WHERE log_namespace=118 AND log_type="delete" AND... |
5 years ago |
| SELECT * FROM logging WHERE log_namespace=118 LIMIT 10; |
5 years ago |
| SELECT * FROM logging LIMIT 10; |
5 years ago |
| SELECT * FROM log_action LIMIT 10; |
5 years ago |
| SELECT user_name FROM user WHERE user_name LIKE '%L0CK%'; |
5 years ago |
| SELECT user_name FROM user WHERE user_name LIKE '%L0CK%'; |
5 years ago |
| SELECT pl_from_namespace, page_title, pl_namespace, pl_title
FROM pagelinks... |
6 years ago |
| SELECT pl_from_namespace, page_title, pl_title
FROM pagelinks PL
JOIN page... |
6 years ago |
| SELECT pl_from_namespace, P.page_title, pl_title
FROM pagelinks PL, page... |
6 years ago |
| SELECT pl_from_namespace, page_title, pl_title
FROM pagelinks PL, page... |
6 years ago |
| SELECT COUNT(*), rl_title_ft
FROM u2815__p.redlinks_enwiki_pwibble
WHERE... |
6 years ago |
| SELECT COUNT(*), rl_title_ft
FROM u2815__p.redlinks_enwiki_p
WHERE... |
6 years ago |
| SELECT COUNT(*), rl_title_ft
FROM... |
6 years ago |
| SELECT * FROM redirect WHERE rd_title LIKE 'fr:%'
LIMIT 100; |
6 years ago |
| SELECT page_namespace, page_title, iwl_title
FROM iwlinks
JOIN page ON... |
6 years ago |
| SELECT page_namespace, page_title, iwl_title
FROM iwlinks
JOIN page ON... |
6 years ago |
| SELECT page_namespace, page_title, iwl_title from iwlinks WHERE iwl_prefix =... |
6 years ago |
| SELECT * from iwlinks WHERE iwl_prefix = 'fr'
/*redirect WHERE rd_title LIKE... |
6 years ago |
| SELECT * from iwlinks
/*redirect WHERE rd_title LIKE "[a-z][a-z]:%" AND... |
6 years ago |
| SELECT * from interwiki /*redirect WHERE rd_title LIKE "[a-z][a-z]:%" AND... |
6 years ago |
| SELECT * from redirect WHERE rd_title LIKE "[a-z][a-z]:%" AND... |
6 years ago |
| SELECT * from redirect WHERE rd_title LIKE "__:%" AND LEFT(rd_title,2) =... |
6 years ago |
| SELECT * from redirect WHERE rd_title LIKE "__:%"
LIMIT 1000; |
6 years ago |
| SELECT * from redirect WHERE rd_title LIKE "__:%"
LIMIT 10; |
6 years ago |
| SELECT pl_from, pl_title
FROM pagelinks
WHERE pl_from_namespace = 0 AND... |
6 years ago |
