1 files changed, 3 insertions, 3 deletions
diff --git a/sql/sql.go b/sql/sql.go
index a02c939..6763c8f 100644
--- a/sql/sql.go
+++ b/sql/sql.go
@@ -99,13 +99,13 @@ SELECT log.id AS id,
        hijacked,
        type,
        rr_question.name AS question,
-       rr_answer.name AS answer
+       IFNULL(rr_answer.name, "") AS answer
 FROM log
 INNER JOIN remote_addr ON remote_addr.id = log.remote_addr_id
 INNER JOIN rr_question ON rr_question.id = rr_question_id
 INNER JOIN rr_type ON rr_type.id = rr_type_id
-INNER JOIN log_rr_answer ON log_rr_answer.log_id = log.id
-INNER JOIN rr_answer ON rr_answer.id = log_rr_answer.rr_answer_id
+LEFT  JOIN log_rr_answer ON log_rr_answer.log_id = log.id
+LEFT  JOIN rr_answer ON rr_answer.id = log_rr_answer.rr_answer_id
 WHERE log.id IN (SELECT id FROM log ORDER BY time DESC, id DESC LIMIT $1)
 ORDER BY time DESC, rr_answer.id DESC
 `