Untitled query #84260

SQL

select CONCAT('[[:Category:',cl2.cl_to,']]') as Category
, count(*) as Total_NonFree
, count(cl2.cl_from) as Total_Files
from categorylinks as cl2
left join categorylinks as cl1 on cl1.cl_from=cl2.cl_from and cl1.cl_to='All_non-free_media' and cl1.cl_type='file'
inner join page on page_title=cl2.cl_to
left join page_props on page_id=pp_page and pp_propname='nogallery'
where cl2.cl_type='file' and page_namespace=14 and pp_propname IS NULL
/*and cl2.cl_to like '%logo%' */
and cl2.cl_to >'H'
group by cl2.cl_to
having count(*)=1
ORDER BY 2 desc, 1
LIMIT 1000;
SQL

Checking query status...
