| USE wikidatawiki_p;
SELECT term_entity_type, term_entity_id FROM... |
8 years ago |
| USE wikidatawiki_p;
SELECT COUNT(*) FROM wb_terms WHERE term_type =... |
8 years ago |
| USE wikidatawiki_p;
SELECT COUNT(*) FROM wb_terms WHERE term_type =... |
9 years ago |
| USE wikidatawiki_p;
SELECT COUNT(*) FROM wb_terms WHERE term_type =... |
9 years ago |
| USE wikidatawiki_p;
SELECT COUNT(*) FROM wb_terms WHERE term_type =... |
9 years ago |
| USE wikidatawiki_p;
SELECT COUNT(*) FROM wb_terms WHERE term_type =... |
9 years ago |
| USE wikidatawiki_p;
SELECT COUNT(*) FROM wb_terms WHERE term_type =... |
9 years ago |
| USE wikidatawiki_p;
SELECT CONCAT("Q", term_entity_id) FROM wb_terms
WHERE... |
9 years ago |
| USE wikidatawiki_p;
SELECT rev_user_text, COUNT(*) FROM revision
WHERE... |
9 years ago |
| USE wikidatawiki_p;
SELECT rev_user_text, COUNT(*) FROM revision WHERE... |
9 years ago |
| USE wikidatawiki_p;
SELECT rev_user_text, COUNT(*) FROM revision WHERE... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM revision WHERE rev_comment LIKE "/*... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM revision WHERE rev_comment LIKE "/*... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM revision WHERE rev_comment LIKE "/*... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM revision WHERE rev_comment LIKE... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM revision ORDER BY rev_id DESC LIMIT... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM revision ORDER BY rev_id DESC LIMIT... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM revision ORDER BY rev_id DESC LIMIT... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM revision LIMIT 25;#WHERE rev_comment LIKE... |
9 years ago |
| USE wikidatawiki_p;
SELECT CONCAT("Q", epp_entity_id), term_language,... |
9 years ago |
| USE wikidatawiki_p;
SELECT CONCAT("Q", epp_entity_id), term_language,... |
9 years ago |
| USE wikidatawiki_p;
SELECT *
FROM wb_terms
JOIN wb_entity_per_page ON... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM revision WHERE rev_comment LIKE "%human%"... |
9 years ago |
| USE specieswiki_p;
SHOW TABLES; |
9 years ago |
| SHOW DATABASES; |
9 years ago |
| /*USE enwiki_p;
SELECT * FROM wikidatawiki_p.page AS wd
JOIN page AS enwp
... |
9 years ago |
| USE enwiki_p;
SELECT * FROM wikidatawiki_p.page AS wd
JOIN page AS enwp
... |
9 years ago |
| USE enwiki_p;
SELECT * FROM wikidatawiki_p.page AS wd, page AS enwp
WHERE... |
9 years ago |
| USE enwiki_p;
SELECT *
FROM wikidatawiki_p.page AS wd, page AS enwp
WHERE... |
9 years ago |
| USE enwiki_p;
SELECT *
FROM wikidatawiki_p.page AS wd
JOIN page AS... |
9 years ago |
| USE enwiki_p;
SELECT *
FROM wikidatatawiki_p.page AS wd
JOIN page AS... |
9 years ago |
