SEOClerks

Few Tips to get happy & returning buyers



Write the reason you're deleting this FAQ

Few Tips to get happy & returning buyers

Today I was going over this forum regarding tips and tricks so I thought to share my little experience as well regarding happy and regular buyers.

I think it depends upon how you treat your buyer . I got many returning buyers some of them just blindly trust me and some of them even pay me 10-15 days early and want there job after 15 days . So here is what I do may be you will find these few tips helpful Few Tips to get happy & returning buyers

  • First of all always check buyer history . When I get order I always check buyer history where they buy from and if they are selling as well and all also there rating . After getting a little background check on buyer you start giving him service other than he is already buying from someone else. Tell them about your service don't give him straight comparison with any other seller . Just you have to keep in mind what he has purchased previously and how can I interest him in my service more .
  • Always give him more than what he is already buying .
  • Now show him your work portfolio and also gain his interest by showing some of your other services related to that so that buyer will understand that you are not a newbie you are experienced in what you are selling .
  • Then suppose if buyer is buying a seo service from you when He order other than just giving him your service also give him few tips so he can understand little more about seo . ( Trust me if buyer gets little information and tips from you he will automatically get emotionally linked with you and will surely come back ) I have been practising this for 9 months and I always give good tips to my buyers and they love me for that and always return to me even some of them ask me about other sellers as well because of this trust .
  • Always be friendly with him all people like to be treated politely and nicely . I am not saying go unprofessional with them but as you can see all leaders and all professionals also have a very good communication skills so this is the key point for trust gaining.
  • After delivery keep a check on delivered service and remain in contact with him through pm and keep him updated about results and next updates sometimes they wont reply but always do this .
  • Always show them your buyer reviews ( Example : I created a thread here on advertisement after delivery I always ask my buyer to visit this thread and share there experience . I know He has already completed the order but the review here on thread is like the best portfolio of your work trust me ) when I show my thread to my new buyers they just blindly trust me and purchase my service after that they always contact me . You guys can checkout my thread regarding youtube services as a reference which I made you will see buyer reviews as well . Its like my portfolio .
  • After the delivery always give some compliments about his work ( Example : If he ordered for website then say I really loved your website , If its a video then say I really like your effort on your video ) This will for sure get your buyer stick to you forever as he will see your sincerity toward his project Few Tips to get happy & returning buyers

These are the few of my practices which I found very effective in returning buyers .I hope you will also practice this and will get good results and returning buyers Few Tips to get happy & returning buyers

I would love to see your participation and your suggestions on this tutorial Few Tips to get happy & returning buyers

Regards
Farah khan

Comments

Please login or sign up to leave a comment

Join
WebMania
I always share some tips as you said.
And I really like your second last point & gonna try this for sure because I thing this will work 100%.



Are you sure you want to delete this post?

shahzaib12
I really loved this tutorial Farah you always help all the members so much I really like the tips you provided I will try these out and I am sure I will get the best results out of them .



Are you sure you want to delete this post?

Topseoservice
Yes all the tips you provided is very useful. Sellers can take their SeoClerks journey to next level using those.



Are you sure you want to delete this post?

anwebservices
Very useful. I use most of this methods too. But i am just curious how you check buyer's history of buying?? I had this on my mind and it would be useful, i just don't know how's that possible, or where??



Are you sure you want to delete this post?

farahkhan
Very useful. I use most of this methods too. But i am just curious how you check buyer's history of buying?? I had this on my mind and it would be useful, i just don't know how's that possible, or where??

Yes Anweb you are right about this We cannot check it directly but sometimes buyers also got recommendation as I always recommend my good buyers so by recommendation you can check there history but not all the time only where there are recommendations for him Few Tips to get happy & returning buyers



Are you sure you want to delete this post?

Kashif4k
Great tips Farah. I like the idea of checking buyer's history as this will give you some indication about the type of buyer.

Also I do feel that sellers who have just started have to work extra hard to convince the buyer and this is where many other buyers try to take advantage of them by requesting free samples and then selling it to others.



Are you sure you want to delete this post?

farahkhan
Great tips Farah. I like the idea of checking buyer's history as this will give you some indication about the type of buyer.

Also I do feel that sellers who have just started have to work extra hard to convince the buyer and this is where many other buyers try to take advantage of them by requesting free samples and then selling it to others.

Yes I know new sellers got scammed by many fake buyers . Thats why I shared these few tips so new sellers always choose right buyer to work with Few Tips to get happy & returning buyers



Are you sure you want to delete this post?

Narayanram
Yes Farah, Very useful tips, love to read, you have shared the really amazing ideas, I have just started the Gig with SEOCLERK, will keep in mind these all the things.



Are you sure you want to delete this post?

zimaseo
Thanks farahkhan your tips really useful I will use in future 100%



Are you sure you want to delete this post?

femstic60
You gave a very good Tips, but many seller need to read this for them to make a change. Thanks



Are you sure you want to delete this post?

dennyfar
Thank you very much, and I got return buyer manually with get-in-touch with them via facebook chat.



Are you sure you want to delete this post?

shohelrana01
very nice tutorial.thank you ,
Farah khan



Are you sure you want to delete this post?

ThenukaZ
thanks you for sharing some tips



Are you sure you want to delete this post?

dragonhunter95
nice set of tips. I am following most of these :-)



Are you sure you want to delete this post?

seoflash
This is really interesting.Will add up the practice



Are you sure you want to delete this post?

jameel
super tutorial, i really like this tutorial.This is very helpful to me.



Are you sure you want to delete this post?

lubabaseo
Great!! We're not stuck in the old thing anymore. Thank you



Are you sure you want to delete this post?

plansmm
Very good piece. very informative for beginners.



Are you sure you want to delete this post?

WinnersPBN
Unfortunately, some people only know how to do the talky-talky not the walky-walky.



Are you sure you want to delete this post?

dragonhunter95
Actually a great tutorial. thank you for sharing your experience. I don't have anything to add here.



Are you sure you want to delete this post?

salesboost
Awesome tips.. this would help a lot....



Are you sure you want to delete this post?

SeoFriend2305
you always post better then other community member. so that we achive more from the buyer. thanks dear mam for your nice and suggest post for us.

kind regards
seofriend2305



Are you sure you want to delete this post?

salesboost
In this heading, I've noticed a decline in the number of new orders coming in lately. I mean my old buyers are the ones that's been coming back to order and that owes to quality service and good communication I believe.

Sure if ure experiencing same, you'll agree



Are you sure you want to delete this post?

WebMania
In this heading, I've noticed a decline in the number of new orders coming in lately. I mean my old buyers are the ones that's been coming back to order and that owes to quality service and good communication I believe.

Sure if ure experiencing same, you'll agree

Yes this is happening to all of us, I think



Are you sure you want to delete this post?

WebMania
https://www.seoclerks.com/twitter/...le-Non-drop-Only

Please don't share your service link in this forum.
Go here to promote your service links: https://www.seoclerks.com/forum/fo...ks-services.116/



Are you sure you want to delete this post?

WebMania
thank a lot Webmania.

No need of thanks. We all are just like a family so we should help each other.



Are you sure you want to delete this post?

SeoFriend2305
No need of thanks. We all are just like a family so we should help each other.


yes, that is 100% true. i like your word friend.



Are you sure you want to delete this post?

WebMania
yes, that is 100% true. i like your word friend.

Just do one thing, Be ready to help others.



Are you sure you want to delete this post?

Narayanram
Great tips, I am already following these all, Few may not Farah khan Appreciate your great tips sure will follow.



Are you sure you want to delete this post?

CPAStdnt
Enjoyed while reading the post. Very helpful and informative. Thank you

Regards,
CPAStdnt



Are you sure you want to delete this post?

bestpromotion24
Its important that you are nice to your Buyers
try to give bonus when possible so they get more then they expect



Are you sure you want to delete this post?

pegasoftcorp
I really loved this tutorial Few Tips to get happy & returning buyers



Are you sure you want to delete this post?

pingseo
Great tips ! Thank you



Are you sure you want to delete this post?

WebMania
Just do one thing, Be ready to help others.

Ever ready to help others



Are you sure you want to delete this post?

sanfora
offer good service that repeatable and they will return



Are you sure you want to delete this post?

gigmom
Its really practically true tips to gain a buyer as permanent. Thanks for sharing your tips. I also impressed my buyer to keep order always continue as following;
* When buyer pm me before order, I give them free analysis of website and help him to order right service for his website. If you do this, buyer will be really impressed and satisfied about your effort and experienced.
* I always provide some bonus work for my each order that liked most of people to get some extraFew Tips to get happy & returning buyers
* I try to provide best price with high quality services to my buyer.
* Yes, I provide to my buyer great suggestion about their website.

Thanks
Regards
Gigmom



Are you sure you want to delete this post?

seoconsul
Certaily goodtips, Clear Communication from Adlisting to Order placement to taskcompletion etc. is very important.


With regards,



Are you sure you want to delete this post?

sanfora
some buyers here never satisfied no matter what you do the best way to avoid them



Are you sure you want to delete this post?

it4next
this is really very good tips from farahkhan and try to apply this tips to returning my buyer. thank you



Are you sure you want to delete this post?

Order Now
Process Time: 1.6218750476837

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

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

SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='12116'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='12116'

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=2103781SELECT googleplus_profile FROM seoclerks.members WHERE USERID=210378

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12116' 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='12116' 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=56466 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=56466 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=56406 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=56406 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=56407 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=56407 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=56408 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=56408 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=56409 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=56409 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=56410 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=56410 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=56411 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=56411 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=56427 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=56427 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=56435 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=56435 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=56436 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=56436 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=56438 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=56438 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=56441 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=56441 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=56445 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=56445 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=56446 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=56446 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=56448 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=56448 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=56451 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=56451 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=56452 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=56452 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=56453 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=56453 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=56458 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=56458 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=56461 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=56461 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=56462 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=56462 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=56465 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=56465 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=56469 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=56469 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=56470 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=56470 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=56472 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=56472 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=56475 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=56475 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=56476 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=56476 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=56477 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=56477 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=56483 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=56483 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=56484 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=56484 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=56486 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=56486 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=56487 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=56487 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=56488 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=56488 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=56489 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=56489 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=56490 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=56490 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=56492 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=56492 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=56494 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=56494 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=56495 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=56495 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=56497 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=56497 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='12116' AND status='1' AND (question like '%Few Tips happy & returning buyers%' OR question like '%Tips%' OR question like '%happy%' OR question like '%&%' OR question like '%returning%' OR question like '%buyers%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='12116' AND status='1' AND (question like '%Few Tips happy & returning buyers%' OR question like '%Tips%' OR question like '%happy%' OR question like '%&%' OR question like '%returning%' OR question like '%buyers%') -- ORDER BY RAND() LIMIT 15

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='3764' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3764' 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 seoclerks.members WHERE USERID='10775' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='10775' 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=12116%' 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=12116%' 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='306906.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='306906.png'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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