From 4b0003241c69fd2a209a7e967254c0346847baff Mon Sep 17 00:00:00 2001 From: rtz12 Date: Sun, 9 Oct 2016 21:29:48 +0200 Subject: Ich bin behindert diff --git a/modules/grils/grils.go b/modules/grils/grils.go index fbee062..4913e11 100644 --- a/modules/grils/grils.go +++ b/modules/grils/grils.go @@ -265,7 +265,7 @@ 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 grils_appearances WHERE appearance_id IN (SELECT appearance_id FROM gril_appearance WHERE gril_id = $1) + SELECT DISTINCT gril_id FROM grils_appearances WHERE appearance_id IN (SELECT appearance_id FROM grils_appearances WHERE gril_id = $1) ) as t ORDER BY RANDOM() LIMIT 4;`, id) if err != nil { log.Println("could not get similar grils:", err) -- cgit v0.10.1