Untitled query #70219

SQL

(      
 SELECT      
SUBSTR(log_timestamp,1,6), actor_name as 'Usuario', COUNT(*)  
FROM      
logging, actor     
WHERE      
log_type= 'thanks'     
AND      
actor_id = log_actor    
AND      
  SUBSTR(log_timestamp,1,6) BETWEEN '202101' AND '202112' 
AND      
log_namespace = '2'    
GROUP BY actor_name    
 ORDER BY COUNT(*) DESC  
)      
      
UNION      
(      
SELECT       
SUBSTR(log_timestamp,1,6), actor_name as 'Usuario', COUNT(*)  
FROM      
logging, actor     
WHERE      
log_type= 'thanks'     
AND      
actor_id = log_actor    
AND      
SUBSTR(log_timestamp,1,6) BETWEEN '202201' AND '202212'  
AND      
log_namespace = '2'    
GROUP BY actor_name    
 ORDER BY COUNT(*) DESC  
)
SQL

Checking query status...
