Untitled query #6216

SQL

select p2.page_id,p2.page_title from cswiki_p.categorylinks AS c2 
INNER JOIN cswiki_p.page AS p2 ON p2.page_id = c2.cl_from 
INNER JOIN cswiki_p.templatelinks AS t2 ON t2.tl_from = p2.page_id

WHERE page_id NOT IN (
select p.page_id from cswiki_p.categorylinks AS c 
INNER JOIN cswiki_p.page AS p ON p.page_id = c.cl_from
INNER JOIN cswiki_p.templatelinks AS t ON t.tl_from = p.page_id

WHERE c.cl_to = "Muži" AND t.tl_title = "Infobox_-_osoba" AND t.tl_title NOT LIKE "%Infobox%") 
AND c2.cl_to = "Muži" 

LImIT 100



#select * from cswiki_p.pagelinks limit 10;
#show tables from cswiki_p;
SQL

Checking query status...
