return
try:
- query = "SELECT tq.question, tq.answer FROM `trivia_questions` AS tq JOIN `trivia_themes` AS tt "
- query += "ON tq.theme_id=tt.theme_id AND tt.theme_name='%s' ORDER BY rand() LIMIT 1"
+ query = "SELECT tq.question, tq.answer FROM `trivia_questions` AS tq JOIN (SELECT tq2.id FROM `trivia_questions` AS tq2 JOIN `trivia_themes` AS tt ON tq2.theme_id=tt.theme_id AND tt.theme_name='default' ORDER BY rand() LIMIT 1) AS x WHERE tq.id = x.id"
self.dbp.execute(query % self.themes[self.theme])
except Exception, ex:
self.module.elog.error('Unable to look up trivia question: %s' % ex)