| use wikidatawiki_p;
select ips_item_id, nn as n_of_interwikis, en_title,... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn as n_of_interwikis, en_title,... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, en_title, page_id,... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, en_title, cs_title
from... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, en_title, cs_title
from... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, length(cs_title) as lth, nn,... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, en_title, cs_title
from... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, en_title, cs_title
from... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, en_title
from
(select... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, en_title
from
(select... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, en_title
from
select... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, en_title
from
select... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, en_title
from
(
select... |
7 years ago |
| use wikidatawiki_p;
select grp.ips_item_id, grp.nn, eng.en_title
from
(
... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, en_title, ips_site_page
from... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, en_title, ips_site_page
from... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, en_title
from (select... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, en_title
from (
select... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, en_title
from (
select... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, ips_site_page
from (
select... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, nn, ips_site_page
from (
select... |
7 years ago |
| use wikidatawiki_p;
select i.ips_item_id, i.nn, k.ips_site_page
from (
... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, count(*) as nn
from... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, count(*) as nn
from... |
7 years ago |
| use wikidatawiki_p;
select ips_item_id, count(*) as nn
from... |
7 years ago |
| use wikidatawiki_p;
select ips_item, count(*) as nn
from... |
7 years ago |
| use wikidatawiki_p;
select *
from wb_items_per_site
where ips_site_page in... |
7 years ago |
| use wikidatawiki_p;
select pi_type, count(*)
from wb_property_info
group by... |
7 years ago |
| use wikidatawiki_p;
select pl_type, count(*)
from wb_property_info
group by... |
7 years ago |
| use wikidatawiki_p;
select *
from wb_property_info
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from wb_items_per_site
where ips_site_id =... |
7 years ago |
| use wikidatawiki_p;
select *
from wb_items_per_site
where ips_site_id =... |
7 years ago |
| use wikidatawiki_p;
select *
from wb_items_per_site
where ips_site_id =... |
7 years ago |
| use wikidatawiki_p;
select *
from wb_items_per_site
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from wb_id_counters
limit 100; |
7 years ago |
| use wikidatawiki_p;
select epp_entity_type, count(*) as cnt,... |
7 years ago |
| use wikidatawiki_p;
select *
from wb_entity_per_page
limit 100; |
7 years ago |
| use wikidatawiki_p;
select page_id, page_title, pp_value
from page left... |
7 years ago |
| use wikidatawiki_p;
select page_id, page_title, pp_value
from page left... |
7 years ago |
| use wikidatawiki_p;
select *
from page_props
where pp_page = 81026 or... |
7 years ago |
| use wikidatawiki_p;
select *
from page_props
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from l10n_cache
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from externallinks
where el_to =... |
7 years ago |
| use wikidatawiki_p;
select *
from externallinks
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from categorylinks
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from category
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from archive
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from iwlinks
where iwl_prefix = 'cs' and not... |
7 years ago |
| use wikidatawiki_p;
select *
from iwlinks
where iwl_prefix = 'cs' and not... |
7 years ago |
| use wikidatawiki_p;
select *
from iwlinks
where iwl_prefix = 'cs'
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from iwlinks
where iwl_title = 'Jakub Deml'
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from iwlinks
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from langlinks
where ll_lang = 'cs' and... |
7 years ago |
| use wikidatawiki_p;
select *
from langlinks
where ll_lang = 'cs' and... |
7 years ago |
| use wikidatawiki_p;
select *
from langlinks
where ll_lang = 'cs'
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from langlinks
where ll_title = 'Jakub Deml'... |
7 years ago |
| use wikidatawiki_p;
select *
from langlinks
where ll_title like 'Deml'
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from langlinks
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from pagelinks
where pl_namespace = 0 and... |
7 years ago |
| use wikidatawiki_p;
select *
from pagelinks
where pl_namespace = 0
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from interwiki
limit 100; |
7 years ago |
| use wikidatawiki_p;
select *
from interwiki
where iw_wikiid = 81026 or... |
7 years ago |
| use wikidatawiki_p;
select *
from langlinks
where ll_from = 81026 or... |
7 years ago |
| use wikidatawiki_p;
select *
from iwlinks
where iwl_from = 81026 or... |
7 years ago |
| use wikidatawiki_p;
select *
from page
where page_title = 'Q78476' or... |
7 years ago |
| use wikidatawiki_p;
select iwl_from, count(*) as cnt
from iwlinks
group by... |
7 years ago |
| use wikidatawiki_p;
select iwl_from, count(*)
from iwlinks
group by... |
7 years ago |
| use wikidatawiki_p;
select * from iwlinks
limit 300; |
7 years ago |
| use wikidatawiki_p;
select * from page
limit 300; |
7 years ago |
| use wikidatawiki_p;
select * from langlinks i
where ll_lang = 'cs'
limit 300; |
7 years ago |
| use wikidatawiki_p;
select * from langlinks i
limit 300; |
7 years ago |
| use wikidatawiki_p;
select * from iwlinks i
where iwl_prefix = 'cs'
limit 300; |
7 years ago |
| use wikidatawiki_p;
select * from iwlinks i
limit 300; |
7 years ago |
| use wikidatawiki_p;
select * from interwiki i
limit 300; |
7 years ago |
| use wikidatawiki_p;
select * from langlinks i
where ll_lang = 'cs'
limit 300; |
7 years ago |
| use wikidatawiki_p; select * from langlinks i limit 100; |
7 years ago |
| use wikidatawiki_p; select *from langlinks ilimit 100; |
7 years ago |
| select 1; |
7 years ago |
| use wikidatawiki_p;
select *
from langlinks i
limit 100; |
7 years ago |
