| use enwiki_p;
SELECT p.page_title, pp_value, GROUP_CONCAT(cl.cl_to SEPARATOR... |
8 years ago |
| use enwiki_p;
SELECT p.page_title, pp_value, cl.cl_to
FROM page p,... |
8 years ago |
| use enwiki_p;
SELECT p.page_title, pp_value, cl.cl_to
FROM page p,... |
8 years ago |
| use enwiki_p;
SELECT p.page_title, cl.cl_to, cl.cl_to
FROM page p,... |
8 years ago |
| use enwiki_p;
SELECT p.page_title, cl.cl_to, cl.cl_to
FROM page p,... |
8 years ago |
| use enwiki_p;
SELECT p.page_title, cl.cl_to, cl.cl_to
FROM page p,... |
8 years ago |
| use enwiki_p;
SELECT p.page_title, cl.cl_to, cl.cl_to
FROM page p,... |
8 years ago |
| use enwiki_p;
SELECT p.page_title, cl.cl_to, cl.cl_to
FROM page p,... |
8 years ago |
| use wikidatawiki_p;
select el_to, GROUP_CONCAT(p.page_title SEPARATOR ',... |
8 years ago |
| use wikidatawiki_p;
select el_to, GROUP_CONCAT(p.page_title SEPARATOR ',... |
8 years ago |
| use wikidatawiki_p;
select el_to, GROUP_CONCAT(p.page_title SEPARATOR ',... |
8 years ago |
| use wikidatawiki_p;
select el_to, GROUP_CONCAT(el_from SEPARATOR ',... |
8 years ago |
| select el_to, GROUP_CONCAT(el_from SEPARATOR ', ')
from... |
8 years ago |
| select *
from wikidatawiki_p.externallinks... |
8 years ago |
| select wd2.el_index
from wikidatawiki_p.externallinks... |
8 years ago |
| use wikidatawiki_p;
select i.ips_site_page
from wb_items_per_site i
where... |
8 years ago |
| use wikidatawiki_p;
select i.ips_site_page
from wb_items_per_site i
where... |
8 years ago |
| use wikidatawiki_p;
select i.ips_site_page
from wb_items_per_site i
where... |
8 years ago |
| use wikidatawiki_p;
select count(*)#(select i2.ips_item_id from... |
8 years ago |
| use wikidatawiki_p;
select *#(select i2.ips_item_id from wb_items_per_site... |
8 years ago |
| use wikidatawiki_p;
select *#(select i2.ips_item_id from wb_items_per_site... |
8 years ago |
| /*use wikidatawiki_p;
select *#(select i2.ips_item_id from wb_items_per_site... |
8 years ago |
| use wikidatawiki_p;
select *#(select i2.ips_item_id from wb_items_per_site... |
8 years ago |
| use wikidatawiki_p;
select (select i2.ips_item_id from wb_items_per_site i2... |
8 years ago |
| use wikidatawiki_p;
select *
from wb_items_per_site i
where i.ips_item_id... |
8 years ago |
| use wikidatawiki_p;
select *
from wb_items_per_site i
where i.ips_item_id... |
8 years ago |
| use wikidatawiki_p;
select *
from wb_items_per_site i
where ips_item_id in... |
8 years ago |
| use wikidatawiki_p;
select *
from wb_items_per_site i
where ips_item_id... |
8 years ago |
| use wikidatawiki_p;
select *
from wb_items_per_site i
where... |
8 years ago |
| use wikidatawiki_p;
select *
from wb_items_per_site i
where... |
8 years ago |
| use wikidatawiki_p;
select *
from wb_items_per_site i
where... |
8 years ago |
| use wikidatawiki_p;
select *
from wb_items_per_site i
#join wb_terms on... |
8 years ago |
| USE lvwiki_p;
SELECT *
from wbc_entity_usage wb
#GROUP BY eu_page_id
#join... |
8 years ago |
| USE lvwiki_p;
SELECT *
from langlinks ll
group by ll_lang
#join page p on... |
8 years ago |
| USE lvwiki_p;
SELECT *
from langlinks ll
#join page p on p.page_namespace=0... |
8 years ago |
| USE lvwiki_p;
SELECT *
from iwlinks iw
join page p on p.page_namespace=0 and... |
8 years ago |
| USE lvwiki_p;
SELECT *
from iwlinks iw
where iwl_prefix="commons" and... |
8 years ago |
| USE lvwiki_p;
SELECT *
from iwlinks iw
where iwl_prefix="commons"
limit 500; |
8 years ago |
| USE lvwiki_p;
SELECT *
from iwlinks iw
group by iwl_prefix
limit 500; |
8 years ago |
| USE lvwiki_p;
SELECT *
from iwlinks iw
limit 100; |
8 years ago |
| USE lvwiki_p;
SELECT REPLACE(p.page_title, '_', ' '), iw.iwl_title
from ... |
8 years ago |
| USE lvwiki_p;
SELECT p.page_title, iw.iwl_title
from iwlinks iw
join... |
8 years ago |
| USE lvwiki_p;
SELECT *
from iwlinks iw
join wbc_entity_usage wb on... |
8 years ago |
| USE lvwiki_p;
SELECT *
from iwlinks
where iwl_from=58532# and... |
8 years ago |
| USE lvwiki_p;
SELECT *
from iwlinks
where iwl_from=58532# and... |
8 years ago |
| USE lvwiki_p;
SELECT *
from iwlinks
where iwl_from=58532# and... |
8 years ago |
| USE lvwiki_p;
SELECT *
from iwlinks
where iwl_from=58532# and... |
8 years ago |
| USE lvwiki_p;
/*SELECT *
from iwlinks
where iwl_from=58532# and... |
8 years ago |
| USE lvwiki_p;
SELECT *
from iwlinks
# join page p2 on... |
8 years ago |
| USE lvwiki_p;
SELECT *
from iwlinks
# join page p2 on... |
8 years ago |
| USE lvwiki_p;
SELECT *
from pagelinks pl
# join page p2 on... |
8 years ago |
| USE lvwiki_p;
SELECT *
from pagelinks pl
# join page p2 on... |
8 years ago |
| USE lvwiki_p;
SELECT #DISTINCT
concat("* [[:Attēls:",REPLACE(p.page_title,... |
8 years ago |
| USE lvwiki_p;
SELECT *#DISTINCT concat("* [[:Attēls:",REPLACE(page_title,... |
8 years ago |
| SELECT DISTINCT pp_propname FROM page_props; |
8 years ago |
| select pla.page_title, cla.cl_to#, GROUP_CONCAT(cla.cl_to SEPARATOR ', ')
... |
8 years ago |
| select pla.page_title, cla.cl_to#, GROUP_CONCAT(cla.cl_to SEPARATOR ', ')
... |
8 years ago |
| select pla.page_title, GROUP_CONCAT(cla.cl_to SEPARATOR ', ')
... |
8 years ago |
| select pla.page_title, GROUP_CONCAT(cla.cl_to SEPARATOR ', ')
... |
8 years ago |
