Checking user profiles for inappropriate links

Product Support
4

Great idea.

I imagine this query:

-- [params]
-- int :limit = 150
-- string :url = %term%

SELECT 
    up.user_id, u.name, up.website, u.updated_at as updated, up.location, up.views as views
FROM user_profiles up, users u
WHERE up.user_id = u.id
AND (u.admin = 'f' AND u.moderator = 'f')
AND up.website ILIKE :url
ORDER BY views desc
LIMIT :limit

I tried to put a param for “order by” but I can’t, if some guru from Data Explorer (@simon) may help here I’ll appreciate a lot :wink:

By the way, I updated the query list :rocket: