diff options
author | Adam Mathes <adam@trenchant.org> | 2018-04-28 17:58:01 -0700 |
---|---|---|
committer | Adam Mathes <adam@trenchant.org> | 2018-04-28 17:58:01 -0700 |
commit | 2b1a592c9ee9ef2dcf708f90fad048c397b43508 (patch) | |
tree | 0c218bacedb015bc7d328a37454a7dcd857ff79c /models | |
parent | 05def1ea616242a0c44c72402657d1866afdf005 (diff) | |
download | neko-2b1a592c9ee9ef2dcf708f90fad048c397b43508.tar.gz neko-2b1a592c9ee9ef2dcf708f90fad048c397b43508.tar.bz2 neko-2b1a592c9ee9ef2dcf708f90fad048c397b43508.zip |
switch to less dumb item filter query i guess
Diffstat (limited to 'models')
-rw-r--r-- | models/item/item.go | 6 |
1 files 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 { |