From 2b1a592c9ee9ef2dcf708f90fad048c397b43508 Mon Sep 17 00:00:00 2001
From: Adam Mathes <adam@trenchant.org>
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