Untitled query #39731

SQL

USE wikidatawiki_p;
SELECT term_entity_id, term_text AS writer, COUNT(term_text) AS writercount 
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='Q5'
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='P50'
JOIN wb_terms ON page_title=term_full_entity_id AND
term_entity_type='item' AND
term_language='en' AND
term_type='description' /*AND term_text LIKE 'writing by %'*/
WHERE
term_text="Douglas Adams" AND 
page_namespace=0 AND
page_is_redirect=0 AND
creatorlink.pl_from IS NULL
GROUP BY term_text
ORDER BY COUNT(term_text) DESC, writer
LIMIT 300;
SQL

Checking query status...
