| SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id, wbxl_language, (SELECT... |
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', Lwbit.wbit_item_id) AS item_id,... |
4 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,... |
4 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,... |
4 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,... |
4 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,... |
4 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,... |
4 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,... |
4 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id,... |
4 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id), wbxl_language,... |
4 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id), wbxl_language,... |
4 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id), wbxl_language,... |
4 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id), wbxl_language#,... |
4 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id), wbxl_language#,... |
4 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id), wbxl_language,... |
4 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id), wbxl_language,... |
4 years ago |
| USE wikidatawiki_p;
SELECT CONCAT('Q', Lwbit.wbit_item_id), wbxl_language,... |
4 years ago |
| USE wikidatawiki_p;
/*
SELECT *
FROM wbt_item_terms AS Lwbit
JOIN... |
4 years ago |
| blank query |
4 years ago |
| SELECT term_entity_id, term_entity_type, term_language, term_text,... |
7 years ago |
| SELECT term_entity_id, term_entity_type, term_language, term_text,... |
7 years ago |
| SELECT term_entity_id, term_entity_type, term_language, term_text,... |
7 years ago |
| SELECT term_entity_id, term_entity_type, term_language, term_text,... |
8 years ago |
| SELECT term_entity_id, term_entity_type, term_language, term_text,... |
8 years ago |
| SELECT CONCAT("Q",term_entity_id), term_language, term_text, term_type
FROM... |
8 years ago |
| SELECT CONCAT("Q",term_entity_id), term_language, term_text, term_type
FROM... |
8 years ago |
| SELECT CONCAT("Q",term_entity_id), term_language, term_text, term_type
FROM... |
8 years ago |
| SELECT CONCAT("Q",term_entity_id), term_language, term_text, term_type
FROM... |
8 years ago |
| SELECT CONCAT("Q",term_entity_id), term_language, term_text, term_type
FROM... |
8 years ago |
| SELECT CONCAT("Q",term_entity_id), term_language, term_text
FROM... |
8 years ago |
| SELECT CONCAT("Q",term_entity_id), term_language, term_text
FROM... |
8 years ago |
| SELECT CONCAT("Q",term_entity_id), term_language, term_text
FROM... |
8 years ago |
| SELECT * FROM wikidatawiki_p.wb_terms
WHERE term_text RLIKE "^Q[1-9][0-9]{3,7}$" |
8 years ago |
| SELECT * FROM wikidatawiki_p.wb_terms
WHERE term_text RLIKE "^Q[1-9][0-9]+$" |
8 years ago |
| SELECT * FROM wikidatawiki_p.wb_terms
WHERE term_text RLIKE "^Q[1-9][0-9]+$" |
8 years ago |
| SELECT * FROM wikidatawiki_p.wb_terms WHERE term_text LIKE "Q[1-9][0-9][0-9]%" |
8 years ago |
