Hledání v seznamech stránek

Fork of Categories which contains only one page in cswiki by Martin Urbanec

This query is marked as a draft This query has been published by Dvorapa.

SQL

use skwiki_p;
select page_title, page_namespace, cs_props.pp_value as cs_value, other_props.pp_value as other_value from cswiki_p.page as cs
join page as other using (page_title, page_namespace)
left join cswiki_p.page_props as cs_props on cs.page_id = cs_props.pp_page
left join page_props as other_props on other.page_id = other_props.pp_page
where page_namespace in (10, 828)
and cs_props.pp_propname like 'wikibase_item'
and other_props.pp_propname like 'wikibase_item'
#and cs_props.pp_value not like other_props.pp_value
;

SQL

Checking query status...