diff options
Diffstat (limited to 'src/site.clj')
| -rw-r--r-- | src/site.clj | 10 |
1 files changed, 4 insertions, 6 deletions
diff --git a/src/site.clj b/src/site.clj index bb4d2b8..4ff0c45 100644 --- a/src/site.clj +++ b/src/site.clj @@ -1002,12 +1002,10 @@ WHERE u.user_id = ANY(?)" (defn ghetto-search-query [num-tokens]
(str "select
- content from messages
- where room_id = 1
- and content ilike " (str-join " and content ilike " (take num-tokens (repeat "?"))) "
- and content like '%http://%'
- order by message_id desc
- limit 250;"))
+ url from image_urls
+ where content ilike " (str-join " and content ilike " (take num-tokens (repeat "?"))) "
+ order by last_posted desc
+ limit 200;"))
(def *ghetto-search-regex* #"^[A-Za-z0-9\-_.+]*$")
|