-
- data = execute("SELECT id, field_id, value FROM data WHERE id in \
- (select id from data where value LIKE '%s' and field_id=? LIMIT 50) \
- and field_id in (%s)" % (s, ','.join('%r' % f for f in fields.keys())), (key_id,)).fetchall()
-
- for id, field_id, value in data:
- if not items_dict.has_key(id):
- items_dict[id] = {}
- items_dict[id][fields[int(field_id)]] = value
+ data = execute("SELECT id, field_id, value FROM data WHERE id IN \
+ (SELECT id FROM data WHERE value LIKE '%s' AND field_id=? LIMIT \
+ 50) AND field_id in (%s)" % (s, ','.join('%r' % f for f in \
+ fields.keys())), (key_id,)).fetchall()
+ for data_id, field_id, value in data:
+ if not items_dict.has_key(data_id):
+ items_dict[data_id] = {}
+ items_dict[data_id][fields[int(field_id)]] = value