CSD Stats - Quarry

SQL

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 = "Dane" 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
SQL

Checking query status...
