Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
LD
.
Toggle Highlighting
SQL
SELECT CONCAT('[[', CASE page_namespace WHEN 0 THEN '' WHEN 1 THEN 'Disccussion:' WHEN 2 THEN 'Utilisateur:' WHEN 3 THEN 'Discussion Utilisateur:' WHEN 4 THEN 'Wikipedia:' WHEN 5 THEN 'Disccussion Wikipedia:' WHEN 8 THEN 'Mediawiki:' WHEN 9 THEN 'Discussion Mediawiki:' WHEN 10 THEN 'Modèle:' WHEN 11 THEN 'Discussion Modèle:' WHEN 12 THEN 'Aide:' WHEN 13 THEN 'Discussion Aide:' WHEN 14 THEN 'Categorie:' WHEN 15 THEN 'Disccussion categorie:' WHEN 100 THEN 'Portail:' WHEN 101 THEN 'Discussion Portail:' WHEN 102 THEN 'Projet:' WHEN 103 THEN 'Discussion Projet:' WHEN 828 THEN 'Module:' WHEN 829 THEN 'Discussion Module:' ELSE page_namespace END, REPLACE(page_title,'_',' '), ']]') AS link, rev_timestamp AS timestamp, comment_text AS `comment`, actor_name AS `user` FROM page, revision, `comment`, actor WHERE page_title REGEXP '^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}' AND page_namespace = 2 AND page_len=0 AND page_latest=rev_id AND rev_comment_id=comment_id AND rev_actor=actor_id ORDER BY rev_timestamp DESC
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...