| USE trwiki_p;
select concat("[[",page_title,"|",replace(page_title,"_","... |
7 years ago |
| USE trwiki_p;
select concat("[[",page_title,"|",replace(page_title,"_","... |
7 years ago |
| USE trwiki_p;
select concat("[[",page_title,"|",replace(page_title,"_","... |
7 years ago |
| USE trwiki_p;
select concat("[[",page_title,"|",replace(page_title,"_","... |
7 years ago |
| USE trwiki_p;
select concat("[[",page_title,"|",replace(page_title,"_","... |
7 years ago |
| USE trwiki_p;
select concat("[[",page_title,"|",replace(page_title,"_","... |
7 years ago |
| USE trwiki_p;
select concat("[[",page_title,"|",replace(page_title,"_","... |
7 years ago |
| USE trwiki_p;
select concat("[[",page_title,"|",replace(page_title,"_","... |
7 years ago |
| USE trwiki_p;
select page_id as id,... |
7 years ago |
| USE trwiki_p;
select page_id as id, concat("[[",page_title,"]]") as ad,... |
7 years ago |
| USE trwiki_p;
select page_id, page_title,... |
7 years ago |
| USE trwiki_p;
select * from templatelinks
join page on page_id =... |
7 years ago |
| USE trwiki_p;
select pp_page as id
from page_props
where pp_propname... |
7 years ago |
| USE trwiki_p;
select *
from page_props
join page on page_id = pp_page
where... |
7 years ago |
| select convert(MID(wp.page_title,2), INTEGER)
from wikidatawiki_p.page wp... |
7 years ago |
| select convert(INTEGER,MID(wp.page_title,2))
from wikidatawiki_p.page wp... |
7 years ago |
| select convert(INTEGER,MID(wp.page_title,2))
from wikidatawiki_p.page wp... |
7 years ago |
| select convert(INTEGER,MID(wp.page_title,2))+0
from wikidatawiki_p.page wp... |
7 years ago |
| select MID(wp.page_title,2), (MID(wp.page_title,2)+0) as aa,... |
7 years ago |
| select MID(wp.page_title,2), MID(wp.page_title,2)+0,... |
7 years ago |
| select MID(wp.page_title,2)
from wikidatawiki_p.page wp where
page_title =... |
7 years ago |
| select MID(wp.page_title,2)
from wikidatawiki_p.page wp where
page_title =... |
7 years ago |
| select *
from wikidatawiki_p.page wp where
MID(wp.page_title,2) =... |
7 years ago |
| select ips.ips_item_id from wikidatawiki_p.wb_items_per_site ips
where... |
7 years ago |
| select ips.ips_item_id from wikidatawiki_p.wb_items_per_site ips
where... |
7 years ago |
