select count(distinct(ips_site_page))
from wikidatawiki_p.wb_items_per_site... |
3 years ago |
select count(distinct(ips_site_page))
from wikidatawiki_p.wb_items_per_site... |
3 years ago |
select distinct(ips_site_page)
from wikidatawiki_p.wb_items_per_site
left... |
3 years ago |
select distinct(ips_site_page), distinct(gil_page_title)
from... |
3 years ago |
select distinct(ips_site_page)
from wikidatawiki_p.wb_items_per_site
left... |
3 years ago |
select distinct(ips_site_page), distinct(gil_page_title)
from... |
3 years ago |
select *
from wikidatawiki_p.wb_items_per_site
where ips_site_id = 'enwiki'... |
3 years ago |
select *
from commonswiki_p.globalimagelinks
where gil_page_namespace_id = 0... |
3 years ago |
select *
from wikidatawiki_p.wb_items_per_site
where ips_site_id = 'enwiki'... |
3 years ago |
select cast(substring(gil_page_title, 2) as int)
from... |
3 years ago |
select CAST(substring(gil_page_title, 2) AS INT)
from... |
3 years ago |
select substring(gil_page_title, 2)
from... |
3 years ago |
select substring(gil_page_title, 2)
from... |
3 years ago |
select substring(gil_page_title, 2) as qid
from... |
3 years ago |
select substring(gil_page_title, 2) as q_id
from... |
3 years ago |
select cast(substring(gil_page_title, 2) as int) as q_id
from... |
3 years ago |
select cast(substring(gil_page_title, 2) as int) as qid from... |
3 years ago |
select cast(substring(gil_page_title, 2) as int) from... |
3 years ago |
select substring(gil_page_title, 2) from... |
3 years ago |
use commonswiki_p;
select substring(gil_page_title, 2) from... |
3 years ago |
use commonswiki_p;
select substring(gil_page_title, 1) from... |
3 years ago |
use commonswiki_p;
select CONVERT(VARCHAR(100), gil_page_title, 1) from... |
3 years ago |
use commonswiki_p;
select CONVERT(VARCHAR(100), gil_page_title, 1); from... |
3 years ago |
use commonswiki_p;
select * from globalimagelinks
where... |
3 years ago |