| SHOW TABLE page; |
2 years ago |
| DESCRIBE page; |
2 years ago |
| SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,
wbxl_language,
... |
2 years ago |
| SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,
wbxl_language,
... |
2 years ago |
| SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,
wbxl_language,
... |
2 years ago |
| SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,
wbxl_language,
... |
2 years ago |
| SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,
wbxl_language,
... |
2 years ago |
| SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,
wbxl_language,
... |
2 years ago |
| SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,
wbxl_language,
... |
2 years ago |
| SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,
wbxl_language,
... |
2 years ago |
| SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,
wbxl_language,
... |
2 years ago |
| SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,
wbxl_language,
... |
2 years ago |
| SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,
wbxl_language,
... |
2 years ago |
| SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,
wbxl_language,
... |
2 years ago |
| SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id, wbxl_language, (SELECT... |
2 years ago |
| USE wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id), "Lbn",... |
2 years ago |
|
SELECT * FROM wbt_item_terms
INNER JOIN wbt_term_in_lang
ON wbtl_id... |
2 years ago |
|
SELECT wbit_item_id FROM wbt_item_terms
INNER JOIN wbt_term_in_lang
... |
2 years ago |
| USE wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id), "Lbn",... |
2 years ago |
| USE wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id), "Lbn",... |
2 years ago |
| SELECT wbit_item_id FROM wbt_item_terms
INNER JOIN wbt_term_in_lang
... |
2 years ago |
| SELECT * FROM wbt_item_terms LIMIT 1 |
2 years ago |
| SELECT * FROM wbt_text_in_lang LIMIT 1 |
2 years ago |
| SELECT * FROM wbt_term_in_lang LIMIT 1 |
2 years ago |
| SELECT * FROM wbit_term_in_lang_id LIMIT 1 |
2 years ago |
| SHOW TABLES; |
2 years ago |
| SELECT *
FROM page
WHERE page_title REGEXP '__'
|
2 years ago |
| SELECT *
FROM page
WHERE page_title REGEXP '__'
LIMIT 1 |
2 years ago |
| SELECT ips_site_page
FROM wb_items_per_site
WHERE ips_site_id = 'enwiki'
... |
2 years ago |
| SELECT ips_site_page FROM wb_items_per_site WHERE ips_site_id = 'eswiki' AND... |
2 years ago |
| SELECT ips_site_page FROM wb_items_per_site WHERE ips_site_id = 'eswiki' AND... |
2 years ago |
| SELECT * FROM wb_items_per_site LIMIT 1
|
2 years ago |
| DESCRIBE wb_items_per_site |
2 years ago |
| DESCRIBE wb_items_per_site |
2 years ago |
| SHOW TABLES FROM eswiki_p |
2 years ago |
| SHOW TABLES FROM eswiki_p |
2 years ago |
| SHOW TABLES FROM enwiki_p
|
2 years ago |
| SHOW TABLES FROM enwiki_p
|
2 years ago |
| SHOW TABLES FROM quwiki_p
|
2 years ago |
| DESCRIBE quwiki_p.actor;
|
2 years ago |
| DESCRIBE quwiki_p.actor;
|
2 years ago |
| DESCRIBE actor;
|
2 years ago |
| DESCRIBE enwiki_p.actor;
|
2 years ago |
| DESCRIBE enwiki_p.actor;
|
2 years ago |
| select page_title from page limit 10 |
2 years ago |
| select page_title from page limit 10 |
2 years ago |
| select page_title from page limit 10 |
2 years ago |
| select page_title from page limit 10 |
2 years ago |
| select page_title from page limit 1 |
2 years ago |
| select page_title from page where page_id = 23841196
and page_namespace = 0; |
2 years ago |
