Untitled query #61335

SQL

SET STATEMENT max_statement_time = 60 FOR
# Get categories listed on file pages
# SELECT pl.*
# FROM pagelinks as pl
# WHERE pl.pl_from_namespace = 6
# AND pl.pl_namespace = 14
# LIMIT 10

# Get all categories with paintings in title
# SELECT count(*)
# FROM page as p
# WHERE p.page_namespace = 14
#	AND lower(p.page_title) like "%painting%"
# LIMIT 10 #51583

# Get all file pages linked from categories with painting in title
SELECT count(*), count(distinct p.page_id)
FROM pagelinks pl
left join page as p on p.page_id = pl.pl_from
WHERE 
	p.page_namespace = 14
    AND pl.pl_from_namespace = 14
    AND pl.pl_namespace = 6
	AND lower(p.page_title) like "%painting%"
LIMIT 10 #51583
SQL

Checking query status...
