Tabelle wurde umbenannt

1 files changed, 2 insertions, 4 deletions

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)