SEOClerks

How do you deal with spam members?



Write the reason you're deleting this FAQ

How do you deal with spam members?

Sooner or later these types of "members" will reach your blog, forum, website and test your patience (everything will depend on how fast your project will grow). So, be ready for it because dealing with them can be very annoying (and the headache is almost certain).

It's clear that the most obvious option is to always exclude them (is what everyone would think of as the first choice). But when they come up almost routinely... How do you deal with this "sea of ??boredom"?

Comments

Please login or sign up to leave a comment

Join
cmoneyspinner
I use various blogging platforms. The Wordpress blogs have a spam-catcher that works great! When I use Blogspot, I use the Google Plus Comments module and it catches spammers also. I don't have that many blog visitors to be overly concerned about spammers. It's very easy to catch the ones that do visit me. As for members at a particular site, if you don't own the site, contact the site owners and express your concerns. If you own the site, set up Captcha or something like that to block them.



Are you sure you want to delete this post?

Tronia
Since you mean spam members and not bots, well I think that there aren't many options on how to deal with them. You can have the so-called soft approach or the strict one. The soft approach would be you sending a PM with a warning and elaborating why they need to stop spamming and what will happen if they won't. Or, some people prefer to be strict and they just simply ban the member right away without warnings to avoid even more spam.



Are you sure you want to delete this post?

DarthHazard
Personally, I don't think that we should bother with warnings for people that spam. Of course, if it is just borderline spam where you could argue that they just are posting short messages without any meaning but they are trying their best then a warning may be a good idea. But if it is actual spam then a straight permanent ban is the best thing to do, to be honest.



Are you sure you want to delete this post?

jpyy
One trick is to ask users (at user registration) to spell a word backward. This seems to stop most spambots. However, though, it doesn't always completely work, so to get rid of any others, you might need to ban users and IPs or perhaps hire a moderator to do it. Anyway, on my forums, backward spelling has stopped spammers on most of them, but there is one where a few still get thru, despite the fact.

Anyway, in regards to blogs, not forums, I'm not aware of any special tricks. Does anyone know any?



Are you sure you want to delete this post?

augusta
I think spammers would always be there on blogs and forums.The best bet would be to issue a warning to show you have notice it and if they still resist then banning the IP would be the next action because even banning their account wouldn't work because they'll still sign up again.



Are you sure you want to delete this post?

jpyy
I think spammers will always attack at some point, but the problem can be greatly reduced with a few tricks. Unfortunately, though, people who program the bots will probably eventually figure out the tricks. For instance, at one time, any old question seemed to keep them out, but they've gotten smarter.



Are you sure you want to delete this post?

TommyCarey
First off you need to set up moderation guards so this type of crap doesn't make it live on your website or blog. With a forum it's not as easy because you want your members to post and build content, so you'll have to do manual moderation a little more.

With forums, blogs and websites you can always make it so that any URL that is posted won't show a live link. It will actually just be plain text, which won't help the spammer as much, but still looks bad on your pages. For this, you'll just have to manually moderate it if it does go live.

When it comes to bots, which I don't think you're talking about, you can simply just block them from posting (hopefully). Some bots spam the crap out of the same website, forum or blog and think they're actually benefiting from it. In reality they're just trying to get 1,000 backlinks from the same website and it will never help them out lol.

For registration, to block bots, you can always add a recaptch system so they won't be able to register. It's like a gate guardian blocking their entrance into the promise lands lol How do you deal with spam members?



Are you sure you want to delete this post?

kgord
Alot of people use verifications that people have to answer correctly to stop spammers and bots. I hate those though as it is usually something like click on all the cars when you have portions of cars in many frames..or click on all the signs when parts of the signs are in all squares.



Are you sure you want to delete this post?

Krisleen
Spammers can be really annoying for writing irrelevant comments on blogs or forums. They don't contribute and give value to you at all. But I don't think getting harsh on them is the right approach to deal with them. It will just aggravate the situation. Might as well send a formal first. If it doesn't work, then that's the time the spammer should be banned without swearing or cursing him. Things like that should be done professionally as a blog or forum owner.



Are you sure you want to delete this post?

wiseagent
I was a little bit drastic in my initial placement, haha (when I created the topic), but I would act just like you: first, a formal statement about the whole situation. If that didn't solve the problem, I would ban the member without previous warnings.



Are you sure you want to delete this post?

overcast
I use the Akismet and the anti spam plugin. And for me that works out just fine. I am not sure how many people make use of those plugins on WordPress. But they can save a lot of time on comment moderation. And it can save money in due time that being spent on the VA. I guess we just have to see what may or may not work as well. I guess spam prevention requires a lot of effort in that direction. That;s how I am handling the spam on my site and blogs.



Are you sure you want to delete this post?

PinkTurtle
I think the easiest way is to make the warning in the rules that any "spam member" that arrives your blog/site will be block or exclude, I know you said it can become rutinary to block them but there's no choice but to ban them. You could also test them before they enter your site, but that could take some time. If you are trying to fight the bots then just add a captcha to make it harder for them.



Are you sure you want to delete this post?

wiseagent
That's really good.

A kind of test (as if it were a training period) is a great idea. This could help to separate the people who really want to contribute by posting valid / important content from those people who just want to test - in a bad way - the patience of others.



Are you sure you want to delete this post?

Pixie06
The best way is to give a warning to that member and if he/she still doesn't understand that the best thing to do is to ban them. I am thankful that I have not yet come across such a member. It is not that easy to ban someone from a forum especially if that member has referred many others to your site or if they were contributing positively in the beginning. Unfortunately we have to take such drastic actions at times for our own betterment.



Are you sure you want to delete this post?

DarthHazard
To deal with automated spam bots, the best thing to do is to set up special security questions that are customised for your site to ensure that they cannot get past the registration process. Simple questions like "What colour is a banana" has worked for me in the past when I had forums. Bots never managed to get past that question but it was simple enough for normal people to answer. The only way to deal with spamming members is to ban them and try to ban their IP address as well.



Are you sure you want to delete this post?

itommy
It depends on the level of spamming. if they are trying to advertise their services/websites or adding links into their posts then I can remind them. Honestly I have a few forums and I used to ban members if could not make them better or still continue spamming.



Are you sure you want to delete this post?

DenisP
The problem with this is that it is going to be an absolute inevitability. There are people out there that literally have nothing better to do than to troll forums and blogs, and cause mayhem in your community. They are the lowest of the low when it comes to the hierarchy of internet users, and there are plenty of them. The only way to really circumvent this is to take appropriate moderation and security measures. Almost all forums have moderators for this very reason, and some go so far as to require approval before any comment or post is published, though this can be difficult if you run a popular forum that receives a lot of traffic.



Are you sure you want to delete this post?

Tronia
I agree with you. I think that there will always be spammers no matter what. You can't completely eliminate them but you can shut them down as soon as they start spamming.

I think that spammers are most common on the forums and that is why staff is important. Like you have mentioned, having good moderators and admins is crucial so the spam can't get out of hand.



Are you sure you want to delete this post?

keen2write
Yes, I can't stand spammers. I have a good number of blogs, My main blog which also as a forum I tend to get many daily spammers on my blog comments which I can approve or delete. But its just annoying deleting 100s daily as to people spamming crap about viagra and silly sexual videos. But, I delete them as soon as possible, some spammers tho do give some good feedback to what is on my blog its just pitty there links don't look all that good.



Are you sure you want to delete this post?

Authord
Well, I think it depends on the type of spam, you are talking about , And since it's not spam bots, because I have not heard of members spamming , except in the aspect of advertising their stuffs on your website. Then if it's the later then that's why moderation comes into play. If it is in your blog, you set and disable auto-comment. If it's in a forum, you will set up moderation and anti spam bot.



Are you sure you want to delete this post?

vinaya
I don't have a membership website. Therefore, until now I have not dealt with spam members. However, I do get spam comments on my blog posts. Since I manually approve comments. I the spam comments are not harming my blogs. I can control spam comments by introducing captcha feature, however, this feature will also deter the genuine competitors.



Are you sure you want to delete this post?

overcast
I think spam comment removal is easy. but Spam content posters are a bit harder to tackle. The reason being you can see that spam is not easy to adjust with. And also some of the time you can see that it may not be always easy to work around on those things. It's kind of not easy if you ask me to deal with spam. You just have to curb members in that case.



Are you sure you want to delete this post?

vinaya
In my user generated site, which had automatic approval for an article, I used to receive a lot of spam articles. It was very tiring to remove spam contents and ban the members. Then one day I changed the posting rule. I am now manually approving the articles.



Are you sure you want to delete this post?

overcast
I think it'd be a good idea to make manual review. I have found out that people who do manual review of content. It seems like a good idea. And you can easily make members adjust with rules too. But it's just something we learn and take action. And overall process takes toll on our head. That's what I have learned so far.



Are you sure you want to delete this post?

Baburra
For my blog, I used to just experiment with different methods. Once, I turned on captcha, but that turned out to be a bad move because my audience hated it and they ended up engaging with me less. I also turned to making each post approved before it went through but there's something about not seeing your comment get published immediately that turns off viewers as well. I have looked into using a third party app but I don't want to require my audience to use another service and have to sign up just to comment.



Are you sure you want to delete this post?

Barida
I must say that having people spam on my blog has been quote frustrating for it will make it look like you have robots as members and not human beings that should be keeping the rules of joining the blog. What I always do is to communicate with the said members and air my displeasure to them.



Are you sure you want to delete this post?

Soulwatcher
There is really noting you can do but keep on banning them. Because all they have to do is spoof their ip and they are back spamming on your forum or blog again. How ever if you keep banning them right away, sooner or later its not going to be fun for them anymore. Which is why I think that it's important to check your blog or forum multiple times a day.



Are you sure you want to delete this post?

peachpurple
spammers always linger at forum sites, that is the most hateful thing that down grade a forum traffic and image. I would report it to the admin.



Are you sure you want to delete this post?

mildredtabitha
Most forums have a verification needed to prevent bots from joining. I have also seen spammers getting banned from forums and their IP addresses getting blocked.



Are you sure you want to delete this post?

jaymish2
Its actually really easy to spot spam members because they are always plugging something. Most of their comments are irrelevant to what is being discussed and they have a link to their website or a website of a product they are trying to promote. I think that the moderators have to be strict. First have a clear and simple terms and conditions for the site. When spammers post something that does not help the site, warn them if they do not listen, ban them from the site.



Are you sure you want to delete this post?

Corzhens
The only rule in spamming that I know is the so called 2-hits which means you can forgive him for posting a spam although you have to do something with that post whether you delete it or save it in an invisible folder as evidence. When he repeats posting another spam then that is reason for sanction. By the way, I am talking about the forum. You can suspend that spamming member and inform him of his violation. That is the amicable way of settling the issue.



Are you sure you want to delete this post?

Order Now
Process Time: 0.41679406166077

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

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='24450'1SELECT 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='24450'

/opt/clerks-staging/docroot/viewfaq.php 496 () ()

SELECT * FROM seoclerks.members WHERE USERID='617864'1SELECT * FROM seoclerks.members WHERE USERID='617864'

/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

SELECT * FROM categories_faq WHERE CATID='42'1SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='42'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()

SELECT * FROM seoclerks.members WHERE USERID=6178641SELECT googleplus_profile FROM seoclerks.members WHERE USERID=617864

/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=24450 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=24450 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='24450' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT 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='24450' 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=135816 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135816 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=135494 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135494 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=135792 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135792 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=135501 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135501 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=135602 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135602 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=135883 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135883 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=135506 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135506 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=135512 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135512 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=135584 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135584 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=135818 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135818 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=135598 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135598 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=135620 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135620 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=135820 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135820 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=135624 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135624 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=135639 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135639 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=135671 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135671 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=135734 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135734 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=135810 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135810 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=135779 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135779 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=135848 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135848 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=135897 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135897 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=158867 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=158867 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=158883 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=158883 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=159007 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=159007 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=135911 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135911 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=135968 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=135968 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=136354 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=136354 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=143884 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=143884 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=146389 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=146389 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=164958 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=164958 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=175398 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=175398 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

UPDATE questions SET total_views = total_views + 1 WHERE quesid='24450'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='24450'

/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

SELECT * FROM questions WHERE quesid!='24450' AND status='1' AND (question like '%How deal spam members?%' OR question like '%deal%' OR question like '%spam%' OR question like '%members?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='24450' AND status='1' AND (question like '%How deal spam members?%' OR question like '%deal%' OR question like '%spam%' OR question like '%members?%') -- ORDER BY RAND() LIMIT 15

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM seoclerks.members WHERE USERID='17031' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='17031' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='18733' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='18733' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='43' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='43' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='840' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='840' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='3250' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3250' 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=24450%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=24450%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * 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='596028.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='596028.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='584702.jpg'1SELECT 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='599711.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='599711.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='584026.png'1SELECT 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='19821.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.png'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='624937.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='624937.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='617864.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='617864.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='589438.jpg'1SELECT 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='605129.jpg'1SELECT 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='600052.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='600052.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='275652.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='275652.png'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='601667.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='601667.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='322073.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='322073.png'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='614330.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='614330.png'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='585810.jpg'1SELECT 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='615678.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='615678.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='617077.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='617077.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='615139.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='615139.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='598910.jpg'1SELECT 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='634003.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='634003.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='600657.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

select * from categories_faq order by name asc1select * from categories_faq order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
0.4113681SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (90) AND gtags like'%Brusher%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4113680.411368
0.1055221SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%3Dvisualization%') ORDER BY total_recommendations desc LIMIT 0,400.1055220.105522