Radio call sign suffixes

SQL

USE enwiki_p;
SELECT 
  page_title,
  CASE
    WHEN page_is_redirect THEN "(R)"
    ELSE ""
  END AS R
FROM page
WHERE
  page_namespace = 0 AND (
  page_title LIKE "%(AM)"
  OR page_title LIKE "%(FM)"
  OR page_title LIKE "%(TV)"
  OR page_title LIKE "%(DT)"
  OR page_title LIKE "%(LP)"
  OR page_title LIKE "%(CA)"
  OR page_title LIKE "%(LD)"
  OR page_title LIKE "%(CD)"
  OR page_title LIKE "%(D)"
  OR page_title LIKE "%-AM"
  OR page_title LIKE "%-FM"
  OR page_title LIKE "%-TV"
  OR page_title LIKE "%-DT"
  OR page_title LIKE "%-LP"
  OR page_title LIKE "%-CA"
  OR page_title LIKE "%-LD"
  OR page_title LIKE "%-CD"
  OR page_title LIKE "%-D"
  )
SQL

Checking query status...
