USE enwiki_p;
SELECT * FROM iwlinks iwl
WHERE iwl_prefix = "w"
LIMIT 1,100; |
5 years ago |
USE enwiki_p;
SELECT * FROM iwlinks iwl
LIMIT 1,100; |
5 years ago |
USE enwiki_p;
SELECT * FROM iwlinks iwl
WHERE iwl.iwl_from = 34708556
LIMIT 1,100; |
5 years ago |
USE enwiki_p;
SELECT * FROM iwlinks iwl
JOIN page p ON iwl.iwl_from =... |
5 years ago |
USE enwiki_p;
SELECT * FROM iwlinks
OUTER JOIN page p ON iwl_from =... |
5 years ago |
USE enwiki_p;
SELECT * FROM iwlinks
JOIN page p ON iwl_from = page_id
WHERE... |
5 years ago |
USE enwiki_p;
SELECT * FROM iwlinks
INNER JOIN page p ON iwl_from =... |
5 years ago |
USE enwiki_p;
SELECT * FROM iwlinks
WHERE iwl_prefix = "wiki"
LIMIT 1,100; |
5 years ago |
USE enwiki_p;
SELECT * FROM iwlinks
WHERE iwl_prefix = "en"
LIMIT 1,100; |
5 years ago |
USE enwiki_p;
SELECT * FROM iwlinks
WHERE iwl_prefix = "enwiki"
LIMIT 1,100; |
5 years ago |
USE enwiki_p;
SELECT * FROM iwlinks
WHERE iwl_prefix = "wikipedia"
LIMIT 1,100; |
5 years ago |
USE enwiki_p;
SELECT * FROM iwlinks
LIMIT 1,100; |
5 years ago |
USE enwiki_p;
SELECT il.*, p.page_title FROM imagelinks il
INNER JOIN page p... |
5 years ago |
USE enwiki_p;
SELECT * FROM imagelinks
WHERE il_from_namespace IN (8, 10,... |
5 years ago |