Fork of
Untitled query #59430
by Vexations
This query is marked as a draft
This query has been published
by Vexations.
SQL
x
SELECT page.page_title, categorylinks.cl_to
#SELECT DISTINCT page.page_title
FROM page JOIN categorylinks ON page.page_id=categorylinks.cl_from
WHERE page.page_id IN (
SELECT page.page_id
FROM revision
JOIN pagetriage_page ON rev_page = ptrp_page_id
JOIN page ON page_id = rev_page
WHERE rev_parent_id = 0
AND ptrp_reviewed = 0
AND page_namespace = 0
AND page_is_redirect = 0
)
AND page.page_namespace=0
AND categorylinks.cl_to LIKE '%_artists%'
AND categorylinks.cl_to NOT LIKE '%martial_artists%'
AND categorylinks.cl_to NOT LIKE '%album%'
AND categorylinks.cl_to NOT LIKE '%Records_artists%'
AND categorylinks.cl_to NOT LIKE '%Discographies_of%artists'
AND categorylinks.cl_to NOT LIKE '%comics_artists'
AND categorylinks.cl_to NOT LIKE 'Lists_of_songs_recorded_by_%_artists'
AND categorylinks.cl_to NOT LIKE 'Soundtracks_by_%_artists'
AND categorylinks.cl_to NOT LIKE 'Albums_by_%_artists'
AND categorylinks.cl_to NOT LIKE 'EPs_by_%_artists'
AND categorylinks.cl_to NOT LIKE 'Videographies_%'
AND categorylinks.cl_to NOT IN ('All_disambiguation_pages',
'All_articles_lacking_sources',
'All_articles_with_empty_sections',
'All_articles_with_topics_of_unclear_notability',
'All_articles_lacking_in-text_citations',
'All_articles_needing_additional_references',
'All_articles_lacking_reliable_references',
'All_pages_needing_cleanup',
'All_stub_articles',
'All_articles_to_be_merged',
'All_articles_with_unsourced_statements',
'All_BLP_articles_lacking_sources',
'Recording_artists_by_label'
)
AND categorylinks.cl_to NOT IN ('Albums_by_American_artists',
'Albums_by_Indian_artists',
'Albums_by_Japanese_artists',
'Albums_by_Russian_artists',
'Armada_Music_artists',
'Avex_Trax_artists',
'Bangladeshi_voice_artists',
'Big_Loud_artists',
'Brainfeeder_artists',
'Captured_Tracks_artists',
'Dead_Oceans_artists',
'Dirty_Hit_artists',
'EPs_by_Australian_artists',
'FNC_Entertainment_artists',
'Hybe_Corporation_artists',
'Indian_spoken_word_artists',
'Inside_Recordings_artists',
'Japanese_make-up_artists',
'Japanese_pop_artists',
'Lists_of_best-selling_music_artists',
'Lists_of_songs_by_recording_artists',
'Lists_of_artists_by_record_label',
'Make-up_artists',
'Manga_artists',
'Manga_artists_from_Miyagi_Prefecture',
'Martial_artists',
'Mau5trap_artists',
'MCA_Music_Inc._(Philippines)_artists',
'Monstercat_artists',
'Motown_artists',
'Music_&_Arts_artists',
'Nadao_Bangkok_artists',
'Owsla_artists',
'Pledis_Entertainment_artists',
'Political_music_artists',
'RCA_Victor_artists',
'Roc_Nation_artists',
'SM_Entertainment_artists',
'Som_Livre_artists',
'Sony_Music_artists',
'Sony_Music_Entertainment_Japan_artists',
'Sony_Music_Publishing_artists',
'Starship_Entertainment_artists',
'Storyboard_artists',
'Swing_Entertainment_artists',
'Tattoo_artists',
'Universal_Music_Group_artists',
'Video_game_artists'
)
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.