refactor: better sql
diff --git a/erpnext/education/utils.py b/erpnext/education/utils.py
index ac7294b..433ef9f 100644
--- a/erpnext/education/utils.py
+++ b/erpnext/education/utils.py
@@ -308,7 +308,7 @@
from `tabcourse topic`,
`tabprogram course`
where `tabcourse topic`.parent = `tabprogram course`.course
- and `tabprogram course`.parent = '{0}'""".format(program.name))
+ and `tabprogram course`.parent = %(program)s""", {'program': program})
progress = []
for topic in topics:
diff --git a/erpnext/www/lms/content.py b/erpnext/www/lms/content.py
index f804cee..3ab7a9f 100644
--- a/erpnext/www/lms/content.py
+++ b/erpnext/www/lms/content.py
@@ -63,6 +63,6 @@
`tabtopic content`
where `tabcourse topic`.parent = `tabprogram course`.course
and `tabtopic content`.parent = `tabcourse topic`.topic
- and `tabprogram course`.parent = '{0}'""".format(program))
+ and `tabprogram course`.parent = %(program)s""", {'program': program})
return (content, content_type) in contents_of_program
\ No newline at end of file