From 2ef25e3f3714051da18188a6026f4f08bb0ab24b Mon Sep 17 00:00:00 2001 From: Jayaram Pai Date: Sat, 8 Mar 2014 18:18:25 +0530 Subject: fixed manage_comments query --- tbc_external_review.module | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'tbc_external_review.module') diff --git a/tbc_external_review.module b/tbc_external_review.module index 33aa738..3d0e745 100755 --- a/tbc_external_review.module +++ b/tbc_external_review.module @@ -933,7 +933,7 @@ } else { /* displaying the list of books */ $query = " - SELECT DISTINCT erc.preference_id, pre.book, pre.author, usr_con.name AS contributor, usr_ext.name AS reviewer, erd.mail + SELECT DISTINCT erc.preference_id, pre.book, pre.author, usr_con.name AS contributor, usr_ext.name AS reviewer, erd.sent FROM external_review_comments erc LEFT JOIN textbook_companion_preference pre ON erc.preference_id = pre.id LEFT JOIN textbook_companion_proposal pro ON pre.proposal_id = pro.id -- cgit