# 不適切なリンクを含むユーザープロフィールの確認

**URL:** <https://meta.discourse.org/t/checking-user-profiles-for-inappropriate-links/84718>\
**Category:** Product Support\
**Created:** [2018 年 4 月 6 日午後 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:** 9

<div class="post-metadata">

**Author:** ![Mittineague](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mittineague/32/114259_2.png) [@Mittineague](https://meta.discourse.org/u/Mittineague)\
**Post date:** [2018 年 4 月 18 日午後 6:24 UTC](https://meta.discourse.org/t/checking-user-profiles-for-inappropriate-links/84718/9 "2018-04-18T18:24:29Z")

</div>

That looks like a good try, but there is more you should know.

> [@testingsoftware](#):
>
> I didn’t put any limit

The [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin has built in LIMIT so time and memory consuming queries won’t cause a bog down.

“approved” is like a boolean true / false field so ordering by it is mostly useless.

IMHO it would be more useful and more efficient to ORDER BY the indexed id field.

Try these

```plaintext
SELECT COUNT(`website`) 
FROM `user_profiles` 
WHERE `website` IS NOT NULL; 

```

and

```plaintext
SELECT COUNT(`bio_raw`) 
FROM `user_profiles` 
WHERE `bio_raw` IS NOT NULL; 

```

to get an idea of how many rows you’re dealing with.

---

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