Kobi Arad blacklisting

This shows pages, existing and deleted, that match /kob.*arad/i.

This is a bit wider than the actual blacklisted pattern, but was the intent of NinjaRobotPirate's nonworking edit to it on 30 May 2020.  The pattern in use doesn't have the false positives at [[User:RickoBoyParadise]] or [[File talk:Kobe_Trophy_Parade.jpg]], but misses all the Yaakob and Yakob variants, as well as [[Koby Arad]] that was created specifically to dodge the blacklist.

For [[WP:AN#Kobi Arad]] circa 14 June 2022.

SQL

SET @pat='(?i)kob.*arad';

SELECT CONCAT('[[', CASE page_namespace
                      WHEN -2 THEN 'Media:'               WHEN -1 THEN 'Special:'
                      WHEN 0 THEN ''                      WHEN 1 THEN 'Talk:'
                      WHEN 2 THEN 'User:'                 WHEN 3 THEN 'User talk:'
                      WHEN 4 THEN 'Wikipedia:'            WHEN 5 THEN 'Wikipedia talk:'
                      WHEN 6 THEN ':File:'                WHEN 7 THEN 'File talk:'
                      WHEN 8 THEN 'MediaWiki:'            WHEN 9 THEN 'MediaWiki talk:'
                      WHEN 10 THEN 'Template:'            WHEN 11 THEN 'Template talk:'
                      WHEN 12 THEN 'Help:'                WHEN 13 THEN 'Help talk:'
                      WHEN 14 THEN ':Category:'           WHEN 15 THEN 'Category talk:'
                      WHEN 100 THEN 'Portal:'             WHEN 101 THEN 'Portal talk:'
                      WHEN 108 THEN 'Book:'               WHEN 109 THEN 'Book talk:'
                      WHEN 118 THEN 'Draft:'              WHEN 119 THEN 'Draft talk:'
                      WHEN 446 THEN 'Education Program:'  WHEN 447 THEN 'Education Program talk:'
                      WHEN 710 THEN 'TimedText:'          WHEN 711 THEN 'TimedText talk:'
                      WHEN 828 THEN 'Module:'             WHEN 829 THEN 'Module talk:'
                      WHEN 2300 THEN 'Gadget:'            WHEN 2301 THEN 'Gadget talk:'
                      WHEN 2302 THEN 'Gadget definition:' WHEN 2303 THEN 'Gadget definition talk:'
                      ELSE CONCAT('{{ns:', page_namespace, '}}:')
                    END, page_title,']]'),
       existing
FROM (SELECT DISTINCT page_namespace, page_title, 1 AS existing
      FROM page
      WHERE page_title RLIKE @pat

      UNION

      SELECT DISTINCT ar_namespace, ar_title, 0
      FROM archive
      WHERE ar_title
      RLIKE @pat) sq;

SQL

Checking query status...