nlwiktionary Uncategorized templates

SQL

/*SELECT page_title, page_len
FROM page, categorylinks
WHERE
	page_namespace=10 AND
    page_is_redirect=0 AND
    page_id=cl_from AND
    NOT EXISTS ( # categories suitable for templates
      	SELECT *
      	FROM category
        WHERE 
      		cl_to=cat_title AND
      		cat_title REGEXP '[Ss]jablo(nen|on)' AND
      		NOT EXISTS ( # hidden categories
              	SELECT *
              	FROM page, page_props
              	WHERE cat_title=page_title AND page_namespace=14 AND pp_page=page_id AND pp_propname='hiddencat'
            )
    )*/
		SELECT *
      	FROM category
        WHERE 
      		cat_title REGEXP '[Ss]jablo(nen|on)' AND
      		NOT EXISTS ( # hidden categories
              	SELECT *
              	FROM page, page_props
              	WHERE cat_title=page_title AND page_namespace=14 AND pp_page=page_id AND pp_propname='hiddencat'
            )
SQL

Checking query status...
