SELECT
	wbx_text AS painter,
	COUNT(wbx_text) AS paintercount
FROM page
JOIN pagelinks AS colllink ON page_id=colllink.pl_from AND
	colllink.pl_from_namespace=0 AND
	colllink.pl_namespace=0 AND
	colllink.pl_title='Q18600731'
LEFT JOIN pagelinks AS creatorlink ON page_id=creatorlink.pl_from AND
	creatorlink.pl_from_namespace=0 AND
	creatorlink.pl_namespace=120 AND
	creatorlink.pl_title='P170'
INNER JOIN wbt_item_terms ON page_title=CONCAT('Q', wbit_item_id)
INNER JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id
INNER JOIN wbt_type ON wbtl_type_id = wby_id
INNER JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
INNER JOIN wbt_text ON wbxl_text_id = wbx_id
WHERE
	wbxl_language='en' AND
	wby_name='description' AND
	wbx_text LIKE 'painting by %' AND
	page_namespace=0 AND
	page_is_redirect=0 AND
	creatorlink.pl_from IS NULL
GROUP BY wbx_text
ORDER BY COUNT(wbx_text) DESC, painter
LIMIT 300;