User:Kotepho/reports/Media used in namespaces other than 0 that contain a template on the image description page that is in category:Non-free image copyright tags

Generated with: select tl.tl_title, il.il_to, count(il_page.page_id) INTO OUTFILE '/tmp/non-free_images.txt' from categorylinks as cl INNER JOIN page as cl_page ON cl.cl_from = cl_page.page_id INNER JOIN templatelinks as tl ON cl_page.page_title = tl.tl_title AND cl_page.page_namespace = tl.tl_namespace INNER JOIN page as tl_page ON tl.tl_from = tl_page.page_id INNER JOIN imagelinks as il ON tl_page.page_title = il.il_to INNER JOIN page as il_page ON il.il_from = il_page.page_id WHERE cl.cl_to = 'Non-free_image_copyright_tags' AND il_page.page_namespace <> 0 AND tl_page.page_namespace = 6 GROUP BY il.il_to ORDER BY tl.tl_title; and a little bit of perl to split into pages/tables.
 * 1) !/usr/bin/perl

@lines = <>; print "Template:$1\n\n" if $lines[0] =~ m/([^	]+)	([^	]+)	(\d+)/; print "{| class=\"wikitable\"\ ! Image !! Count\ ";

foreach (@lines) {	s/([^	]+)	([^	]+)	(\d+)/|- | Image:$2 || $3 /;	print; } print "|}\n";


 * /ABr
 * /Albumcover