Untitled query #62468

SQL

#Select distinct concat("File:", page_title) as Dateiname
#From page left Join categorylinks b
#On page_id=b.cl_from
#LeFT join categorylinks c on
#b.cl_from=c.cl_from 
#Where page_id in
#	(Select page_id
#	FroM page
#     Where page_title like "%Seeadler%")
#group by c.cl_from
#having c.cl_to not like "Haliaeetus%";
Select distinct concat("File:", page_title) as Dateiname
From page left Join categorylinks
On page_id=cl_from
WHERE cl_from IN
(SELECT cl_from, count(cl_to)
FROM categorylinks
WHERE SUBSTRING(cl_to,1,10)="Haliaeetus"
 GROUP BY cl_from);
SQL

Checking query status...
