Merge pull request #24 from wikimedia/log-comments

MusikAnimal · web-flow · commit 35d67fcc040d · 2018-11-16T18:52:11.000-05:00
Update deleted_prods report to use new comment table
diff --git a/reports.py b/reports.py
@@ -273,11 +273,12 @@ def deleted_prods( self ):
 					min(log_timestamp) AS firstdel,
 					max(log_timestamp) AS lastdel,
 					group_concat(
-						log_timestamp," - ",log_comment,"<br>"
+						log_timestamp," - ",comment_text,"<br>"
 						ORDER BY log_timestamp ASC
 						SEPARATOR " "
 					) as log
 				FROM categorylinks,page,logging_logindex
+				LEFT OUTER JOIN comment ON log_comment_id = comment_id
 				WHERE cl_from=page_id
 				AND cl_to="All_articles_proposed_for_deletion"
 				AND page_title=log_title
