Untitled query #8418

SQL

SELECT CONCAT("* [[", REPLACE(page_title, "_", " "), 
              "]] [http://dispenser.homenet.org/~dispenser/cgi-bin/dablinks.py?lang=nl&limit=50&namespaces=0&ref=", page_title, " "
              , a.blc_count + SUM(IFNULL(b.blc_count,0)), " links]") AS text
FROM page AS dab
JOIN page_props ON pp_page=page_id AND pp_propname="disambiguation"
JOIN u2815__p.backlinkcount_lvwiki_p AS a ON a.blc_from=page_id
LEFT JOIN redirect   ON rd_namespace=dab.page_namespace AND rd_title=dab.page_title
LEFT JOIN u2815__p.backlinkcount_lvwiki_p AS b ON b.blc_from=rd_from
WHERE page_namespace=0
GROUP BY page_id
ORDER BY a.blc_count DESC
LIMIT 100;
SQL

Checking query status...
