From 4f174972e3f3040f78f87f2b96a0e7bfc94fed6e Mon Sep 17 00:00:00 2001 From: Přemysl Eric Janouch Date: Mon, 22 Jan 2024 18:08:12 +0100 Subject: gallery: move out a query from CTE --- main.go | 13 +++++-------- 1 file changed, 5 insertions(+), 8 deletions(-) diff --git a/main.go b/main.go index 408b7ea..7c9aceb 100644 --- a/main.go +++ b/main.go @@ -964,13 +964,6 @@ const searchCTE = `WITH FROM tag_assignment AS ta JOIN image AS i ON i.sha1 = ta.sha1 WHERE ta.tag = ? - ), - supertags(tag, space, name) AS ( - SELECT DISTINCT ta.tag, ts.name, t.name - FROM tag_assignment AS ta - JOIN matches AS m ON m.sha1 = ta.sha1 - JOIN tag AS t ON ta.tag = t.id - JOIN tag_space AS ts ON ts.id = t.space ) ` @@ -1010,7 +1003,11 @@ type webTagSupertag struct { func getTagSupertags(tag int64) (result map[int64]*webTagSupertag, err error) { rows, err := db.Query(searchCTE+` - SELECT tag, space, name FROM supertags`, tag) + SELECT DISTINCT ta.tag, ts.name, t.name + FROM tag_assignment AS ta + JOIN matches AS m ON m.sha1 = ta.sha1 + JOIN tag AS t ON ta.tag = t.id + JOIN tag_space AS ts ON ts.id = t.space`, tag) if err != nil { return nil, err } -- cgit v1.2.3-70-g09d2