Untitled query #86085

SQL

SELECT page_title, MAX(CASE WHEN lt_id IS NOT NULL THEN 'Yes' ELSE '' END) as Sidebar
FROM page
LEFT JOIN categorylinks ON page_id=cl_from
  AND cl_to NOT IN ('Article_message_templates_with_missing_parameters',
                    'File_message_boxes',
                    'Intricate_templates',
                    'Lists_based_on_Wikidata',
                    'Lua-based_templates',
                    'Navbox_orphans',
                    'Navboxes_using_background_colours',
                    'Navboxes_using_borders',
                    'Navigational_boxes_without_horizontal_lists',
                    'Noindexed_pages',
                    'Pages_transcluding_nonexistent_sections',
                    'Pages_using_gadget_WikiMiniAtlas',
                    'Pages_using_Template:Background_color_with_invalid_color_combination',
                    'Pages_using_the_EasyTimeline_extension',
                    'Pages_using_the_Graph_extension',
                    'Pages_using_the_Kartographer_extension',
                    'Pages_using_the_Kartographer_extension',
                    'Pages_using_the_Phonos_extension‎',
                    'Pages_using_the_WikiHiero_extension‎',
                    'Pages_with_broken_maps‎',
                    'Pages_with_broken_reference_names',
                    'Pages_with_disabled_graphs',
                    'Pages_with_disallowed_DISPLAYTITLE_modifications‎',
                    'Pages_with_missing_files‎',
                    'Pages_with_non-numeric_formatnum_arguments',
                    'Pages_with_Phonos_rendering_errors‎',
                    'Pages_with_reference_errors',
                    'Pages_with_script_errors',
                    'Potentially_illegible_navboxes',
                    'Sidebars_with_styles_needing_conversion',
                    'Template_documentation_pages',
                    'Templates_generating_hAudio_microformats',
                    'Templates_needing_substitution_checking',
                    'Templates_that_are_not_mobile_friendly',
                    'Templates_using_data_from_Wikidata',
                    'Templates_using_TemplateData',
                    'Templates_using_TemplateStyles',
                    'Templates_using_Toolforge',
                    'Templates_using_under-protected_Lua_modules‎',
                    'Templates_with_missing_or_incorrect_documentation',
                    'Userboxes_with_insufficient_color_contrast',
                    'Wikipedia_extended-confirmed-protected_templates',
                    'Wikipedia_fully_protected_templates‎',
                    'Wikipedia_move-protected_templates‎',
                    'Wikipedia_semi-protected_templates',
                    'Wikipedia_substituted_templates',
                    'Wikipedia_template-protected_templates',
                    'Wikipedia_templates_to_be_automatically_substituted')
LEFT JOIN templatelinks ON page_id=tl_from AND tl_from_namespace=10
LEFT JOIN linktarget ON tl_target_id=lt_id AND lt_namespace=828 AND lt_title='Sidebar'
WHERE page_namespace=10
AND page_is_redirect=0
AND cl_from IS NULL
AND page_title NOT LIKE '%/%'
GROUP BY page_title
LIMIT 1000;
SQL

Checking query status...
