(broken) Retrieve patrolled edits

SQL

use nlwiki_p;

#SELECT a.actor_name, l.* FROM logging l INNER JOIN actor a ON l.log_actor = a.actor_id

#SELECT log_user_text, log_timestamp, CONCAT(SUBSTRING(log_timestamp, 1, 8), ' ', SUBSTRING(log_timestamp, 9, 2), ':', SUBSTRING(log_timestamp, 11, 2), ':', SUBSTRING(log_timestamp, 13, 2)) as timestamp_human, log_title FROM logging
#WHERE log_type = 'patrol' #Enkel markeringen
#AND log_namespace = '0' #Enkel hoofdnaamruimte
#ORDER BY log_timestamp DESC #De meest recente bovenaan
#LIMIT 100

# Difference with the one below?
#SELECT log_user_text, COUNT(1) as aantal
#FROM logging
#WHERE log_type = 'patrol' #Enkel markeringen
#AND log_namespace = '0' #Enkel hoofdnaamruimte
#GROUP BY log_user_text
#ORDER BY COUNT(1) DESC


#SELECT a.actor_name, COUNT(1) as aantal
#FROM logging l INNER JOIN actor a ON l.log_actor = a.actor_id
#WHERE l.log_type = 'patrol' #Enkel markeringen
#AND l.log_namespace = '0' #Enkel hoofdnaamruimte
#GROUP BY a.actor_name
#ORDER BY COUNT(1) DESC

SELECT log_title, COUNT(1)
FROM logging
WHERE log_timestamp LIKE '2019%'
AND l.log_type = 'patrol' #Enkel markeringen
AND l.log_namespace = '0' #Enkel hoofdnaamruimte
GROUP BY log_title
ORDER BY COUNT(1) DESC
SQL

Checking query status...
