Untitled query #54882

This query is marked as a draft This query has been published by עלי.

SQL

SELECT
	concat('משתמש:', p.page_title) AS title,
    cl_to AS category
FROM	categorylinks
INNER JOIN
	page cat
    ON
    	cat.page_namespace = 10
        AND
        cat.page_title = cl_to
INNER JOIN
	page p
    ON
    	p.page_id = cl_from
WHERE
	p.page_namespace = 2
    AND
    cl_to NOT LIKE 'User_%'
    AND
    NOT EXISTS
    (
      SELECT * FROM page_props WHERE pp_page = cat.page_id AND pp_propname = 'hiddencat'
    )
ORDER BY
	cl_to;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...