diff options
Diffstat (limited to 'chimere/feeds.py')
| -rw-r--r-- | chimere/feeds.py | 7 |
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 |