SEOClerks

Delayed Reviews for Services Rendered.



Write the reason you're deleting this FAQ

Delayed Reviews for Services Rendered.

I know I'm not alone on this but something needs to be set up to protect a buyer for services that take time to work.

For example SEO or other time sensitive guarantees stated by the vendors.

If a vendor on here tells me they guarantee me that I can have a website that will make me $xx to $xxx per month but it will take 1 to 3 months to see results then a review should be able to be held until their service produces results in that time frame.

That's right we should be able to reserve the right to write a negative review based on the actual results of the service and not just the procedure of the service.

For the laymen it is called a ROI  (RETURN ON INVESTMENT) after all if the vendor is guaranteeing such results then we should have something in place that holds him/her to that guarantee.

Even in my own local business I offer a 1 year warranty on craftsmanship,  guess what?  Never had a return call due to my craftsmanship.  That is because I do the job right the first time and never have to be called back to redo the job.

Comments

Please login or sign up to leave a comment

Join
amelia88
I definitely think that if someone is promising results, then you should be well within your rights to hold off on a review until you've had a chance to ascertain whether or not the product/service has worked in the way it was intended. After all, you can only know that it works/performs as expected when you've had a few weeks or months, depending on what was agreed to with the seller.

Being forced to provide a review earlier than that timeframe doesn't give you that opportunity to see how it performs.



Are you sure you want to delete this post?

Barida
Top SEO guys don't always promise results. They tell you what they think that is going to happen as long as you keep the faith with how everything is done. On that note, I think that anyone that promises results should not be given a review until it comes to pass.



Are you sure you want to delete this post?

imobileedge
Right and that is exactly what I'm saying is that if someone makes a promise or guarantees a certain outcome then a review should be held until it has been achieved. Its like a lock on a door is to keep people honest so would a review or at the very least they would refund your money or keep working until it achieves the guarantee they set forth not you.



Are you sure you want to delete this post?

jayjaydimson
Yeah that's right, top SEO guys can help us in our business t hat we have or that we are going to have in the future.



Are you sure you want to delete this post?

stbrians
You are right. One needs time to evaluate whether what they promised is clicking. I love it that way. Maybe this is why positive reviews take time.



Are you sure you want to delete this post?

jayjaydimson
Well, if you have a delayed review of the service that you rendered, the reader might get confused on the services that they are having.



Are you sure you want to delete this post?

imobileedge
Why would they get confused? I left a negative review because a vendor didn't do what they said they would do.



Are you sure you want to delete this post?

jayjaydimson
Well, that's how marketing strategy works, if the vendor tricked you that the product they are selling is really good then you have to give them a negative review right away so that they won't trick another people anymore.



Are you sure you want to delete this post?

Youngshark
Yeeeah, it is good to warn other people especially with numerous cons and liars out there. I think that one has to check the dealers carefully and their products before agreeing to review them.



Are you sure you want to delete this post?

stbrians
The review should never ever be delayed. To give a quick review actually saves much fuss



Are you sure you want to delete this post?

Martinsx1
Well, the truth is that you are definitely not going to do anything if the client never gives his reviews on your rendered services.

So, it's just something that you wake up to and overlook and move on to the next better client.



Are you sure you want to delete this post?

imobileedge
How did you discern that? It saves fussing? Well then explain why I'm here fussing about the fact I've left positive reviews for services that have a guarantee but still don't have results?

So that pretty much debunks your "saves much fuss"



Are you sure you want to delete this post?

jayjaydimson
Yes, I agree with you, so that you can notify the other customers about the product that they will be purchasing.



Are you sure you want to delete this post?

theresajane
This is the sad thing about earning online. People just want to earn and earn without considering what the clients or cutomers want for improvement. They know that they'll make money and be saved from negative reviews, so most of the time, they ignore threads like this.



Are you sure you want to delete this post?

Youngshark
True true and so very true my friend. A lot of times we might only get concerned about our part of the deal or work and we forget how our actions affect the other people. It is always important to consider this as every action or inaction has its consequences.



Are you sure you want to delete this post?

theresajane
I like the line "every action or inaction has it's consequences. It is very true and really hits everyone who can relate.



Are you sure you want to delete this post?

ajahcuizon
Sad truth. They think more of money rather than quality. They would only want to get things done in order to get paid without leaving a room for improvement. They don't know, they might be catching small fishes while there are a lot more bigger fishes in the sea they are just too lazy to pay focus on it.



Are you sure you want to delete this post?

stbrians
Money is the spice of life. All transaction end with the exchange of cash. Before this ritual is performed, the transaction is not over. After money exchange other things like reviews do not matter anymore. Yet it is reviews that guide us.



Are you sure you want to delete this post?

imobileedge
And that is not constructive at all!



Are you sure you want to delete this post?

Martinsx1
Some people will always be unappreciative of the good services they received by failing to give a good review on the service or products.

But when they received bad services, they would never waste time to open up their trap and fire bad reviews. Most people are just selfish.



Are you sure you want to delete this post?

imobileedge
First off you might want to rethink your position because you assume I care about feelings in this matter and all I care about is getting what I paid for and nothing less.

I have 3 businesses I operate locally in my city and the only 2 bad reviews I have is from 2 people who weren't my customers but it still didn't hurt my business.

If you think you should get a good merit for nothing think again!

I swing my hammer both ways and I leave a review on all my purchases in one way or another good or bad.

So don't lump me in with your customers because I'm sure I've never bought anything from you.



Are you sure you want to delete this post?

Martinsx1
Some people do get carried away or caught up and forget to give your business products and services the good reviews they required which are very important to your business.

It's nothing to fret about, just reach out to them and ask them politely to give their reviews in order to help your business.



Are you sure you want to delete this post?

Judas2018
As a buyer on SEOclerks, I understand that certain jobs or tasks take a particular amount of time. So I won't leave a bad review unless the seller isn't keeping me updated on the progress of my order. I don't expect for example, SEO work to be delivered in a week or two. But I do expect an update from time to time until the moment the results are expected to come flowing in. Total radio silence after a purchase is never good.



Are you sure you want to delete this post?

imobileedge
Then you get what I'm saying. Most of the vendors here are like bad contractors in your neighborhood who fly by night. They come in do a job or not do a job take the money and run.



Are you sure you want to delete this post?

Judas2018
Well so far in my experience here, I've gotten all of my work I paid for done. Not necessarily 'on time,' but still completed nonetheless. However, my advice would be to avoid certain services, especially ones that seem too fantastical or impossible to complete in the time allotted and through online or digital means.



Are you sure you want to delete this post?

imobileedge
Right, but this isn't an issue of the work being done as much as the guarantees being made. For instance I've paid for articles to be written and while they did claim to write the articles their other claim was they were not spun articles and that they would make sense when read.

But turns out that it was spun and using synonyms of words that you could tell was not a normal flow of conversation.



Are you sure you want to delete this post?

Barida
It is going to be difficult to judge SEO based on this. One thing that I have noticed is that it is not always easy for one to achieve a bigger success at a period of time just by calculating it and this is one reason we should always look at things from the other angle of not predicting success.



Are you sure you want to delete this post?

Kakashi2020
Vendors shouldn't promise a figure because there's no way to predict the results more so the actual profit or number of sales, therefore vendors shouldn't promise what they can't deliver. Unless it's clearly written and understood by both parties that nothing is guaranteed.



Are you sure you want to delete this post?

DenisP
I definitely agree with this. Not only is it a logical system but I’d say it’s damn near necessary. Logically, if you’re providing a service that can take up to three months to bear any fruit, the customer should have no right to review your service after only a month has gone by.

You would think that people would have the moral capacity to abide by this, almost as if it were an unwritten rule, but I suppose some people just lack that much sense or regard.



Are you sure you want to delete this post?

imobileedge
I think you contradict yourself. Are you saying that the customer has no right to leave a review after a month if the service takes more than that to bear fruit? If that is what you are saying then you're wrong. And I don't mind telling you how wrong you are.



Are you sure you want to delete this post?

burgosmichael24
We have to understand that reputation is not based on what we are going to do but on what we have already done. So, it is too early or too premature to give reviews for something that is not due. Maybe we can give our comments or compliments after a certain period of time to be fair.



Are you sure you want to delete this post?

imobileedge
Right at the very least let us add to our review as a side note so other can see the results of the guarantee being made.



Are you sure you want to delete this post?

ajahcuizon
When giving or making guarantees to a client, it is also like giving out promises that may be used as your own reflection. If you guarantee that a certain service give them results within a period of time, you should be able to provide it as it may give you negative reviews if you failed to do so. Sticking with your words will give your customers an impression that they can trust your words which is something that is really hard to earn.



Are you sure you want to delete this post?

Corzhens
The usual issue with a service provider is the expected results that even when there is a delay of one day, the client would already complain to high heavens. A transaction for service is a relationship that there should be understanding on both sides of the fence. When the client shows ignorance then the service provider should exhibit more patience and when the service provider is demanding then the client should understand the hectic schedule. Anyway, this issue may be about the review that I hope would end amicably.



Are you sure you want to delete this post?

agbuyarashel
Yes they should always deliver what they have promised because it's not free and clients are paying for their service, they deserve great services.



Are you sure you want to delete this post?

Order Now
Process Time: 0.2459089756012

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=3114681SELECT googleplus_profile FROM seoclerks.members WHERE USERID=311468

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='27334' 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='27334' 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=172260 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=172260 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=172458 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=172458 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=172462 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=172462 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=172737 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=172737 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=173184 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=173184 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=172113 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=172113 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=172191 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=172191 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=172430 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=172430 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=172795 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=172795 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=172137 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=172137 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=172167 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=172167 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=172192 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=172192 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=173073 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=173073 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=172138 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=172138 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=172158 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=172158 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=172471 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=172471 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=172822 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=172822 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=172141 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=172141 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=172193 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=172193 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=172164 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=172164 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=172196 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=172196 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=172161 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=172161 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=172188 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=172188 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=172194 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=172194 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=172227 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=172227 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=172265 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=172265 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=172457 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=172457 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=172678 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=172678 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=172776 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=172776 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=172829 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=172829 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=172789 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=172789 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=172830 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=172830 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=172817 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=172817 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=173976 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=173976 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=175507 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=175507 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='27334' AND status='1' AND (question like '%Delayed Reviews Services Rendered.%' OR question like '%Delayed%' OR question like '%Reviews%' OR question like '%Services%' OR question like '%Rendered.%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='27334' AND status='1' AND (question like '%Delayed Reviews Services Rendered.%' OR question like '%Delayed%' OR question like '%Reviews%' OR question like '%Services%' OR question like '%Rendered.%') -- ORDER BY RAND() LIMIT 15

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

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='208' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='208' 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='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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=27334%' 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=27334%' 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='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='311468.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='311468.jpg'

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

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

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

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

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

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

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

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

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

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

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