| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
3 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
4 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
4 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
4 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
4 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
4 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
4 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
4 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
5 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
5 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
5 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
6 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
6 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
6 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
6 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
6 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
6 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
6 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
6 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
6 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
6 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
6 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
6 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
6 years ago |
| -- https://www.mediawiki.org/wiki/Manual:Database_layout
-- note: the page... |
6 years ago |
| USE wikidatawiki_p;
-- the page table does not contain Q-IDs that have been... |
6 years ago |
| USE wikidatawiki_p;
-- SELECT CEILING(SUBSTRING(page_title FROM 2) / 100000)... |
6 years ago |
| USE wikidatawiki_p;
-- SELECT CEILING(SUBSTRING(page_title FROM 2) / 100000)... |
6 years ago |
| USE wikidatawiki_p;
-- SELECT CEILING(SUBSTRING(page_title FROM 2) / 100000)... |
6 years ago |
| USE wikidatawiki_p;
-- SELECT CEILING(SUBSTRING(page_title FROM 2) / 100000)... |
6 years ago |
| USE wikidatawiki_p;
-- SELECT CEILING(SUBSTRING(page_title FROM 2) / 100000)... |
6 years ago |
| USE wikidatawiki_p;
-- SELECT CEILING(SUBSTRING(page_title FROM 2) / 100000)... |
6 years ago |
| USE wikidatawiki_p;
SELECT CEILING(SUBSTRING(page_title FROM 2) / 100000) AS... |
6 years ago |
| USE wikidatawiki_p;
SELECT CEILING(SUBSTRING(page_title FROM 2) / 100000) AS... |
6 years ago |
| USE wikidatawiki_p;
SELECT CEILING(SUBSTRING(page_title FROM 2) / 100000) AS... |
6 years ago |
| USE wikidatawiki_p;
#SELECT CEILING(SUBSTRING(page_title FROM 2) / 100000)... |
6 years ago |
| USE wikidatawiki_p;
#SELECT CEILING(SUBSTRING(page_title FROM 2) / 100000)... |
6 years ago |
| USE wikidatawiki_p;
SELECT CEILING(SUBSTRING(page_title FROM 2) / 100000)... |
6 years ago |
| USE wikidatawiki_p;
SELECT CEILING(SUBSTRING(page_title FROM 2) / 100000)... |
6 years ago |
| USE wikidatawiki_p;
SELECT CEILING(SUBSTRING(page_title FROM 2)/100000) AS... |
6 years ago |
| USE wikidatawiki_p;
SELECT CEILING(SUBSTRING(page_title FROM 2)/100000) AS... |
6 years ago |
| USE wikidatawiki_p;
SELECT CEILING(SUBSTRING(page_title FROM 2)/100000) AS... |
6 years ago |
| USE wikidatawiki_p;
SELECT page_title, SUBSTRING(page_title FROM 2) AS... |
6 years ago |
| USE wikidatawiki_p;
SELECT page_title, SUBSTRING(page_title FROM 1) AS... |
6 years ago |
| USE wikidatawiki_p;
SELECT page_title, SUBSTRING(page_title, 1) AS page_num... |
6 years ago |
| USE wikidatawiki_p;
SELECT page_title FROM page WHERE page_namespace=0 LIMIT 100; |
6 years ago |
