SEOClerks

First SeoClerk affiliate sale... oh yeah!



Write the reason you're deleting this FAQ

First SeoClerk affiliate sale... oh yeah!

Yes please, I just made my first $1.40 here as an affiliate First SeoClerk affiliate sale... oh yeah!

I am way chuffed with that! It is quite amazing that just this month it appears I am doing a lot of firsts when it comes to making affiliate sales and other types of jobs too.

I can't wait to see how this adds to my income stream! All the bits are really starting to add up now.

Comments

Please login or sign up to leave a comment

Join
MusicMoguls
I Just want to say congrats! i am really happy to hear that your making affiliate money... i just recently got my first sale as well and now i have a few and i am just so pumped up about it! I use email marketing to send out my Affiliate sign up link and it works! i recommend everyone to try this because its proven successful. I have accomplished so much on seoclerks.com and my next goal is to get level X4 so that people can see that im not going anywhere and that i have an interest in growing and becoming more involved in seoclerks. so congratulations again on your success and may the rest of 2016 be great for you ad your family! CHEERS!



Are you sure you want to delete this post?

Lynne
Thanks Jkeyz2, it really is exciting and the best part is that I wasn't expecting it at all! I was actually checking to see if I got any new affiliates and I saw my first sale had come in. Not bad from just 7 affiliates!

I wish you the best and I am sure you will make levelX4.



Are you sure you want to delete this post?

MusicMoguls
Thanks i hope so then i will try and do X5 who knows skies the limit i am a lifer here on seoclerks hahahaha.



Are you sure you want to delete this post?

Lynne
Yes be an X5 and I will market for you! First SeoClerk affiliate sale... oh yeah!



Are you sure you want to delete this post?

rhady11
i made my first affiliate sale 10 days ago and since made 15 more sales from the same user now i have my own service with a 15% lifetime affiliate commision



Are you sure you want to delete this post?

Lynne
Congrats, that is awesome! I have been busy with other projects so I am getting frustrated because I want to focus on my affiliate sales for SeoClerks but I am too busy lol. I will get there soon.



Are you sure you want to delete this post?

CitrusMedia
First SeoClerk affiliate sale... oh yeah!
If you need any more inspiration, this is kind of the middle step before you reach the insane earnings of the guy above which would probably pay for me to get my first car. But for me as a student this is great, over the years I've only done a little bit of work here and there and I've got 135 referrals that could buy at any time. I have 5,000,000 clicks because I run a large automated Twitter marketing scheme. Anyone can do that, just set it and go. First SeoClerk affiliate sale... oh yeah!



Are you sure you want to delete this post?

Lynne
Oh wow, that is awesome and thanks for sharing, it is certainly inspirational.

I can add in some automated Twitter marketing. I never thought of that but now that you mention it that would be one of the easiest ways to do it right now. Set and forget!



Are you sure you want to delete this post?

CitrusMedia
You're welcome! TwitterFeed.com is what I use. First SeoClerk affiliate sale... oh yeah!



Are you sure you want to delete this post?

Lynne
I will check them out. I am using Mass Planner and I am very impressed with them!



Are you sure you want to delete this post?

robertman11
Woohoo, congrats! That affiliate will continue to earn you income for as long as they continue purchasing.



Are you sure you want to delete this post?

Lynne
Thank you! Yes I am very excited!



Are you sure you want to delete this post?

idealmike
Oh nice one Lynnee! Congrats and jubilations! Bring out the oldest bottles, let's pop a couple off! First SeoClerk affiliate sale... oh yeah!

That's really great though. I will just say now that what ever you done to get that affiliate, keep doing it! Double up, triple up and upscale it to the sky and keep doing it over and over so that you get more and more affiliates from that method.

How did you get them anyway if you don't mind me asking? Was it through a blog post on your site or from a social media post?

Don't forget that there are many things to try, many different methods you can use. What's important is to try them and find one that is working for you and then devote your all and everything to it. Throw and pour your life, soul, blood, sweat and tears into it!

Here's three cheers and a hip hip hooray to your first affiliate.

And here's to getting many more!



Are you sure you want to delete this post?

exjordanary
Agreed. Allow me to share some of my success if you may.
My current Stats:
First SeoClerk affiliate sale... oh yeah!

Although may seem like it's alot, only brings me about $25 per day.

This may be due to "Affiliate Pirates" (users who target ultra-active Buyers, then offer them a promo or free service if they create a new account under their Affiliate Link).

This happened a lot fora while, but it seems like The Staff have implemented much more strict security and fruad prevention measures since then.

As many of u may notice, random affiliate Sources in your list of Affiliates, which has NOTHING TO DO w/ you or your Affiliate ID???

Well, that is actually one of your old Affiliates who was Pirated from you (by that Random Source Link listed).

So that's nice to see.

One thing I suggest is to 'Follow' your Affiliates. That way, you can elect to receive 'Alerts' whenever they Post a WTB listing, then find creative ways to 'Assist' in their hunt.

I have always wished for a Feature in the API (or via RSS) to pull WTB Data from our Affiliates, but still no feature First SeoClerk affiliate sale... oh yeah!
Only 'Service' Data can be pulled when it comes to Individual Users.

I would also love to see a way to pull API Data of the new 'Custom Affiliate Commissions' (above 10%) set by Sellers upon Service creation.

That would be great for Affiliate Store Owners allowing them room to be creative with Service Placement, Promos, and Incentive for Services that offer higher Commissions.

For those who don't know me, I started here with ZERO knowledge of Internet, Social, or Affiliate Marketing back in 2012.
But then Won 1st Place in their Affiliate Contests.
But once the ball starts rolling, it snowballs.

I remember before there was the API, I used to create 'Service Banners' made from screenshots of all the best '$1 Dollar Listings' I could find on SEOclerks and I'd create a Page on CommunityClerks.com featuring ONLY those $1 Banners.

A 'pain in the' you know, 'butt' it was worth it. Because that contributed to the creation of the API:
First SeoClerk affiliate sale... oh yeah!


Thus, making way for my main Affiliate Store, aDollarSEO.com , (which still brings in a few new affiliates for me daily), as well as hundreds of other Stores by other Users.
-Exjordanary (Level X8)



Are you sure you want to delete this post?

Lynne
Oh wow, thank you so much for sharing about your success, this makes me quite excited to keep going. Yes I made $1.40 which is not a massive amount but I have to start somewhere.

Thank you so much for sharing all your tips, I really do appreciate it. I am off to go and follow all of my affiliates. I only have 7 and I will make it a point to follow all new affiliates as they come in.

I must say I was quite pleased with my conversion rate because not ever have I managed to make a sale with affiliate marketing with just 100 odd clicks and 7 sign ups! This has been the fastest converting website so far.

I can see I must put loads more effort in here, since my affiliates will be life long earners! $1.40 today can turn into huge earnings one day!



Are you sure you want to delete this post?

asaliuku
Hi, Can you promote my Service about dropshipping, affiliates will earn 50% of the sale amount.



Are you sure you want to delete this post?

clerkboy3
Just wow! Congratulations First SeoClerk affiliate sale... oh yeah!
It's great to see your success story, so that we can someday achieve a certain level of success as well!
You are the master exjordanary



Are you sure you want to delete this post?

Lynne
Hey Mike First SeoClerk affiliate sale... oh yeah!

That was through a blog post I wrote about SeoClerks. I have 7 referrals now from that post and this was my first sale. The best part is that I know the service that was bought is absolutely top notch because I buy that service regularly and I recommended it so I am sure my referral will be happy as can be with the purchase.

Happy days, and yeah I plan on doing some more promotions for SeoClerk because I can really see how this can grow into an amazing source of income.



Are you sure you want to delete this post?

idealmike
Awesome. Some of my affiliates, I don't even want to know where they come from. Well one of them in particular keeps buying negative SEO (for one of his rivals I suppose). Hey, if that's what he wants who am I to judge when I'm making commissions off that. Let the negative SEO flow! LOL ;)



Are you sure you want to delete this post?

Lynne
Oh dear LOL.... oh well you can't control what people are doing can you? They will be doing that anyway so you may as well make some money off of it...but I do wonder why people are doing things like that ... :-o



Are you sure you want to delete this post?

anwebservices
Yayyy First SeoClerk affiliate sale... oh yeah! Welcome to the club First SeoClerk affiliate sale... oh yeah! I know how exciting it is, so congratz and i wish you best of luck to your future affiliate marketing with Seoclerks ;)



Are you sure you want to delete this post?

Lynne
Thank you! I love it when a plan comes together! it is especially exciting when I only have 7 referrals and one of them is already ordering First SeoClerk affiliate sale... oh yeah!



Are you sure you want to delete this post?

ajlancer
Hi Lynne thanks for nice sharing about your success. Yeah! it is great filling as expression of first affiliate sale. I felt so when I was make it. I got my first affiliate sale from facebook group sharing. I created a SEOclerks facebook group and I was make pin post with my affiliate link and I got huge traffic from there and few of them purchased too. But, unfortunately now facebook promotion is off. You did right things for getting traffic by site review. Hope you will get more response from there and fell will more happy. And I think you are able to get level up by getting more referral.

Regards by Ajlancer



Are you sure you want to delete this post?

Lynne
Thanks Ajlancer First SeoClerk affiliate sale... oh yeah! Yes I am sure I will be able to get loads of referrals with a bit of time and a bit of marketing. I haven't spent too much time and effort with getting referrals but I can see I must put more focuson it.



Are you sure you want to delete this post?

webexpert1313
Now, i am also going to focus on my affiliate sale, its really amazing experience First SeoClerk affiliate sale... oh yeah!



Are you sure you want to delete this post?

Lynne
Yes it is awesome, I highly suggest you give it a go! I am sure it will be a bit slow to start but with lifetime affiliate earnings you can't go wrong!



Are you sure you want to delete this post?

EliteWriter
I am glad about this Lynne. I think that you work hard, and do your best, and so you deserve to do well ;)



Are you sure you want to delete this post?

Lynne
Thank you and the same to you, so I am pleased it was through you! Congrats to us both First SeoClerk affiliate sale... oh yeah!



Are you sure you want to delete this post?

procoder
Congrats Lynne! Now tell me how you felt when you received this email from SEOClerks? First SeoClerk affiliate sale... oh yeah!

And, I wish you all the best on your affiliate sales!



Are you sure you want to delete this post?

Lynne
Actually I didn't receive an email LOL. I think I must check my email settings First SeoClerk affiliate sale... oh yeah!

I was going to see whether I had any new referrals and I didn't I still had 7 and I nearly missed the fact I had made my first sale.



Are you sure you want to delete this post?

procoder
Oh that's odd, I receive emails for each affiliate sale. "Affiliate Sale Made" it's just a nice email for me First SeoClerk affiliate sale... oh yeah!



Are you sure you want to delete this post?

Cristian
Congrats Lynne! Hope you get to have as much success as exjordanary had!
@ exjordanary - those stats are just incredible mate! Keep up the good work, you brought a lot of clients here...damn...



Are you sure you want to delete this post?

exjordanary
For those of you who don't have an Affiliate Store, there are still a LOT of ways to utilize the RSS Feeds to promote your Affiliate Link.
  • Everyone knows the MAIN RSS Feed for SEOClerk Services: https://www.seoclerks.com/rss
  • Then there's the ones in our PROFILE: https://www.seoclerks.com/rss?u=exjordanary
  • Then for WTB Listings: https://www.seoclerks.com/rss/wtb
  • and WTT (Trade) Listings: https://www.seoclerks.com/rss/wtt


Well, if u wanna make ALL the Live Links Displayed in the Feed to include your Affiliate ID, just append to the end using a=(affiliate ID)
SO, for example, my affiliate link is: /linkin/3764/ - so my Affiliate ID is: '3764'

So I would do THIS to the above RSS Links:

NOTICE HOW EVERY LINK IN EACH FEED INCLUDES MY AFFILIATE ID!!

You can use simple RSS NewsTicker Plugins to display Services with your Affiliate ID in each Link like this one below (shown at Communityclerks.com)
First SeoClerk affiliate sale... oh yeah!

NO NEED to EVER update anything!! Links are always FRESH!!

ALL OF THE ABOVE ALSO WORKS FOR Codeclerks.com and Listingdock.com TOO!!
EXAMPLES:

etc..

HOPE THIS HELPS!!
-EX



Are you sure you want to delete this post?

Lynne
Oh this is great thank you! I need to make use of something like this!



Are you sure you want to delete this post?

Lynne
Yes I hope so too, that is certainly something to strive for!



Are you sure you want to delete this post?

asaliuku
Hi, Can you promote my Service about dropshipping affiliates will earn 50% of the sale amount.



Are you sure you want to delete this post?

Nayan362
hi i am nayan i come form bangladesh rajshahi First SeoClerk affiliate sale... oh yeah!



Are you sure you want to delete this post?

Cybertron
I have a lot?s of affiliate click?s daily..but dont have any member or sale?s



Are you sure you want to delete this post?

procoder
Well that depends on the type of promotion which you're doing to advertise your affiliate link, I mean you can get a lot of clicks but that doesn't mean that they will register on site from your affiliate url or will purchase services.

Check and see what things can be improved that can increase chances for you to get more clicks and affiliate members . And Good luck! First SeoClerk affiliate sale... oh yeah!



Are you sure you want to delete this post?

Lynne
Yes I have to agree with Procoder here,your success depends largely on the way that you market your affiliate offers. You can share on social media until you are blue in the face and you most likely won't have much success...

The best way I find is to write about your offers on your website. That is how I got all my sign ups!



Are you sure you want to delete this post?

Cybertron
Thank You ..i will try it



Are you sure you want to delete this post?

Order Now
Process Time: 4.9082159996033

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=3066321SELECT googleplus_profile FROM seoclerks.members WHERE USERID=306632

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='19471' 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='19471' 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=106884 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=106884 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=106887 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=106887 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=106994 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=106994 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=106996 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=106996 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=107128 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=107128 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=107131 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=107131 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=107298 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=107298 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=107300 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=107300 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=107314 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=107314 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=107341 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=107341 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=106697 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=106697 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=107053 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=107053 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=106699 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=106699 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=106986 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=106986 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=106993 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=106993 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=107491 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=107491 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=112586 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=112586 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=106701 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=106701 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=106705 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=106705 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=106711 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=106711 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=106702 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=106702 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=106710 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=106710 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=106719 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=106719 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=106728 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=106728 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=106723 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=106723 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=106727 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=106727 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=106767 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=106767 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=106779 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=106779 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=106869 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=106869 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=106870 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=106870 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=107201 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=107201 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=107049 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=107049 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=107998 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=107998 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=108684 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=108684 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=107132 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=107132 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=107490 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=107490 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=108662 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=108662 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=108692 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=108692 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=108701 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=108701 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=108708 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=108708 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=108746 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=108746 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='19471' AND status='1' AND (question like '%First SeoClerk affiliate sale... yeah!%' OR question like '%First%' OR question like '%SeoClerk%' OR question like '%affiliate%' OR question like '%sale...%' OR question like '%yeah!%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='19471' AND status='1' AND (question like '%First SeoClerk affiliate sale... yeah!%' OR question like '%First%' OR question like '%SeoClerk%' OR question like '%affiliate%' OR question like '%sale...%' OR question like '%yeah!%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=19471%' 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=19471%' 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='139192.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='139192.png'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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