Uncategorized templates

SQL

SELECT page_title, CASE WHEN lt_id IS NOT NULL THEN 'Yes' ELSE '' END as Navbox_musical_artist
FROM page
LEFT JOIN categorylinks ON page_id=cl_from
  AND cl_to NOT IN ('File_message_boxes',
                    'Lua-based_templates',
                    'Navbox_orphans',
                    'Navboxes_using_background_colours',
                    'Navboxes_using_borders',
                    'Navigational_boxes_without_horizontal_lists',
                    'Noindexed_pages',
                    'Pages_using_the_EasyTimeline_extension',
                    'Pages_using_the_Graph_extension',
                    'Pages_with_broken_reference_names',
                    'Pages_with_disabled_graphs',
                    'Pages_with_non-numeric_formatnum_arguments',
                    'Pages_with_reference_errors',
                    'Pages_with_script_errors',
                    'Potentially_illegible_navboxes',
                    'Sidebars_with_styles_needing_conversion')
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=10 AND lt_title='Navbox_musical_artist'
WHERE page_namespace=10
AND page_is_redirect=0
AND cl_from IS NULL
AND page_title NOT LIKE '%/%'
GROUP BY page_title, CASE WHEN lt_id IS NOT NULL THEN 'Yes' ELSE '' END
ORDER BY page_title
LIMIT 100;
SQL

Checking query status...
