From 2b1a592c9ee9ef2dcf708f90fad048c397b43508 Mon Sep 17 00:00:00 2001 From: Adam Mathes Date: Sat, 28 Apr 2018 17:58:01 -0700 Subject: switch to less dumb item filter query i guess --- models/item/item.go | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/models/item/item.go b/models/item/item.go index f70bba1..795f38e 100644 --- a/models/item/item.go +++ b/models/item/item.go @@ -126,12 +126,12 @@ func Filter(max_id int64, feed_id int64, category string, unread_only bool, star var args []interface{} - query := `SELECT STRAIGHT_JOIN item.id, item.feed_id, item.title, item.url, item.description, + query := `SELECT item.id, item.feed_id, item.title, + item.url, item.description, item.read_state, item.starred, item.publish_date, item.full_content, item.header_image, feed.url, feed.title, feed.category - FROM item - INNER JOIN feed ON feed.id=item.feed_id + FROM item,feed WHERE item.feed_id=feed.id ` if max_id != 0 { -- cgit v1.2.3