SELECT COUNT(CASE WHEN dels.log_comment LIKE '%|G1]%' THEN 1 ELSE NULL END ) AS 'G1',

 COUNT(CASE WHEN dels.log_comment LIKE '%|G2%' THEN 1 ELSE NULL END ) AS 'G2',

 COUNT(CASE WHEN dels.log_comment LIKE '%|G3%' THEN 1 ELSE NULL END ) AS 'G3',

 COUNT(CASE WHEN dels.log_comment LIKE '%|G4%' THEN 1 ELSE NULL END ) AS 'G4',

 COUNT(CASE WHEN dels.log_comment LIKE '%|G5%' THEN 1 ELSE NULL END ) AS 'G5',

 COUNT(CASE WHEN dels.log_comment LIKE '%|G6%' THEN 1 ELSE NULL END ) AS 'G6',

 COUNT(CASE WHEN dels.log_comment LIKE '%|G7%' THEN 1 ELSE NULL END ) AS 'G7',

 COUNT(CASE WHEN dels.log_comment LIKE '%|G8%' THEN 1 ELSE NULL END ) AS 'G8',

 COUNT(CASE WHEN dels.log_comment LIKE '%|G9%' THEN 1 ELSE NULL END ) AS 'G9',

 COUNT(CASE WHEN dels.log_comment LIKE '%|G10%' THEN 1 ELSE NULL END ) AS 'G10',

 COUNT(CASE WHEN dels.log_comment LIKE '%|G11%' THEN 1 ELSE NULL END ) AS 'G11',

 COUNT(CASE WHEN dels.log_comment LIKE '%|G12%' THEN 1 ELSE NULL END ) AS 'G12',

 COUNT(CASE WHEN dels.log_comment LIKE '%|G13%' THEN 1 ELSE NULL END ) AS 'G13',

​

COUNT(CASE WHEN dels.log_comment LIKE '%|A1]%' THEN 1 ELSE NULL END ) AS 'A1',

 COUNT(CASE WHEN dels.log_comment LIKE '%|A2%' THEN 1 ELSE NULL END ) AS 'A2',

 COUNT(CASE WHEN dels.log_comment LIKE '%|A3%' THEN 1 ELSE NULL END ) AS 'A3',

 COUNT(CASE WHEN dels.log_comment LIKE '%|A5%' THEN 1 ELSE NULL END ) AS 'A5',

 COUNT(CASE WHEN dels.log_comment LIKE '%|A7%' THEN 1 ELSE NULL END ) AS 'A7',

 COUNT(CASE WHEN dels.log_comment LIKE '%|A9%' THEN 1 ELSE NULL END ) AS 'A9',

 COUNT(CASE WHEN dels.log_comment LIKE '%|A10%' THEN 1 ELSE NULL END ) AS 'A10',

  COUNT(CASE WHEN dels.log_comment LIKE '%|A11%' THEN 1 ELSE NULL END ) AS 'A11',

  COUNT(CASE WHEN dels.log_comment LIKE '%closed as delete' THEN 1 ELSE NULL END ) AS 'AfD',

    COUNT(CASE WHEN dels.log_comment LIKE '%|PROD%' THEN 1 ELSE NULL END ) AS 'PROD'

FROM

(

  SELECT log.log_comment, log.log_action  FROM archive_userindex aui

JOIN logging_logindex log ON aui.ar_page_id=log.log_page

WHERE aui.ar_user_text = "Alex Cohn" and log.log_action="delete" AND log_action = "delete" AND log_action = "delete" AND (log.log_type = "pagetriage-deletion" OR log.log_type = "delete")

) dels

​