SET @ns = 1198; #Translation namespace
USE mediawikiwiki_p;
SELECT... |
5 years ago |
USE mediawikiwiki_p;
SELECT page_title FROM page
JOIN revision ON rev_id =... |
5 years ago |
USE mediawikiwiki_p;
SELECT page_title FROM page
JOIN revision ON rev_id =... |
5 years ago |
USE wikidatawiki_p;
SELECT page_title FROM page
JOIN revision ON rev_id =... |
5 years ago |
USE wikidatawiki_p;
SELECT * FROM page
JOIN revision ON rev_id =... |
5 years ago |
USE wikidatawiki_p;
SELECT * FROM page
JOIN revision ON rev_id =... |
5 years ago |
USE wikidatawiki_p;
SELECT * FROM page
JOIN revision ON rev_id =... |
5 years ago |
USE wikidatawiki_p;
SELECT * FROM page
WHERE page_id IN (57235160, 39514032) |
5 years ago |
USE specieswiki_p;
SELECT
page_namespace,
REPLACE(page_title, '_', ' ') AS... |
5 years ago |
USE specieswiki_p;
SELECT
page_namespace,
REPLACE(page_title, '_', ' ') AS... |
5 years ago |
USE specieswiki_p;
SELECT
REPLACE(page_title, '_', ' ') AS... |
5 years ago |
USE specieswiki_p;
SELECT
REPLACE(page_title, '_', ' ') AS... |
5 years ago |
USE specieswiki_p;
SELECT
REPLACE(page_title, '_', ' ') AS... |
5 years ago |
USE specieswiki_p;
SELECT REPLACE(page_title, '_', ' '), page_len FROM... |
5 years ago |
USE specieswiki_p;
SELECT page_title, page_len FROM page
WHERE... |
5 years ago |
USE specieswiki_p;
SELECT * FROM page
WHERE page_is_redirect = 1
AND... |
5 years ago |
USE specieswiki_p;
SELECT * FROM page
LIMIT 10 |
5 years ago |
USE banwiki_p;
SELECT * FROM page
WHERE page_title = ';' |
5 years ago |
SELECT log_id, log_type, log_action, log_timestamp, log_actor, log_page FROM... |
5 years ago |
SELECT * FROM logging
WHERE log_type IN ('pagetriage-curation',... |
5 years ago |
SELECT * FROM logging
WHERE log_type = 'pagetriage-deletion'
AND log_action... |
5 years ago |
SELECT * FROM logging
WHERE log_type = 'pagetriage-deletion'
AND log_action... |
5 years ago |
SELECT * FROM logging
WHERE log_type IN ('pagetriage-curation',... |
5 years ago |
SELECT l1.log_id, l1.log_type, l1.log_action, l1.log_actor, l1.log_title,... |
5 years ago |
SELECT l1.log_id, l1.log_type, l1.log_action, l1.log_actor, l1.log_title,... |
5 years ago |
SELECT l1.log_id, l1.log_type, l1.log_action, l1.log_actor, l1.log_title,... |
5 years ago |
SELECT l1.log_id, l1.log_type, l1.log_action, l1.log_actor, l1.log_title,... |
5 years ago |
SELECT l1.log_id, l1.log_type, l1.log_action, l1.log_actor,... |
5 years ago |
SELECT l.log_id, l.log_type, l.log_action, l.log_actor, l.log_namespace,... |
5 years ago |
SELECT l1.log_id, l1.log_type, l1.log_action, l1.log_actor,... |
5 years ago |
SELECT l1.log_id, l1.log_type, l1.log_action, l1.log_actor,... |
5 years ago |
SELECT * FROM logging_logindex
WHERE log_type = 'pagetriage-curation'
AND... |
5 years ago |
SELECT * FROM logging_logindex
WHERE log_type = 'pagetriage-curation'
AND... |
5 years ago |
SELECT * FROM logging_logindex
WHERE log_type = 'pagetriage-curation'
AND... |
5 years ago |