Best spam prevention methods?

DarthHazard Level 1

August 13, 2017, 3:17 pm

23

Write the reason you're deleting this FAQ

Best spam prevention methods?

It can get annoying sometimes when you own a forum because of all the bots and sometimes people spamming your site with useless content or advertisements. The bots used by spammers are getting a lot more intelligent and that means that some anti-spam methods just don't work anymore. I've however noticed that, personally, custom questions work best to stop bots. For some reason, questions like "What colour is a banana?" seem to be impossible for bots to answer. What anti-spam methods work best for you?

Comments

Please login or sign up to leave a comment

Join

overcast

If you have WordPress blog then Akismet seems to be a good option. They are included into the jetpack plugin. Also you can download the standalone plugin. And there are paid and free plans for the plugin. It is going to stop most of your spam very easily. You can prevent a lot of spam using that plugin. As they have service which can be good for blocking bots and spammers.

9 years ago

Are you sure you want to delete this post?

Tronia

Yep, I agree. CAPTCHA or Akismet are two best options. As far as I know, Akismet is also integrated into the Disqus plugin which you can use on your WordPress websites. I honestly think that if you choose either one of these two that you should have 0 bots. Hell, I only used CAPTCHA and it did the trick

Best spam prevention methods?

9 years ago

Are you sure you want to delete this post?

overcast

Captcha can be bad for the users. i'd never use captcha to login to my site. But I'd use the akismet and other bot detection tools. This way I can surely prevent the spam. Also this can help me moderate the comments too. As you can see that seems to be helping a lot so far. I would also use the other WordPress security tools. That can be helpful in many ways.

9 years ago

Are you sure you want to delete this post?

Corzhens

Maybe that spam blocker is another feather on the cap of Wordpress. It seems that Wordpress is on a continuing research and development just like Google with its ways in improving the features for the benefit of the users. Spam is growing and is now a big business that maybe in the near future the spam blockers will have a license because some companies are already experiencing a problem with excessive number of spam.

7 years ago

Are you sure you want to delete this post?

overcast

They seem to be finding new ways to spam. So it's always a good idea for the stopping the spam. I think that is one reason akismet is a good plugin to work with. And few more plugins that can protect you from the typical spam patterns. it's a good option to work with as well.

7 years ago

Are you sure you want to delete this post?

Tronia

Haha, that seems to be a good method but I think that the best one is still CAPTCHA. To be specific the reCAPTCHA that is made by Google and we all know how high quality their tools are.

It has always worked for me and I never had to use anything else. I suggest that you implement it in on your websites and see the bots disappear in thin air

Best spam prevention methods?

If you have never heard about it check this link: https://www.google.com/recaptcha

9 years ago

Are you sure you want to delete this post?

hermessantos

I installed the Disqus plugin on my sites. This helped me control the spam that came from the comments. This really was a big problem.

9 years ago

Are you sure you want to delete this post?

overcast

Yes disqus can get rid of the bots and the spam. They read the IP address and mark it as unsafe. So based on that we already get filtered spam. So it can be one good option. Another similar option is intensedebate. That plugin is also same as disqus and worth using in that case.

9 years ago

Are you sure you want to delete this post?

peachpurple

I agree that CAPTCHA is still the best way to prevent spamming but it can be annoying when the picture shown and the instructions matches yet still consider incorrect. Anyway, that proves the patience of the user. I prefer the number guessing CAPTCHA than the scenery type.

9 years ago

Are you sure you want to delete this post?

hermessantos

I think the personalized questions is a good option. I find interesting the random characters and the option for you to choose images. Example: select facade images from stores, among others.

9 years ago

Are you sure you want to delete this post?

vinaya

I believing having a captcah is the best spam prevention method. However, captcha also has a disadvantage, it will deter the genuine commentator. When I visit the site and want to leave comments and I see captcha, I immediately move away from the site. I don't bother to answer the captcha just because I was to leave comments. However, if I am a registered user on the site and I want to leave comments, I sometimes don't mind captcha. This draws to a conclusion that for registered users captcha is a no problem but for visitors, it can become a great nuisance.

9 years ago

Are you sure you want to delete this post?

Corzhens

I agree that captcha is one of thebest tools to prevent spamming. And I also agree that captcha is also a
deterrent for legitimate commenter because it is not easy to solve the captcha
especially the captcha that is using numbers and letters that are presented in
a vague display. If I have a website that is being plagued by spammers, my
recourse would be to hire a virtual assistant to check on the spam posts and
ban the IP address. It will take time but it will come to a point that the
spammer will run out of IP address to use.

8 years ago

Are you sure you want to delete this post?

vinaya

You can use security plugins on your website to stop spammers. I use wordfence defense which helps me to identify real visitors and bot visitors, as well as the potential threat on the website, I use a plugin called loginizer than stops unauthorize login into your website. I am talking about wordpress site.

8 years ago

Are you sure you want to delete this post?

jitendra0341

I know that captcha is the best spam prevention method. There are some other methods to do that. Turn on the spam prevention micro service. It moderate all post by 24 hours. Moderate all posts that are repetitive.Create keyword interceptors. It prevent content from being created at all . Prompts the user by saying " sorry this content is not allowed". Change open group to members. Change open group to members only so that users need to join in order to post in it. This creates barrier for the spammers to do.

9 years ago

Are you sure you want to delete this post?

augusta

I use Captcha on my blog and it has been working for me.I will also check these other methods mentioned here to see if it more effect that Captcha

9 years ago

Are you sure you want to delete this post?

ballyhara

Captcha is the must because is super easy and effective. But the new reCaptcha has an extra bonus. Basically it depends on the old Captcha, but the new one offers support for people visually impaired, also its way to fight spam is by continuously changing, which works really good.

9 years ago

Are you sure you want to delete this post?

kgord

I am not a fan of captcha's but I know many sites depend on using them to keep their websites free from bots. It is just one of the things that we must learn to use if we want to keep spam from keeping into our content. Some of the captcha methods seem really cumbersome and not user friendly though. I guess they can be helpful in preventing spam, phishing and other things of that type.

9 years ago

Are you sure you want to delete this post?

PinkTurtle

Use captcha's or Why don't you moderate your comments. Its's a bit of hard work but if you really want to supervise every single comment then I think that's what you need to do because not only bots make silly question as " What color is a Banana?" as you described...

9 years ago

Are you sure you want to delete this post?

Fuzyon

Captcha is your best friend when you're trying to prevent spam on your website. I would also recommend accepting accounts manually - it's tideous but you can prevent spam accounts from registering to your site.

9 years ago

Are you sure you want to delete this post?

simplymh

Many use the re-CAPTCHA but I am not a fan of it too much!

9 years ago

Are you sure you want to delete this post?

JoeMilford

I use CAPTCHA, and it seems to be efficient and just fine for my purposes. It's also cheap and user-friendly.

9 years ago

Are you sure you want to delete this post?

jpyy

For forums, asking a really difficult question and/or asking people to spell a word backward (at user registration) seems to work most of the time. Nonetheless, spambots are getting smarter. On one forum, for instance, I had to add more questions than normal.

Anyway, the normal captcha doesn't seem to work well, but I haven't tried the other spam prevention methods, apart from questions.

9 years ago

Are you sure you want to delete this post?

Jeane

Spam fighting services and human intervention are the best spam prevention methods. While captcha does stop some bots, it doesn't stop all spammers. Why? A number of those keen on spamming will get captcha-solving services to help them get past that first line of defense.

Since spammers will therefore gain access one way or another, the admin has to regularly look at newly posted content and delete spam. Forum members could help too by reporting spam when they see it.

7 years ago

Are you sure you want to delete this post?

Process Time: 0.55642104148865

Possible Duplicate queries found!

Match	Count	SQL	Script
SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='23892'	1	SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='23892'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='599711'	1	SELECT * FROM seoclerks.members WHERE USERID='599711'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM categories_faq WHERE CATID='52'	1	SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='52'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
SELECT * FROM seoclerks.members WHERE USERID=599711	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=599711	/opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()
SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=23892 LIMIT 5	1	SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=23892 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='23892' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	1	SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered, b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b WHERE a.quesid='23892' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	/opt/clerks-staging/docroot/viewfaq.php 1245 () ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129514 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129514 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129560 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129560 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129631 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129631 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=173733 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=173733 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=174092 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=174092 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129406 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129406 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129409 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129409 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=130418 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=130418 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129411 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129411 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129417 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129417 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129444 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129444 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=158513 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=158513 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=158515 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=158515 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129449 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129449 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129521 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129521 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129553 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129553 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129563 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129563 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129597 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129597 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129815 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129815 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129854 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129854 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129890 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129890 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=131302 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=131302 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=169384 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=169384 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='23892'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='23892'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='23892' AND status='1' AND (question like '%Best spam prevention methods?%' OR question like '%Best%' OR question like '%spam%' OR question like '%prevention%' OR question like '%methods?%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='23892' AND status='1' AND (question like '%Best spam prevention methods?%' OR question like '%Best%' OR question like '%spam%' OR question like '%prevention%' OR question like '%methods?%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='988' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='988' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='1323' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1323' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='297' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='297' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='9' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=23892%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	1	SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=23892%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM categories	1	SELECT * FROM categories	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
select * from categories_software order by name asc	1	select * from categories_software order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()
select * from categories_wanttobuy order by name asc	1	select * from categories_wanttobuy order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()
select * from categories_wanttotrade order by name asc	1	select * from categories_wanttotrade order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()
SELECT * FROM seoclerks.members WHERE USERID='589438.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='589438.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='584702.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='584702.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='600657.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='593814.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='593814.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='598910.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='598910.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='585810.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='585810.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='604194.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='604194.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='605129.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='605129.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='600422.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='600422.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='603739.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='603739.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='584026.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='584026.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='719932.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='719932.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
select * from categories_faq order by name asc	1	select * from categories_faq order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)	sql1	error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially

Load

Count

SQL

Max

Min

Suspicious SQL

The following SQL have high average execution times

Avg Time

Count

SQL

Max

Min