Portály mimo kategorie portálů

SQL

select page_title, cs_props.pp_value, other_props.pp_value
from (select page_title, page_id from cswiki_p.page where page_namespace like 10) as cs
left join (select pp_value, pp_page from cswiki_p.page_props where pp_propname like 'wikibase_item') as cs_props on cs.page_id = cs_props.pp_page
join ((select page_title, page_id from skwiki_p.page where page_namespace like 10) as other
left join (select pp_value, pp_page from skwiki_p.page_props where pp_propname like 'wikibase_item') as other_props on other.page_id = other_props.pp_page) using (page_title)
where cs_props.pp_value not like other_props.pp_value
limit 1;
SQL

Checking query status...
