Untitled query #58544

SQL

/*
SELECT page1.page_title, lt_title, lt_namespace FROM pagelinks JOIN linktarget ON pl_target_id=lt_id JOIN page AS page1 ON pl_from=page1.page_id JOIN categorylinks ON page1.page_id=cl_from LEFT OUTER JOIN page AS page2 ON lt_title=page2.page_title WHERE
*/
SELECT page1.page_title, COUNT(*) AS antal FROM pagelinks JOIN linktarget ON pl_target_id=lt_id JOIN page AS page1 ON pl_from=page1.page_id JOIN categorylinks ON page1.page_id=cl_from LEFT OUTER JOIN page AS page2 ON lt_title=page2.page_title WHERE
page1.page_title LIKE 'A%' OR page1.page_title LIKE 'B%'
AND lt_namespace = 0
AND cl_to = 'Efternamnsförgreningssidor'
AND page2.page_id IS NULL
GROUP BY page1.page_title
HAVING antal>9
ORDER BY antal DESC
SQL

Checking query status...
