use enwiki_p;
SELECT COUNT(DISTINCT rd_from) FROM redirect INNER JOIN page... |
6 years ago |
use enwiki_p;
SELECT COUNT(DISTINCT rd_from) FROM redirect INNER JOIN page... |
6 years ago |
use enwiki_p;
SELECT COUNT(DISTINCT rd_from) FROM redirect RIGHT JOIN page... |
6 years ago |
use enwiki_p;
SELECT COUNT(DISTINCT rd_from) FROM redirect LEFT JOIN page... |
6 years ago |
use enwiki_p;
SELECT COUNT(DISTINCT rd_from) FROM redirect INNER JOIN page... |
6 years ago |
use enwiki_p;
SELECT COUNT(DISTINCT rd_from) FROM redirect INNER JOIN page... |
6 years ago |
use enwiki_p;
SELECT * FROM redirect INNER JOIN page ON redirect.rd_from =... |
6 years ago |
use enwiki_p;
SELECT * FROM redirect INNER JOIN page ON redirect.rd_from =... |
6 years ago |
use enwiki_p;
SELECT * FROM redirect LIMIT 10; |
6 years ago |
use enwiki_p;
SELECT * from page where page_id = "26228348"; |
6 years ago |
use enwiki_p;
SELECT * from redirect where rd_namespace = 2 LIMIT 100; |
6 years ago |
use enwiki_p;
SELECT * from redirect where rd_namespace != 0 LIMIT 100; |
6 years ago |
use enwiki_p;
SELECT * from redirect LIMIT 100; |
6 years ago |
use enwiki_p;
SELECT page_namespace FROM page WHERE page_is_redirect = '1'... |
6 years ago |
use enwiki_p;
SELECT page_namespace FROM page WHERE page_is_redirect = '1' LIMIT 10; |
6 years ago |
use enwiki_p;
SELECT page_namespace FROM page WHERE page_is_redirect = '1'; |
6 years ago |
use enwiki_p;
SELECT * FROM page WHERE page_id = '58447953'; |
6 years ago |
use enwiki_p;
SELECT rd_from FROM redirect LIMIT 10; |
6 years ago |
use enwiki_p;
DESC redirect; |
6 years ago |
use enwiki_p;
SELECT * FROM redirect LIMIT 100; |
6 years ago |
use enwiki_p;
DESC page; |
6 years ago |
use enwiki_p;
DESC redirect; |
6 years ago |
use frwiki_p;
select WEEKDAY(log_timestamp) as 'timestamp', log_user_text... |
6 years ago |