ro unused images

SQL

use rowiki_p;
select count(img_name) from image LEFT OUTER JOIN imagelinks on il_to = img_name where il_to is null;
/*
select page_title from page where
not exists(Select * from imagelinks where il_from = page_id)
and not exists ( select * from templatelinks where tl_from = page_id 
                 and  tl_namespace = 10 and tl_title in ( 'Copertă_album', 'Album-copertă' ) ) 
and is ( select * from categorylinks where cl_from = page_id and cl_to in ( "Copertă_album" ) ) 
and page_namespace = 6
and page_is_redirect = 0
*/
SQL

Checking query status...
