use plwiki_p;

/*select * from `comment` where comment_id = 20484604;*/

​

SELECT 

log_id, log_timestamp, log_user, log_title, log_comment_id, log_user_text, c.*

FROM logging

left join `comment` c ON (c.comment_id=log_comment_id)

where log_type = 'review' and log_comment_id not in(5, 20482809, 20483216) and log_action='approve'

order by log_timestamp desc;

​

/*SELECT DISTINCT log_action FROM logging where log_type = 'review';*/