aboutsummaryrefslogtreecommitdiffstats
path: root/models
diff options
context:
space:
mode:
authorAdam Mathes <adam@trenchant.org>2018-04-28 17:58:01 -0700
committerAdam Mathes <adam@trenchant.org>2018-04-28 17:58:01 -0700
commit2b1a592c9ee9ef2dcf708f90fad048c397b43508 (patch)
tree0c218bacedb015bc7d328a37454a7dcd857ff79c /models
parent05def1ea616242a0c44c72402657d1866afdf005 (diff)
downloadneko-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.go6
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 {