From 82385f50d12492bd980b6f88a138a8821f597efd Mon Sep 17 00:00:00 2001
From: rtz12 <koenig@fagott.pw>
Date: Sun, 9 Oct 2016 21:27:30 +0200
Subject: Tabelle wurde umbenannt


diff --git a/modules/grils/grils.go b/modules/grils/grils.go
index 135398d..fbee062 100644
--- a/modules/grils/grils.go
+++ b/modules/grils/grils.go
@@ -265,10 +265,8 @@ func (m *GrilsModule) viewGril(w http.ResponseWriter, r *http.Request, p httprou
 
 	// ähnliche grils holen
 	rows, err := m.g.DB.Query(`SELECT gril_id FROM (
-	SELECT DISTINCT gril_id FROM gril_appearance WHERE appearance_id IN (SELECT appearance_id FROM gril_appearance WHERE gril_id = $1)
-	) as t
-    ORDER BY RANDOM()
-    LIMIT 4;`, id)
+		SELECT DISTINCT gril_id FROM grils_appearances WHERE appearance_id IN (SELECT appearance_id FROM gril_appearance WHERE gril_id = $1)
+		) as t ORDER BY RANDOM() LIMIT 4;`, id)
 	if err != nil {
 		log.Println("could not get similar grils:", err)
 		http.Error(w, "500", http.StatusInternalServerError)
-- 
cgit v0.10.1