Changeset 564

Timestamp:

02/16/10 02:19:33 (5 months ago)

Author:

olivier

Message:

fix enriched items query set when the location belongs to several country

Files:

• trunk/telemeta/models/query.py (modified) (1 diff)

trunk/telemeta/models/query.py

@@ -148 +148 @@
                     '(SELECT l2.name FROM location_relations AS r INNER JOIN locations AS l2 '
                     'ON r.ancestor_location_id = l2.id '
-                    'WHERE r.location_id = media_items.location_id AND l2.type = ' + str(Location.COUNTRY) + ' ))'
+                    'WHERE r.location_id = media_items.location_id AND l2.type = ' + str(Location.COUNTRY) + ' LIMIT 1))'
                 })
             else: