Commons talk:State Library of Queensland/Reports/8

Featured image

The Bradman image appears to be the one that has increased its usage the most over the last few months, however it is due to galleries like [1] rather than good article work. The nl.wp new article is nice.

I'm not 100% happy with this image being the primary image and story that readers see first. I'd like to find another interesting photo and story. John Vandenberg ^(chat) 10:45, 6 September 2011 (UTC)

category SQL

Red cats

select c2.cl_to category, count(*) count
from categorylinks c1, categorylinks c2
where c1.cl_to = 'Images_from_the_State_Library_of_Queensland'
and c1.cl_from = c2.cl_from
and c2.cl_to != 'Images_from_the_State_Library_of_Queensland'
and c2.cl_to not in
(select page_title from page where page_namespace=14)
GROUP BY c2.cl_to
ORDER BY 2 desc
LIMIT 100

New cats

select c2.cl_to category, min(r.rev_timestamp) created
from categorylinks c1, categorylinks c2, page p, revision r 
where c1.cl_to = 'Images_from_the_State_Library_of_Queensland'
and c1.cl_from = c2.cl_from
and c2.cl_to != 'Images_from_the_State_Library_of_Queensland'
and c2.cl_to = p.page_title and page_namespace=14
and p.page_id = r.rev_page
GROUP BY c2.cl_to, r.rev_page
ORDER BY 2 desc
LIMIT 100;

Most populated categories

select c2.cl_to category, count(*) count
from categorylinks c1, categorylinks c2 
where c1.cl_to = 'Images_from_the_State_Library_of_Queensland'
and c1.cl_from = c2.cl_from
and c2.cl_to != 'Images_from_the_State_Library_of_Queensland'
GROUP BY c2.cl_to
ORDER BY 2 desc
LIMIT 100;