# Verificando perfiles de usuario en busca de enlaces inapropiados

**URL:** <https://meta.discourse.org/t/checking-user-profiles-for-inappropriate-links/84718>\
**Category:** Product Support\
**Created:** [6 Abril, 2018 12:42 UTC](https://meta.discourse.org/t/checking-user-profiles-for-inappropriate-links/84718 "2018-04-06T12:42:19Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![SidV](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sidv/32/119460_2.png) [@SidV](https://meta.discourse.org/u/SidV)\
**Post date:** [6 Abril, 2018 14:50 UTC](https://meta.discourse.org/t/checking-user-profiles-for-inappropriate-links/84718/4 "2018-04-06T14:50:09Z")

</div>

Great idea.

I imagine this query:

```sql
-- [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](https://meta.discourse.org/t/32566?silent=true) (@simon) may help here I’ll appreciate a lot 😉

By the way, I updated _[the query list](https://github.com/SidVal/discourse-data-explorer/blob/queries/querys.md)_ 🚀

---

_[View the full topic](https://meta.discourse.org/t/checking-user-profiles-for-inappropriate-links/84718)._