| use commonswiki_p;
select SUBSTRING_INDEX(SUBSTRING_INDEX(page_title, '.',... |
2 months ago |
| use commonswiki_p;
#select SUBSTRING_INDEX(SUBSTRING_INDEX(page_title, '.',... |
2 months ago |
| use commonswiki_p;
#select SUBSTRING_INDEX(SUBSTRING_INDEX(page_title, '.',... |
2 months ago |
| use commonswiki_p;
select SUBSTRING_INDEX(SUBSTRING_INDEX(page_title, '.',... |
2 months ago |
| use commonswiki_p;
select SUBSTRING_INDEX(SUBSTRING_INDEX(page_title, '.',... |
2 months ago |
| use commonswiki_p;
select SUBSTRING_INDEX(SUBSTRING_INDEX(page_title, '.',... |
2 months ago |
| use commonswiki_p;
select SUBSTRING_INDEX(SUBSTRING_INDEX(page_title, '.',... |
2 months ago |
| use commonswiki_p;
select page_title,... |
2 months ago |
| use commonswiki_p;
select page_title,... |
2 months ago |
| use commonswiki_p;
select page_title,... |
2 months ago |
| use commonswiki_p;
select page_title, SUBSTRING_INDEX(page_title , '.', 3)... |
2 months ago |
| use commonswiki_p;
select SUBSTRING_INDEX(page_title , '.', 3) as lang,... |
2 months ago |
| use commonswiki_p;
select substring(page_title , instr(page_title, '.'),100)... |
2 months ago |
| use commonswiki_p;
select left(page_title , instr(page_title, '.')) as lang,... |
2 months ago |
| use commonswiki_p;
select left(page_title , CHARINDEX('.', page_title)) as... |
2 months ago |
| use commonswiki_p;
select substring(page_title , LEN(page_title) -... |
2 months ago |
| select substring(page_title , LEN(page_title) - CHARINDEX('.', page_title),... |
2 months ago |
| select parsename(page_title, 2) as lang, count(*) as num
from page
where... |
2 months ago |
| select sub, num, length(sub) as len from (
select RIGHT(page_title,... |
2 months ago |
