Untitled query #49863

SQL

SELECT 
	rc_title, page_title, rc_log_type, DATE_FORMAT(log_timestamp, 'le %W %e %M %Y') AS date FROM recentchanges
    term_entity_type,
    term_language,
	count(if(term_type = 'label',1,null)) as labels,
    count(if(term_type = 'description',1,null)) as descriptions,
    count(if(term_type = 'alias',1,null)) as aliases
FROM wb_terms
WHERE term_language IN (
	'as', 'bn', 'gom', 'gom-deva', 'gom-latn', 'gu', 'hi', 'kn', 'ks', 'ks-arab', 'ks-deva', 'mai', 'mni', 'ml', 'mr', 'ne', 'or', 'pa', 'pnb', 'sa', 'sat', 'sd', 'ta', 'te', 'ur'
)
GROUP BY term_entity_type, term_language
ORDER BY labels DESC;
   INNER JOIN logging ON logging.log_id = rc_logid
    INNER JOIN page ON page.page_id = rc_cur_id 
   WHERE log_timestamp > DATE_ADD(NOW(), INTERVAL -3 MONTH) AND log_type in ('delete', 'protect') 
   LIMIT 100;
SQL

Checking query status...
