SEOClerks

Does adding ''GUARANTEE'' in service service settings grants more sales?



Write the reason you're deleting this FAQ

Does adding ''GUARANTEE'' in service service settings grants more sales?

Does adding ''guarantee'' when setting up or creating a service work in getting buyers more than others?. infact to be sincere, so buyers really check out for this guarantee of a thing when they want to order from a seller?
Also when a potential buyer is glancing through a service description, contemplating whether to buy the service or not, No notice of guarantee is stated in the description.
So most times i wonder if buyers are aware that even ''guarantee'' exists in the first place
In my opinion, i dont really think it is all that important; positive feedback is what i will look for if i were a buyer. but i wish to hear what you think about this?

Comments

Please login or sign up to leave a comment

Join
EliteWriter
The guarantee is, as the term itself implies, offering the buyer a guarantee that he can feel a bit safer when buying that service. So offering a guarantee is going to help buyers get a sense of trust in a seller, as the seller must be sure of what he is offering if he is willing to offer a guarantee. It can also improve the reputation of the seller. Having said that I never used the guarantee feature, and yet I still managed to build up a good reputation and get hundreds of sales. It was not something that I did intentionally actually, but just never thought about it until I got to know of it a couple of months ago from a discussion. So ultimately what really matters is offering a good service, but a guarantee can surely help.



Are you sure you want to delete this post?

Everett
Guarantees are sometimes a tricky thing. If you see a seller with a 1% guarantee than I would not recommend that you purchase the service. In the past, I had a 100% guarantee on my services thinking buyers would feel more safe, and secure. Bad buyers would buy the service, then invoke the guarantee for no apparent reason just to get free services.

If you're looking into adding a guarantee do 20% or even up to 50% depending on the type of service. I do not offer guarantees no longer due to previous abuse of the guarantee feature. I feel more safer as a seller to not use the guarantee feature.



Are you sure you want to delete this post?

idealmike
Yeah that's why I don't offer 100% guarantee with my services. I'd like to! But I've done that in the past and faced the same thing as you. After you deliver, some buyers invoke that full guarantee and get their money back and a free services to boot and you end up with nothing but your time and energy wasted and it's depressing lol. For that reason, I set my guarantee for most of my services to around 10%. Hey, let's not forget, they do have the option to reject the order if they have a good reason to do so. If the work was not delivered as advertised. Then they can reject it and get their money back if that's the case. I still offer it though to show my good and genuine side.



Are you sure you want to delete this post?

chetaseo
surely you are right in the sense that some bad buyers will use it to get thier cash back but even if one doesnt use guarantee in his service, he can still get lots of sales provided he has a good positive reviews and recommendations which are uppermost and paramount. And if he wants guarantee to be included, 20% maximum should be the thing but depending on the kind of service he is offering.



Are you sure you want to delete this post?

idealmike
Yes it has just happened to me last night! Some guy waited for me to provide the service then invoked my 100% guarantee and got a full refund. Even though he had ordered the service before and it was the exact same thing done for him which he left a positive rating for before! From now on, I'm making all my guarantees 10%. The guys name is sccmguy so if you get an order from him be careful!



Are you sure you want to delete this post?

Lynne
Yes Everett I would feel very nervous about putting a 100% guarantee on a service or even a very high percentage. The problem is that while most people are trustworthy and ethical there are a few people that just have no scruples and will screw you over.

I was wondering about adding guarantees on my services and I decided against it.



Are you sure you want to delete this post?

procoder
I would say that depends on the services that you're selling. Giving a guarantee to your buyers will make you look more trustworthy and I think that that having a guarantee enabled on your service can increase your sales as well. However, guarantee it's only one of many factors that people look before buying from you. I'm not using the guarantee feature for my services because with softwares it's a bit different, comparing to other services such as social services. Also the most important thing is that SEOClerks offers equal protection for all sellers and buyers.



Are you sure you want to delete this post?

hitmeasap
Hello chetaseo,
I would say that guarantees does have quite an impact on sales. And why? - First of all because potential buyers can search for guaranteed services only on the marketplace, like shown in the below screenshot:

Does adding


That alone will increase your chances of making sales, as you'll get more exposure by doing that. Even a 1% guarantee will make your service show up in that list, so there's actually a bunch of sellers having a guarantee at only 1%.

Secondly, a guarantee is something that makes any potential client feel more safe. Depending on what you guarantee you'll be able to get sales from both skeptical clients but also clients who's having second thoughts. Clients who can't decide which service they will buy so to speak. Those buyers will be more interested in a service that includes a guarantee rather than a service that doesn't offer any guarantees at all.

With all that being said, I would personally never set a guarantee below 20%. - Sellers who offers 1%, 2%, 5% or even 10% feels way to greedy and I don't like to work with people like that. A guarantee that offers at least 20% is way more professional in my opinion and that's also why most freelancers are using their "30 day money back guarantees" when you're buying ebooks online for instance. Most people don't ask for their money back, even if and when they can, so a 100% money back guarantee wouldn't hurt you in the long run as a seller. Also, a money back guarantee with higher %, compared to 1%, 5% etc, looks better and it will give a potential buyer the feel of you being certain. You know what you deliver, you deliver high quality and you are satisfied with your own services you deliver. - That's the feeling a potential client would love to get when viewing your service description. - And that feeling is easy to give a potential client just by guarantee that they will get exactly what you've stated within the service description. - And if you don't deliver, they'll have nothing to lose as they will get their money back. Or a percentage of it.

So yes, I would definitely say that it will help you to increase the number of sales.


Best Regards,
hitmeasap



Are you sure you want to delete this post?

chetaseo
Good writeup but do about 80% of potential buyers check for guarantee before they place an order on a service?. i dont think so. Also dont you think that some will exploit this 100% guarantee to get thier money back after delivering a service that cannot be reversible? with respect to this, you cannot blame those that offer 10% or 5% or even 1% money back guarantee.
but if i may ask, which level of guarantee with you give to your service? are you going to give 100% money back guarantee or what?



Are you sure you want to delete this post?

hitmeasap
No, I wouldn't say that 80% of potential buyers are checking for guarantees before they order anything. Heck, it might even be as low as 1% of potential buyers who does that, but that's exactly my point. Even if it's only 1% of potential buyers who's interested in buying guaranteed only services, then you'll increase your chances of making sales to that 1%. Which all in all, increase your chances of making more money, as long as you offer some sort of guarantee. Even as low as 1%.

Scammers, fraudsters and greedy people will always be around online. People will always look for dirt-cheap services and even if they pay just $1 for something, some people will always try to get that $1 back from you, no matter what you say, do or deliver. Guarantee or not. Sure, if you offer a 100% money back guarantee, then you'll lose 100% of your earnings when these people come along. Fortunately, most people are still professional, humble and kind, so most people won't try to get their money back.

However, to decrease your loss and still be able to offer a guarantee to increase your chances of making sales, I'd set my guarantees at 20%-25% at least. But that obviously depend on what kind of service you have too. If you still profit with a guarantee of 50%, then you should obviously go for it. The most important thing here, in my personal opinion, is to cut your profits as much as possible, and offer a money back guarantee as high as possible, but still low enough to profit, even if it's just a few cents. - The bottom line is that a higher guarantee will be more interesting than a low guarantee.

Just take a look at BarryinSiam's service for instance. He offers a guarantee of 70% and that's totally manual work. 25 days delivery time basically means that they put in tons of effort into the services, and a lot of work.. And he still guarantee 70% of the money back. - Doesn't that look awesome and trustworthy?



Are you sure you want to delete this post?

chetaseo
ok alright,.i think going for 20% guarantee is very much ideal and okay for any seller that wants to put it ideally. thanks for your response so far for i have gained alot from it.



Are you sure you want to delete this post?

Lynne
It is nice to see a guarantee on some services yes, it does make me feel a bit safer especially if it is a pricey service.

Thanks Andre, I just learned something new, I wasn't aware that you can search for services based on guarantee. I can see how this would make your service more visible and result in a lot more views and possibly a lot more orders too.



Are you sure you want to delete this post?

hitmeasap
Thank you Lynne for proving my point. You are a buyer and you said it yourself. You feel a bit safer in case someone offers a guarantee. It's easier to order a service as long as they have a money back guarantee, but you wouldn't care about a guarantee if you got 1% of your money back. In that case, you'd stay away from that service and buy another one that offers a higher money back percentage. Right?



Are you sure you want to delete this post?

Lynne
LOL Andre well 1% back is not much of a guarantee is it? That just tells me that the seller can do a shitty job and then give me back 1% keeping the other 99%. Seems like a nice way for a dodgy seller to make some easy money giving back 1% without any questions asked right?



Are you sure you want to delete this post?

hitmeasap
Indeed it does! - Unfortunately, some sellers offers a guarantee, and they offer 1% money back only to be able to be seen under the "guaranteed only" filter. A minimum guarantee of something more reasonable would be good to implement in my opinion. As it is right now, it's kind of exploiting for more advertising without risking more than a cent or two. However, it's not a huge deal or so, but I still think that it would be for the greater good to set a minimum guarantee percentage.



Are you sure you want to delete this post?

idealmike
Having a guarantee doesn't grant more sales but it still can get you more sales. If that makes sense? Because some people do indeed search by "guaranteed only" and if you don't have a guarantee set in your service. Even if it's only 1%, your service wont show up in that search result for them. However, people cannot search by how much the guarantee is. I think we've had that discussion on here before or it might have been a feature suggestion perhaps? I can't quite remember but I think some people were saying they'd like to be able to search and sort by how much the guarantee is. Perhaps that could be added as an official feature suggestion by yourself, or anyone that would like it. Have it like a slider like the current price slider there already is so you could search for services that have a guarantee of say 50% or somerthing.

But alas, it's not essential, as of course, you go by the amount of positive ratings and recommendations that people have. And of course, you have the option to reject a sellers delivered work if it's not delivered as advertised so you have that protection system in place as well.



Are you sure you want to delete this post?

hitmeasap
I totally agree with you Mike. The most important things will always be feedbacks and recommendations, but you could potentially miss out on sales due to a non-existing guarantee. Which is why I'd recommend everyone to have one. - That said, I also think a minimum guarantee percentage should be in place, so people won't be able to offer 1% money back.. Because seriously, that's not even a guarantee.



Are you sure you want to delete this post?

MusicMoguls
Sometimes we have new sellers that are not aware of positive feedbacks being enough. Some buyers don't care if the seller is flawless just because it worked for everyone else does not mean its going to work for you. If you have no guarantee the buyer may be scared of exactly what i just mentioned. I always think of a guarantee as a plan B or a safety net. If a seller is willing to give you a guarantee on his service is shows that he is serious about your satisfaction. If i am looking at 2 identical services from 2 different sellers same amount of positive feedbacks roughly. One has a guarantee one does not. Which one will you choose?



Are you sure you want to delete this post?

Cristian
The guarantee feature used to be a lot more visible in the past here on SEOclerks, I think the Admin decided that it isn't really a factor that should stand out a lot, for both sellers and buyers because both parties found ways to abuse somehow this feature.

On the other hand, I remember my experience with the guarantee feature and it was good, I actually think I got more orders because of this option, few people ever triggered the guarantee and when they did both me and the seller were happy with what we got.
I never offered a 100% guarantee though.



Are you sure you want to delete this post?

Barida
One good thing that I've come to realize is that guarantees are ways that buyers are assured of the good quality of the products that they are buying and that's the best way any freelancer should go about their duties. I always give a guarantee to products that I sell for it is a way to prove that I can do the work without any fear of doing a bad work.



Are you sure you want to delete this post?

Order Now
Process Time: 1.1945269107819

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='20337'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='20337'

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=1987911SELECT googleplus_profile FROM seoclerks.members WHERE USERID=198791

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='20337' 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='20337' 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=110809 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=110809 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=110815 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=110815 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=110821 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=110821 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=110829 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=110829 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=110885 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=110885 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=110838 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=110838 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=110834 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=110834 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=110787 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=110787 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=110798 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=110798 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=110799 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=110799 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=110803 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=110803 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=110795 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=110795 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=110800 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=110800 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=110806 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=110806 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=110856 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=110856 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=110822 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=110822 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=110857 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=110857 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=110849 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=110849 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=110955 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=110955 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=138528 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=138528 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='20337' AND status='1' AND (question like '%Does adding \'\'GUARANTEE\'\' gig service settings grants sales?%' OR question like '%Does%' OR question like '%adding%' OR question like '%\'\'GUARANTEE\'\'%' OR question like '%service%' OR question like '%settings%' OR question like '%grants%' OR question like '%sales?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='20337' AND status='1' AND (question like '%Does adding \'\'GUARANTEE\'\' gig service settings grants sales?%' OR question like '%Does%' OR question like '%adding%' OR question like '%\'\'GUARANTEE\'\'%' OR question like '%service%' OR question like '%settings%' OR question like '%grants%' OR question like '%sales?%') -- ORDER BY RAND() LIMIT 15

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

SELECT * FROM seoclerks.members WHERE USERID='1323' limit 11SELECT 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='9' limit 11SELECT 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 seoclerks.members WHERE USERID='750' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='750' limit 1

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='632' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='632' 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=20337%' 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=20337%' 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='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='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='198791.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='198791.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='377074.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='377074.png'

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

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

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

/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 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