nlwiki Isotope navigation templates

SQL

SELECT tp.page_id AS id, tp.page_title AS title, tp.page_is_redirect AS rd, tp.page_len AS len, rev_timestamp, actor_name,
	COUNT(pl.page_title) AS rdc
FROM revision, actor, page tp
	LEFT JOIN pagelinks ON pl_from=tp.page_id
    LEFT JOIN linktarget ON pl_target_id=lt_id
    LEFT JOIN page pl ON (lt_namespace=pl.page_namespace AND lt_title=pl.page_title AND pl.page_is_redirect=1)
WHERE tp.page_namespace=10 AND tp.page_title REGEXP '^Navigatie_isotopen_van_' AND tp.page_latest=rev_id AND rev_actor=actor_id
GROUP BY tp.page_id

SQL

Checking query status...