Untitled query #53461

SQL

use hrwiki_p;

select distinct page_title, pl_title
from page
inner join pagelinks on pl_from = page_id
where pl_namespace = 0 and pl_title in (
select page_title
from page
inner join categorylinks on cl_from = page_id and cl_to = 'Registracijske_oznake_za_cestovna_vozila'
where page_namespace=0
) and page_id not in
(
select page_id
from page
inner join categorylinks on cl_from = page_id and cl_to = 'Registracijske_oznake_za_cestovna_vozila'
where page_namespace=0
)
order by page_title, pl_title
SQL

Checking query status...
