Wikipedia:Database reports/Template sandboxes with categories
{{Database report
| sql =
SELECT page_title
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_actively_undergoing_construction',
'Pages_transcluding_nonexistent_sections',
'Pages_using_gadget_Calculator',
'Pages_using_gadget_ImageStackPopup',
'Pages_using_gadget_Vivarium',
'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_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_parser_function_time_errors',
'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 LIKE '%/%sandbox%'
GROUP BY page_title
LIMIT 2000;
| wikilinks = 1:10
| interval = 1
| remove_underscores = 1
| header_template = static row numbers
| table_class = wikitable sortable static-row-numbers static-row-header-text
}}
{{static row numbers}}
----
{{Database report/footer|count=913|query_runtime=19.06|last_updated=09:26, 28 June 2025 (UTC)}}
{{Database report end}}