diff --git a/erpnext/support/doctype/support_ticket/__init__.py b/erpnext/support/doctype/support_ticket/__init__.py
index bff98d2..0e73cf7 100644
--- a/erpnext/support/doctype/support_ticket/__init__.py
+++ b/erpnext/support/doctype/support_ticket/__init__.py
@@ -47,15 +47,15 @@
 		if "<" in mail.mail['From']:
 			import re
 			re_result = re.findall('(?<=\<)(\S+)(?=\>)', mail.mail['From'])
-			if re_result and re_result[0]: email_id = res_result[0]
+			if re_result and re_result[0]: email_id = re_result[0]
 
 
 		for thread_id in thread_list:
 			exists = webnotes.conn.sql("""\
 				SELECT name
 				FROM `tabSupport Ticket`
-				WHERE name=%s AND raised_by REGEXP '%s'
-				""" % ('(' + email_id + ')',), thread_id)
+				WHERE name=%s AND raised_by REGEXP %s
+				""" , (thread_id, '(' + email_id + ')'))
 			if exists and exists[0] and exists[0][0]:
 				from webnotes.model.code import get_obj