summaryrefslogtreecommitdiff
path: root/chimere/feeds.py
diff options
context:
space:
mode:
Diffstat (limited to 'chimere/feeds.py')
-rw-r--r--chimere/feeds.py7
1 files changed, 2 insertions, 5 deletions
diff --git a/chimere/feeds.py b/chimere/feeds.py
index 100dd6b..53444ac 100644
--- a/chimere/feeds.py
+++ b/chimere/feeds.py
@@ -220,9 +220,6 @@ class LatestPOIsByZoneID(BaseFeed):
return reverse('chimere:feeds-areaid', args=['', obj.id])
def items(self, obj):
- sql = 'select * from "chimere_marker" where ' + obj.getIncludeSql()
- sql += ' and "chimere_marker".available_date is not null'
- sql += ' and "chimere_marker".status=\'A\''
- sql += ' order by "chimere_marker".available_date desc limit 15'
- q = Marker.objects.raw(sql)
+ q = Marker.objects.filter(available_date__isnull=False, status='A')
+ q = q.filter(obj.getIncludeMarker()).order_by('-available_date')[:15]
return q