SEOClerks

Should people be allowed to advertise their services on the FAQ?



Write the reason you're deleting this FAQ

Should people be allowed to advertise their services on the FAQ?

Following on earlier from that guys thread asking how to advertise his service in the community discussion. Possibly because the forum has been removed now along with his thread that he used to advertise his service.

So would it be a good idea to let members get 1 cd post to advertise their services in the same way as they used to on the forum? They could have a new category for them not sure what you'd call it but it could have the same rules the old forum one did except it wouldn't get bumped and not sure what you'd call that category but yeah might make those users happy that had that option/benefit on the forum but don't anymore.

I know it's only really him and a couple other people that have asked about that now and possibly other people may ask in the future too. For those that used to use the member service advertisement category on the forum anyway.

- What do you think? Good idea? Bad idea?
- Would it defeat the purpose have having a valuable bank of content on the FAQ?
- Do you think it would have to be policed more than any other category?
- Would people try to abuse it?
- What could be the pros and cons of it?
- What about yourself as a seller, would you like this appreciate it?
- Would you use it responsibly?

My thinking is that this could PROMOTE usage of the FAQ and encourage people to visit it more.

The flip side is it could result in distracting what the FAQ is about? But they would all be in their own category anyway so not really?

Anyway, I'm just "throwing this out there" see who catches it. Should people be allowed to advertise their services on the FAQ?

What do you think?

Thoughts?

Comments

Please login or sign up to leave a comment

Join
EliteWriter
I do not think it is such a good idea. Just a few minutes ago I removed a post consisting of about ten words where a member, rather than explaining how to resolve a problem, simply said it could be done, and he would be able to help if he were contacted. That is just advertising, not helpful tips or guidance as is the intention of community discussions. If you want to advertise a service you have the marketplace and you can make use of bumps etc to stand out a bit more. Let us leave community discussions clean and free of promotion.



Are you sure you want to delete this post?

Lynne
Yes I totally agree here. I hate spam and I have been part of so many communities where thing suddenly go downhill. The rules have been set quite clearly already - this is a no spam discussion forum.

As soon as any sort of concession is made (like adding one thread for ads) then people will try and take the gap. It just makes it hard to know where to draw the line in future. Right now it is black and white, which leaves no room for any problems. No advertising or self promotion is allowed and this is great in my eyes.



Are you sure you want to delete this post?

EliteWriter
Yes I totally agree with you Lynne. Even the tiniest concession could turn out to be a disaster as many people will start to flood in with comments that have a sales pitch and that will totally ruin the whole idea behind having a community discussion. A discussion calls for insightful tips, advice, and informative topics, and has nothing to do with people trying to sell whatever they sell. That is the role of the marketplace and not the Community discussions.



Are you sure you want to delete this post?

Lynne
Yes exactly. I saw someone also suggested a classifieds section.. but isn't that exactly what the market place is anyway?

I do sympathize with buyers that are perhaps new and struggling to get themselves noticed... but as a buyer I want to spend time here in the discussion threads learning about SEO and discussing relevant topics. I will not find this area appealing at all if there are buyers trying to sell things to me. I will feel like a sheep being hunted by a pack of wolves LOL.

This space is amazing because there is no spam at all. Even if there was a classifieds thread I would never visit it. It would just become a place for all the buyers to send their ads to and I don't actually think buyers would bother with it... so what would be the point?



Are you sure you want to delete this post?

EliteWriter
Yes I feel that community discussions is a one of a kind place that is unique just the way it is and it should not be changed in any way. What was suggested in another comment, if I understood correctly, was that possibly there could be a section where sellers made a post/tutorial/article, whereby they share their knowledge and at the same time advertise their service. So it is sort of an advertising space which is at the same time valuable from a discussion/informational point of view. It would need to be heavily monitored though so as to see that really good posts are made and not only ads.



Are you sure you want to delete this post?

Lynne
That is different though because the seller is providing something of value to everyone and in return gaining exposure for that value.

At the same time though if a seller posted great tutorials here I would firstly make the assumption that they know a lot about the subject and most likely offer great services in that line. If I am interested in the tutorial I would most likely be interested in related services. Which would make me inclined to click through and have a look at the sellers profile and services anyway.

So maybe they should not be allowed to advertise there either. I can guarantee you that if they post good tutorials that sellers will check them out anyway.

I checked you out... Should people be allowed to advertise their services on the FAQ?



Are you sure you want to delete this post?

idealmike
That must have been an old forum thread for before the forum was migrated into the CD as all posts are moderated now before being approved.



Are you sure you want to delete this post?

Everett
So instead of posting on the community discussion, what about an area of the site that is not attached to the community discussions but rather called something like "Community Classifieds"? This could be a potential place to post ads, and make it use the user levels to indicate whom can post there.

For instance, we need to comment, or get orders, etc to get free bumps to bump our services, what would be a way we could get like "advertising slots" for a community classifieds? What would make users want to post their services to this classified?

Another thing is, is that it doesn't have to be an article, it can be a way to advertise their service in a hard to "get in" area, an area where only a select few, if they meet requirements. What is your opinions on this type of system? I'm not too entirely sure, it's just an idea branched off of the posts here.



Are you sure you want to delete this post?

idealmike
Hey that's not a bad idea actually. A separate part of the site called Community Classifieds or something. But use the same look and feel that the CD currently uses. I think the fact that it's an extra way to pull in users of the site and outsiders would be enough to make people use it. It could even have it's own categories for the different types of services there are like the Marketplace has now already. I think you're onto something Everett!



Are you sure you want to delete this post?

EliteWriter
That might not be a bad idea at all. Sometimes you find people who are looking for a particular service and they do not really filter through the marketplace to find a seller that they feel they can trust. Maybe in a community classifieds or something along those lines, you can get buyers recommending particular sellers too. It could be an area where sort of word of mouth advertising could work well for the benefit of all concerned.



Are you sure you want to delete this post?

Lynne
I'm not sure I agree with that. As a buyer I wouldn't be interested in a Community Classifieds section at all. The market place already has all the buyers and services listed... I get that buyers want to be noticed but I think the market place is sufficient. I wouldn't visit another section with services on offer when there is the market place.



Are you sure you want to delete this post?

Everett
I don't think sellers should be allowed to advertise their services on the community discussion. This part of the website is separate from the marketplace, and doesn't need users to go crazy with spam and post their service link in every post they create.

Having a new area within the community discussion to post service ads, to me, doesn't sound very great. It will eventually turn the community discussions into community classifieds, and this is what we don't want. The discussions are suppose to be a place where users, both sellers, and buyers have a place to communicate within the website. Having services advertised would result negatively because people would be more focused on the advertisements and spam than on actual quality content.



Are you sure you want to delete this post?

idealmike
Okay that's a fair point thanks Everett. I guess that could indeed happen and play out eventually and put more work on the staff that have to approve peoples faqs too. So even though it could promote faq usage (getting more people on the faq), the possible results make it something that shouldn't ever happen or be allowed? Even for the most esteemed and prominent sellers like yourself? Should people be allowed to advertise their services on the FAQ?

Or again, does that defeat the point of the FAQ and I'm missing the point of the FAQ like? You think the FAQ should be kept separate regadless?



Are you sure you want to delete this post?

Everett
Basically the idea of the community discussions, not FAQ is to have marketplace users discuss topics surrounding SEO, other website related things, and a bunch of other stuff as well. Having the community discussions opened up to service advertisements doesn't, to me, sound very appealing. It opens the flood gates to lethal spammers whom have nothing better to do than to spam their services, and turn the community discussions into a community classifieds. However, you could create a new discussion for a community classifieds section of some sorts, this hasn't been thought of yet ... i don't believe.

Now, im not saying no this isnt going to happen, i just know from past experience that this wont happen.. it only takes one user to spoil it for the rest. Should people be allowed to advertise their services on the FAQ?



Are you sure you want to delete this post?

hitmeasap
What do you think? Good idea? Bad idea?
I personally think it's a bad idea, but I wouldn't mind if users were allowed one advertising thread. And I bet some people would appreciate this a billion times, as they lost their option to advertise their services in a way like this when the old forum disappeared.

Would it defeat the purpose having a valuable bank of content on the FAQ?
No, not really, as these threads would be valuable too. At least for some people. (potential clients etc.)

Do you think it would have to be policed more than any other category?
I'm certain of it. I remember the old forum. People made 2-3 and even 4 or 5 new threads in the advertising section each day, as some people tend to believe they'll make more sales by having more advertising threads, within the same section....? Well, I don't know what kind of things circling around in peoples heads, but it's just.. Meh. I don't like the thought of 50 new topics each day.

Would people try to abuse it?
Most likely. (See Above).

What could be the pros and cons of it?
People might advertise their advertising threads too, and not just their services, which could bring more people to SEOClerks. That would be great and benefit us all, but I don't think they will. It seems that the majority of users on SEOClerks rely on SEOClerks traffic alone, and most of them doesn't do any kind of promotions at all, so I can't see why they would do it now.

What about yourself as a seller, would you appreciate it?
I actually wouldn't mind having such a category or such a topic myself, but I would be able to live without it too.

Would you use it responsibly?
Yes I would, but that's what 99% of the users would say too.


Best Regards,
hitmeasap



Are you sure you want to delete this post?

idealmike
Excellent feedback asap I'm glad you can see the good side of it and how some people might appreciate it. I get what you're saying as well though and that's a good point and something to consider. Could mean up to 100+ posts a day and be a lot of moderating when right now it's all about adding only quality content to the FAQ. I guess if that was to happen then it might dilute those efforts but that's why there would have to be filter control rules right from the start and reserve it for Level 3+ users only or something. Each one has to be x words minimum and completely unique. That way they could limit out any low quality stuff and only allow high quality sales page style services to be advertised. It would all be unique quality and look good and add value to the FAQ for outsiders as well. That's why we need to bang this out and flatten any kinks so to speak! But that's only if they decide on it or not.

So yeah I like what you're saying and it would have to be policed but with some filter rules from the start and going slowly could make it a valuable area of the faq possibly. Hey, if it all goes to pot what's the worst that could happen?



Are you sure you want to delete this post?

hitmeasap
You never know until you've tried it, so I'd put my vote on do it in this case. In worst case scenario, we'd get "spammed" with hundreds of posts and the staff would be the ultimate judge whether or not to approve the threads, so in that sense, the "spam" wouldn't hurt us in any more way than the workload for the staff, as none of the spammy looking ones would be approved..

With proper guidelines and rules regarding this, I can't see any problems with having a "trial period" at least.



Are you sure you want to delete this post?

anwebservices
We had that option on old forum and it was badly misused by many member, so i would simply vote: NO



Are you sure you want to delete this post?

idealmike
That is true although the forum was auto approve though wasn't it? So their threads would instantly be live. I'm talking about an exclusive faq for reserved users/sellers only with minimum posting rules so that each one was a high quality faq that had a unique spin on it but still a sales page overall for the outsiders.

If it was ever added I impose these basic filter control rules right from the start.

Must be a Level 3+ user minimum. Or even Level X users only?
Must be 1000 word minimum post.
Must contain unique images only.
Must not contain any external links?
Must link to the service it is for only.

Also make it so that if anyone chose that category but didn't meet some of these minimum requirements have it tell them that they cannot submit to that category unless they have x requirements in red text or something.

Otherwise people like Level 1 users and that would probably try and that and that would prevent their faq from being submitted. Unless people just saw that and decided to post it elsewhere but that's easy to spot. But if there was a lot that going on it would mean more time spent checking it was a genuine mistake or not idk.

I personally like the idea of making it exclusive to some sellers only. But let's just put this on the back burner for now then and see if many people request it or ask about advertising their services on the faq in the mean time. Should people be allowed to advertise their services on the FAQ?

Regards,

Mike.



Are you sure you want to delete this post?

MasterA
I also think this is a bad idea because it defeats the purpose of removing the forum and focusing on the FAQ. The FAQ should only provide high quality questions and resources. There are many other ways to advertise your services here such as bumping your service and buying featured services.

Allowing people to do this will result in people abusing it and this will create a lot of spam. As a seller, I would love the feature but I think it isn't worth it overall because in the past people have abused it in the forum. I think the costs would outweight the benefits.



Are you sure you want to delete this post?

idealmike
No no no. Should people be allowed to advertise their services on the FAQ? I'm not talking about a free-for-all smorgasbord of any man and his 3 legged dog being able to submit ads on the faq like "Hey guys check out my soundcloud service it gud"! I'm talking about real experts creating real valuable high quality content that discusses what they're selling, talks about problems that other people might have and then provide the solutions to those problems with their services. Plus having some filter rules in place from the start and some minimum requirements to be able to submit to it anyway. Thus making sure there are no rubbish thin content ads in that category. So with this in place, it couldn't be abused. I think the benefits would far far outweigh the costs. I do value your feedback but I think you're getting the wrong idea of what it would be like this time and thinking it would be like it was on the forum. I'm going to post something about it soon. Should people be allowed to advertise their services on the FAQ?



Are you sure you want to delete this post?

ajlancer
Hi idealmike thanks raise a sensitive issue. I personally do not believe, it will not good for community discussion. And you know all user are not working on same attention, and some of may make spam this section, they they got chance here like old forum. And service advisement not need alternate option in same SEOclerks, they can use into profile. We know that community discussion has became this new mode and sprit for SEO. And mostly we are discussing for several question and answer and for tutirial. So, it should be more helpful if, we are using only these intent. So, I do not appreciate any abuse activity on Community discussion which more possible, if your question will apply on CD.

Regards by Ajlancer



Are you sure you want to delete this post?

idealmike
Hi Aj thanks for chiming in. The forum used to be auto approve. They would make a thread and it would instantly be live on the forum. That can't happy with the FAQ as all threads need to be approved by admin first. That puts an instant stop to spam before it's able to get posted to the FAQ. You do make a good point though and this was only a suggestion to see what people would think about it. I've proposed some basic filter control rules that should be in place from the start like only allowing Level 3 or Level X users to submit. Making sure that they had 1000 words minimum and weren't just advertisements but rather some kind of article that presented people with a problem or some problems and then provided them with a solution at the bottom via their service. That way, that specific category for it wouldn't be riddled with rubbish advertisements for rubbish low quality services and only used for certain high quality services by certain high quality sellers/users only and be a valuable category with valuable faqs of unique content in them which would promote and encourage more people to use the FAQ both in terms of finding valuable information to discuss as well as some amazing services by hand picked sellers which in turn would encourage those big sellers to use the FAQ more and bring in people from the outside too.



Are you sure you want to delete this post?

Lynne
I wouldn't want to visit the forum if it is just spammed full of people trying to promote their services. I am loving the way it is right now. I am meeting new people and I am learning a lot. There are honestly so few spam free places online now and it was lovely to find this spam free space.



Are you sure you want to delete this post?

idealmike
Lynn I get your point and I agree. But I'm not talking about how it used to be on the forum. The forum used to be a free-for-all where anyone could create a service and it would be auto approved and be instantly live on the site. I'm talking about high quality service threads for esteemed, prestigious best sellers only. Like Level 3 or Level X sellers only. And also setting some filter control rules from the start like a minimum amount of words and all unique images and only high quality, good looking sells pages only. Plus it would be in it's own category and you could stop them from showing on the FAQ homepage as well.

After all, the idea behind the FAQ was to create a good quality bank of content and bring in people from the outside too. If they had their own category for it and it was moderated (as all submissions are) so that only high quality, good looking service advertisements got through only, it would mean that they wouldn't be low quality, spammy like threads and only be high quality threads that had actual value to them and increases sales on the site and also interest in the FAQ from the outsiders as well as, promote usage of the FAQ by those big sellers on the site that are big sellers right now but aren't using the FAQ right now. It would get them on the FAQ and using it more and also help to pull in new people from outside as well.

It would have to be more than just an advertisement of their services though. I propose that they take a different spin on it and come at it at a different angle to just advertising their service. But rather, place some kind of article about a problem and then provide the solution by way of their service. That way it would mean their FAQ wasn't just some cheap, low quality spam like thread the forum used to have and actually be a valuable thread in the FAQ that could have a lot of benefits both for sellers and outsiders to SEOClerks too. You see? Should people be allowed to advertise their services on the FAQ?



Are you sure you want to delete this post?

EliteWriter
Yes i get what you mean here. It could be a great addition I agree. It seems as if it is a bridging of the marketplace and the community discussions. It would add value to the site if the post/advert is informational, and at the same time it would be a good exposure for the seller, as long as he/she obviously makes a good job at writing the article/tutorial/advert. I believe that this is a very valid suggestion which could prove beneficial for all concerned - the site, the sellers, and the buyers who are trying to find reputable sellers.



Are you sure you want to delete this post?

Order Now
Process Time: 1.49418592453

Possible Duplicate queries found!
MatchCountSQLScript
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='17673'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='17673'

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=2721SELECT googleplus_profile FROM seoclerks.members WHERE USERID=272

/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=17673 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=17673 LIMIT 5

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='17673' 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='17673' 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=96474 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=96474 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=97550 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=97550 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=97555 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=97555 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=97563 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=97563 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=97565 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=97565 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=97569 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=97569 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=97572 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=97572 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=96575 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=96575 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=96581 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=96581 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=97557 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=97557 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=97564 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=97564 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=96446 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=96446 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=96452 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=96452 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=96478 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=96478 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=96447 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=96447 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=96456 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=96456 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=96460 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=96460 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=96448 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=96448 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=96461 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=96461 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=96468 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=96468 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=97562 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=97562 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=96509 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=96509 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=96554 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=96554 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=96540 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=96540 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=96549 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=96549 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=97560 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=97560 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='17673' AND status='1' AND (question like '%Should people allowed advertise services FAQ?%' OR question like '%Should%' OR question like '%people%' OR question like '%allowed%' OR question like '%advertise%' OR question like '%services%' OR question like '%FAQ?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='17673' AND status='1' AND (question like '%Should people allowed advertise services FAQ?%' OR question like '%Should%' OR question like '%people%' OR question like '%allowed%' OR question like '%advertise%' OR question like '%services%' OR question like '%FAQ?%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='957' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='957' 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=17673%' 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=17673%' 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='212316.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='212316.jpg'

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='4987.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='4987.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.0986181SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%scrappig%') ORDER BY total_recommendations desc LIMIT 0,400.0986180.098618
0.0960561SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%MarketingEmail%') ORDER BY total_recommendations desc LIMIT 0,400.0960560.096056