USE plwiki_p;

​

SET @row_num = 0; 

SET @row_num2 = 0; 

​

CREATE TEMPORARY TABLE nux_temp_reviews (

review_count bigint

, log_actor bigint

) ENGINE=MEMORY;

​

INSERT INTO nux_temp_reviews

(review_count, log_actor)

​

      SELECT count(*) as review_count, log_actor

      FROM logging 

      WHERE log_type = 'review' AND log_action = 'approve'

      AND log_timestamp >= 20190101000000

      AND log_timestamp <= 20191231235959

      GROUP BY log_actor

​