SELECT page_title, 

    pr_level,

    pr_cascade,

    pr_expiry,

    pr_type,

    comment_text AS `protection comments`

FROM page

JOIN page_restrictions ON page_id = pr_page

LEFT JOIN logging_logindex ON log_namespace = page_namespace AND log_title = page_title AND log_type = 'protect'

LEFT JOIN comment_logging ON comment_id = log_comment_id

WHERE page_namespace = 0

    AND pr_expiry = 'infinity'

    AND pr_level = "extendedconfirmed"

​

    AND (comment_text LIKE '%CT/GG%' 

         OR comment_text LIKE '%GENSEX%' 

         OR comment_text LIKE '%ARBGG%' 

         OR comment_text LIKE '%ARBGSDS%'

         OR comment_text LIKE '%ARBGSCT%'

         OR comment_text LIKE '%ARBGS%'

         OR comment_text LIKE '%ARBGENDER%')

GROUP BY page_id