SEOClerks

What next? (for more free money)



Write the reason you're deleting this FAQ

What next? (for more free money)

The last two free promos were a great success (except for the Videos, those did not work very well at all). Now the question becomes, what would you like to do for free money now?

  1. Affiliate Contest? 1 month, 1st place winning $500 withdrawable
  2. Altered version of the last two promos (removing what didn't work and reducing the prices earned)
  3. Any other ideas?

Comments

Please login or sign up to leave a comment

Join
atilayax
Hi Jordan,

You might give some money to those who can rank Gigs for certain profitable keywords similar to what you are doing in the staff selected section. Money might vary according to the keyword monthly global/local searches. What next? (for more free money)

Jordan, do you provide Adsense Id for Gigs?

Regards



Are you sure you want to delete this post?

thebestservice
LOGO DESIGN CONTEST



Are you sure you want to delete this post?

GeeOne
The last two free promos were a great success (except for the Videos, those did not work very well at all). Now the question becomes, what would you like to do for free money now?

  1. Affiliate Contest? 1 month, 1st place winning $500 withdrawable
  2. Altered version of the last two promos (removing what didn't work and reducing the prices earned)
  3. Any other ideas?




How about SEO contest?

G!



Are you sure you want to delete this post?

fmfame
Altered version of the last two promos.it was the best.



Are you sure you want to delete this post?

sohails
Hello Jordan,

According to me, i think 2nd one would be best for all sellers and buyers too. As both can easily promote seoclerks and make some money.

I don't vote for 1st option as this would be helpful only for sellers as buyers can't participate in affiliate contest. Yeah most of the seoclerks members are buyers i think..


Vote for "Altered version of the last two promos (removing what didn't work and reducing the prices earned)"
Apart from the above points, i believe blog reviews would be a great option for more free money as i can see most of my social network friends are not aware of seoclerks, perhaps i recommended seoclerks to most of my friends. So i will be waiting for next more money contest.

Thanks



Are you sure you want to delete this post?

abdullahzahid
Altered Version.



Are you sure you want to delete this post?

follows4all
can there be a twitter promotion option again?



Are you sure you want to delete this post?

cyberxcrime
Top Seller Contest.....Who Earn highest in a month that win Level X membership and Winning Price. What next? (for more free money)



Are you sure you want to delete this post?

midouloumi
Post on forums



Are you sure you want to delete this post?

scrubtheweb
I have an idea may be it's good
add a free section, where we can promote some free offers or we can call them 'test offers' to let people try some offers like 'twitter followers/retweets,facebook likes, backlinks offers.....'
and you pay 'let's say 2$' for every offer
"free section will be only for old members 1 months+ to be sure that theire is no cheating"



Are you sure you want to delete this post?

ajlancer
I think best seller and best buyer contest can better contest idea
Thanks



Are you sure you want to delete this post?

ajlancer
Hi Jordan I would like to give you an idea. I think user last log in time should add. Not date only. I think time for example: he/user last log in/activity 2 or 20 minutes ago etc. I think buyer will feel more confidence for buying services from those current activator.

And another Idea: You can add account verify system. It could be phone or document verification system. And verified account will show as symbol on profile.

Thanks



Are you sure you want to delete this post?

zooel
I don't think about 2nd option i think the 1st one was the best.why jordan you don't try that again?
Thanks.



Are you sure you want to delete this post?

ShadyX
2. I would go with Altered version of the last two promos

Altered version of the last two promos.it was the best.

Hello Jordan,

According to me, i think 2nd one would be best for all sellers and buyers too. As both can easily promote seoclerks and make some money.

Altered Version.

Post on forums


I agree with these guys, My vote also goes for an altered version of the last promo What next? (for more free money)



Are you sure you want to delete this post?

hitmeasap
First of all, I'd like to thank you for this promos. They're amazing.
Second I would like to know what part's didn't work out. What do you mean by that? I understand that these promos costs a lot of money and I'd be looking for more traffic if I where having promos like this, and if that's the case, you mean that videos didn't get you more traffic, or do you mean that people didn't made any videos?

My suggestions is that you have the 2nd promo again, altered as you said. But I actually think that you could have the first one again, the affiliate contest, but I would decrease the prize money and shorten the actual time on this promo.

Those two together would be the best idea imho, and SEOClerks would get the most out those.

Well, just a thought.



Are you sure you want to delete this post?

SEOExpert
I think seoclerks should take 10% - 15% of all the orders above $100-$150....Likes I got an order of $500 but $100 was gone in fee! I think that's too much so 10% - 15% will be really good for orders above $100-$150!



Are you sure you want to delete this post?

midouloumi
FORUMS THREADS



Are you sure you want to delete this post?

robertman11
I think seoclerks should take 10% - 15% of all the orders above $100-$150....Likes I got an order of $500 but $100 was gone in fee! I think that's too much so 10% - 15% will be really good for orders above $100-$150!


You do not take into consideration the fees. They pay for buyers and sellers which both have a fee.

Also, this isn't a promo idea, it is just you wanting more money. You wouldn't have gotten the 500 dollar order if seoclerks hadn't provided a safe environment for buyers... And the buyer.



Are you sure you want to delete this post?

vinothmech
I think a photo contest on Facebook!! I also prefer Video Designing contest. Looking forward to you Jordan.



Are you sure you want to delete this post?

midouloumi
Hello Jordan ^.^ When The next ( free money ) will be annonced ?



Are you sure you want to delete this post?

spencedee
The last two free promos were a great success (except for the Videos, those did not work very well at all). Now the question becomes, what would you like to do for free money now?

  1. Affiliate Contest? 1 month, 1st place winning $500 withdrawable
  2. Altered version of the last two promos (removing what didn't work and reducing the prices earned)
  3. Any other ideas?



wow!! this is Cool I want to Participate! What next? (for more free money)



Are you sure you want to delete this post?

thuraoo
I agree with these guys, My vote also goes for an altered version of the last promo What next? (for more free money)


Altered Version



Are you sure you want to delete this post?

thuraoo
The last two free promos were a great success (except for the Videos, those did not work very well at all). Now the question becomes, what would you like to do for free money now?

  1. Affiliate Contest? 1 month, 1st place winning $500 withdrawable
  2. Altered version of the last two promos (removing what didn't work and reducing the prices earned)
  3. Any other ideas?


Altered version of the last two promos remove what didn't work and reduce the prices that were earned





Are you sure you want to delete this post?

SEOExpert
You do not take into consideration the fees. They pay for buyers and sellers which both have a fee.

Also, this isn't a promo idea, it is just you wanting more money. You wouldn't have gotten the 500 dollar order if seoclerks hadn't provided a safe environment for buyers... And the buyer.


Ah! I see...
that's alright...Never Mind! What next? (for more free money)

btw, are u Dillon?



Are you sure you want to delete this post?

seoflash
can there be a contest for the most disciplined seller.....

some one who obeys all the rules, delivers quality job on time and rated by his buyers



Are you sure you want to delete this post?

seozeehan
my vote goes to option no 2. alter the last two promo. What next? (for more free money)



Are you sure you want to delete this post?

robertman11
can there be a contest for the most disciplined seller.....

some one who obeys all the rules, delivers quality job on time and rated by his buyers

How would you rate the sellers? What if 5 follow all the rules, who would win?



Are you sure you want to delete this post?

robertman11
Ah! I see...
that's alright...Never Mind! What next? (for more free money)

btw, are u Dillon?


No, Dillon is Karoshio.



Are you sure you want to delete this post?

Tommy Matalino
I go with the 2nd option. Altered version of the past contests.
It's best to remove ones that didn't work and replace with new ones

LOGO DESIGN CONTEST

SEOClerks already got a nice logo so I doubt that one will go.



Are you sure you want to delete this post?

exjordanary
Well, the one good thing about another Affiliate Contest is, you can incorporate ALL these ideas -

a) A revision of the old promo - duh..The Threads have already been started!! So start interacting on those Threads and promote your Affiliate Links!! Or the "Revision of the Promo" could be to go "Bump", "Like", "Rep", "Donate", and interact on the Threads from the first promo.

b) I saw a couple people mentioning Graphic or Image contests - YES. SEOClerks NEEDS more "Promotional Resources" since the ones that exist get a 0.10% CTR AT BEST!!! So people would submit ANY Standard Sized Graphic, we Split test the Select Few in Concurrent Ad Campaigns, then the ones that get the highest CTR% either wins more Affiliates or whatever - depending. - and SEOClerks gets better Banners!! (see SEOClerks "Banners for Benefits" HERE)

c) Videos - Essential. The more Videos SEOClerks has on Youtube, the better. Period. They can be 30 seconds with a logo, some music, and an affiliate link. I plan to make a Tutorial showing people how to add a "Call-to-Action" to their Videos so they can include their affiliate links in them such as THIS VIDEO - and it may also be a good idea to have all the people that do Youtube Services to "Bump" - promote, add likes, views, etc - to all existing Videos on Youtube (trust me, Youtube CONVERTS - I didn't Win 2nd Place last contest cuz I don't know what I'm talking bout- HERE'S PROOF)

d) User Generated Affiliate Coupon Codes - A Seller can basically BUY A Coupon Code which will act as a Gift Certificate with their Affiliate Link in it too. So they can choose to invest however much they wish. Even Gift them on Facebook!

e) I like the "Best Seller" idea - Kinda like "Seller of the Month Award" - or "Most Improved" - Why not have a "Level Up" Theme throughout the whole contest? Bump up old Forum Posts, Promote Existing Videos, etc - Let's just bump up what's already out there!

f) Maybe throw a bone or two to people who also promote SocialClerks, CommunityClerks, CodeClerks, etc..


Alright, I'm tired of listening to myself...time for me to shutup...
What next? (for more free money)
-J



Are you sure you want to delete this post?

Tommy Matalino
First of all, I'd like to thank you for this promos. They're amazing.
Second I would like to know what part's didn't work out. What do you mean by that? I understand that these promos costs a lot of money and I'd be looking for more traffic if I where having promos like this, and if that's the case, you mean that videos didn't get you more traffic, or do you mean that people didn't made any videos?

From what I see from Jordan's post, it seems that videos doesn't give off traffic or views that could help SEOClerks.



Are you sure you want to delete this post?

redmunds
What went wrong with the videos? I would love to try making one for SEOClerks



Are you sure you want to delete this post?

elfwaigo
you should do the video again What next? (for more free money)



Are you sure you want to delete this post?

exjordanary
Jordan, big time is passed, will you start something soon?! My suggestion is that you give 1$ in promo money for every free referral that sign up to your site through member affiliate link.



You know how may many would cheat that system??? Let's just say more dollars would be lost to fraud, than to the promo



Are you sure you want to delete this post?

Tommy Matalino
What went wrong with the videos? I would love to try making one for SEOClerks

I'm pretty sure that the previously submitted videos doesn't give off traffic.

Jordan, big time is passed, will you start something soon?! My suggestion is that you give 1$ in promo money for every free referral that sign up to your site through member affiliate link.

What exjordanary said is true. It's the easiest contest method that one could cheat. And even though there are ways to prevent this, there are also much more ways to cheat the system.



Are you sure you want to delete this post?

mike719
Hi Jordan I would like to give you an idea. I think user last log in time should add. Not date only. I think time for example: he/user last log in/activity 2 or 20 minutes ago etc. I think buyer will feel more confidence for buying services from those current activator.

And another Idea: You can add account verify system. It could be phone or document verification system. And verified account will show as symbol on profile.

Thanks

I second that motion.



Are you sure you want to delete this post?

aleqyanhovik
Hi, I would like to ask a question about affliliate contest, what should the users share? A specific content or any service they want? This is just interesting, in both cases its a good idea!



Are you sure you want to delete this post?

Tommy Matalino
Hi, I would like to ask a question about affliliate contest, what should the users share? A specific content or any service they want? This is just interesting, in both cases its a good idea!

Affiliate, if I'm not mistaken, all you need to do is share your affiliate link, may it be on your own gig or any gigs you think is helpful on your audience.



Are you sure you want to delete this post?

aleqyanhovik
Affiliate, if I'm not mistaken, all you need to do is share your affiliate link, may it be on your own gig or any gigs you think is helpful on your audience.

Thanks, I got you.



Are you sure you want to delete this post?

Maranatha
I would go for BOTH options. : )

btw, i enjoyed reading all comments and suggestions What next? (for more free money) Seoclerks members are all smart people What next? (for more free money)



Are you sure you want to delete this post?

midouloumi
Any News when the new promotion will start ?



Are you sure you want to delete this post?

Order Now
Process Time: 2.7843239307404

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=11SELECT googleplus_profile FROM seoclerks.members WHERE USERID=1

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12240' 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='12240' 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=57799 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=57799 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=57801 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=57801 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=57802 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=57802 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=57804 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=57804 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=57805 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=57805 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=57807 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=57807 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=57809 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=57809 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=57810 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=57810 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=57811 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=57811 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=57812 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=57812 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=57813 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=57813 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=57814 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=57814 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=57815 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=57815 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=57817 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=57817 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=57818 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=57818 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=57819 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=57819 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=57821 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=57821 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=57822 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=57822 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=57823 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=57823 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=57824 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=57824 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=57825 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=57825 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=57826 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=57826 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=57827 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=57827 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=57828 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=57828 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=57829 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=57829 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=57830 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=57830 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=57831 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=57831 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=57832 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=57832 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=57834 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=57834 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=57835 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=57835 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=57836 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=57836 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=57837 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=57837 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=57838 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=57838 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=57840 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=57840 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=57842 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=57842 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=57843 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=57843 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=57844 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=57844 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=57845 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=57845 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=57846 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=57846 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=57847 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=57847 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=57848 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=57848 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='12240' AND status='1' AND (question like '% next? (for free money)%' OR question like '%next?%' OR question like '%(for%' OR question like '%free%' OR question like '%money)%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='12240' AND status='1' AND (question like '% next? (for free money)%' OR question like '%next?%' OR question like '%(for%' OR question like '%free%' OR question like '%money)%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
0.1041031SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 20393 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Craiglist Backpage Classified Posting%' ) LIMIT 40.1041030.104103