(empty) - Quarry

SQL

use nlwiki_p;

SELECT *, catlink.cl_from#, catlink.cl_to
FROM 
(SELECT page.page_is_redirect, page.page_title
FROM page
WHERE page.page_title = 'Accordina'
AND page.page_namespace = 0
AND page.page_is_redirect = 0
) as subQueryPages
LEFT OUTER JOIN categorylinks catlink ON catlink.cl_from = subQueryPages.page_id
LEFT OUTER JOIN category cat ON cat.cat_id = catlink.cl_from
WHERE
catlink.cl_from IS NULL OR catlink.cl_from IN (SELECT cat_id FROM category WHERE cat_title LIKE 'Wikipedia:%')
LIMIT 100
SQL

Checking query status...
