USE commonswiki_p; 

SELECT

  cattmp.cl_to,

  cattmp.cl_count,

  user_name,

  log_timestamp,

  log_comment

FROM logging

JOIN `user` ON log_user = user_id

JOIN

(SELECT cl_to, COUNT(cl_to) AS cl_count

 FROM categorylinks

 LEFT JOIN page ON cl_to = page_title

 AND page_namespace = 14

 WHERE page_title IS NULL

 GROUP BY cl_to) AS cattmp

ON log_title = cattmp.cl_to

WHERE log_namespace = 14

AND log_type = "delete"

AND log_timestamp = (SELECT MAX(log_timestamp)

                     FROM logging AS last

                     WHERE log_namespace = 14

                     AND cattmp.cl_to = last.log_title)

LIMIT 100;