| use wikidatawiki_p;
SELECT ips_item_id, ips_site_id, site_language,... |
9 years ago |
| USE fawiki_p;
SELECT page_namespace, page_title, pp_value AS item
FROM... |
9 years ago |
| USE wikidatawiki_p;
SELECT page_title FROM page join wb_items_per_site,... |
9 years ago |
| USE wikidatawiki_p;
SELECT page_title FROM page join wb_items_per_site,... |
9 years ago |
| USE wikidatawiki_p;
SELECT page_title FROM page join wb_items_per_site,... |
9 years ago |
| USE wikidatawiki_p;
SELECT page_title FROM page join wb_items_per_site,... |
9 years ago |
| USE wikidatawiki_p;
SELECT page_title FROM page where
page_id not in... |
9 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',ips_item_id)
from... |
9 years ago |
| USE wikidatawiki_p;
SELECT page_title FROM page where
page_id not in... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM pagelinks WHERE pl_title = 'Q4167410' AND... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM pagelinks WHERE pl_namespace is NUll limit 10; |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM pagelinks WHERE pl_from_namespace is NUll... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM pagelinks WHERE pl_from is NUll limit 10; |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM pagelinks WHERE pl_from is NUll AND... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM pagelinks WHERE pl_from is NUll and... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM pagelinks WHERE pl_from_namespace = 0 AND... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM pagelinks WHERE pl_title IS NULL AND... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM pagelinks WHERE pl_from_namespace = 0 AND... |
9 years ago |
| USE wikidatawiki_p;
SELECT pl_from FROM pagelinks WHERE pl_from_namespace =... |
9 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',ips_item_id)
from... |
9 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',ips_item_id)
from... |
9 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',ips_item_id)
from... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM pagelinks WHERE pl_from_namespace = 0 AND... |
9 years ago |
| USE wikidatawiki_p;
SELECT pl_from FROM pagelinks WHERE pl_from_namespace =... |
9 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q',ips_item_id)
from... |
9 years ago |
| USE wikidatawiki_p;
SELECT ips_item_id, site_language
from... |
9 years ago |
| USE wikidatawiki_p;
SELECT ips_item_id, site_language
from... |
9 years ago |
| USE wikidatawiki_p;
SELECT ips_item_id, site_language
from... |
9 years ago |
| USE wikidatawiki_p;
SELECT ips_item_id, site_language
from... |
9 years ago |
| USE wikidatawiki_p;
SELECT ips_item_id, site_language
from... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM pagelinks WHERE pl_from_namespace = 0 AND... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM pagelinks WHERE pl_title = 'Q4167410' AND... |
9 years ago |
| USE fawiki_p;
SELECT page_namespace, page_title, pp_value AS item
FROM... |
9 years ago |
| USE fawiki_p;
SELECT page_namespace, page_title, pp_value AS item
FROM... |
9 years ago |
| use wikidatawiki_p;
SHOW TABLES; |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) As item, term_text,... |
9 years ago |
| use wikidatawiki_p;
SELECT CONCAT('Q', term_entity_id) As item, term_text,... |
9 years ago |
