Fork of
Articles without content category
by Kasyap
This query is marked as a draft
This query has been published
by Ivi104.
SQL
AخA
SELECT CONCAT('* [[', page_title, ']]')
-- , rev_timestamp, (SELECT pp_value FROM page_props WHERE pp_page=page_id AND pp_propname='wikibase-item') AS Wikidata
FROM page
-- INNER JOIN (SELECT DISTINCT rc_cur_id FROM recentchanges WHERE rc_type IN (0,1) AND rc_namespace=0) rc ON rc_cur_id=page_id
-- INNER JOIN revision ON (
-- rev_parent_id=0 AND page_id=rev_page AND UNIX_TIMESTAMP()-UNIX_TIMESTAMP(STR_TO_DATE(rev_timestamp,'%Y%m%d%H%i%s'))>86400)
WHERE
page_namespace=0 AND
page_is_redirect=0 AND
NOT EXISTS (SELECT * FROM page_props WHERE page_id=pp_page AND pp_propname='disambiguation') AND
NOT EXISTS (SELECT * FROM categorylinks
WHERE page_id=cl_from AND cl_to REGEXP '^Wikipedia:(Verwijderbaar/[0-9]{2}|Nog_niet_gereed|Nuweg|Werk_in_uitvoering)$'
) AND
NOT EXISTS (SELECT * FROM (
# niet-beheer categorylinks
SELECT cl_from, cl_to FROM categorylinks WHERE
cl_to NOT REGEXP
'^Diersoort_beschreven_in_|'
'^Actuele_(sport)?gebeurtenis$|'
'^Wikipedia:Incomplete_lijsten$|'
'^IUCN-status_|'
'^Dier_uit_het_[ANOP][a-zë]+_gebied$' AND
NOT EXISTS (SELECT * FROM (
# beheercategorieën
SELECT DISTINCT page_title
FROM page, page_props
WHERE page_namespace=14 AND page_id=pp_page AND (pp_propname='hiddencat' OR pp_propname='expectunusedcategory')
) hc WHERE cl_to=hc.page_title)
GROUP BY cl_from
ORDER BY cl_from
) nhcl WHERE nhcl.cl_from=page_id)
-- ORDER BY rev_timestamp
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.