Untitled query #6216

SQL

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


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 c2.cl_to = "Muži" AND t2.tl_title NOT LIKE "%Infobox%" AND t2.tl_title != 'Infobox_-_osoba'
group by p2.page_id
LImIT 100



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

Checking query status...
