tawikipedia english templates not linked to wikidata

SQL

USE tawiki_p;

SELECT
  page.page_title
FROM
  page
LEFT JOIN
  page_props ON page.page_id = page_props.pp_page
    AND page_props.pp_propname = 'wikibase_item'  -- Specifically look for Wikidata links
WHERE
  page.page_namespace = 10  -- Template namespace
  AND page_props.pp_propname IS NULL  -- No Wikidata item linked
  AND page.page_is_redirect = 0  -- Exclude redirects
  AND page.page_title NOT LIKE '%/%'  -- Ignore subpages
  AND page.page_title NOT REGEXP '[\xE0\xB8\x80-\xE0\xB8\xBF]'  -- Adjusted to ignore Tamil characters
ORDER BY
  page.page_title ASC;

SQL

Checking query status...