SEOClerks

Affiliate commissions question



Write the reason you're deleting this FAQ

Affiliate commissions question

So it's been awhile since jumping around the forums on the web and was wondering @hitmeasap (sorry for the tag but I knew you'd know whats up) if they changes the commission payouts on affiliates that purchase services from you.

I remember SEOclerks offering a higher percentage for services you sell to your own affiliates. Guess they were noticing too much of a loss or.....?

Also, outside of that, as an X4 I'm supposed to make an extra 1% on all sales and all affiliate sales. I'm not seeing that either. Maybe something to forward to support?

Comments

Please login or sign up to leave a comment

Join
hitmeasap
So it's been awhile since jumping around the forums on the web and was wondering @hitmeasap (sorry for the tag but I knew you'd know whats up) if they changes the commission payouts on affiliates that purchase services from you.

I remember SEOclerks offering a higher percentage for services you sell to your own affiliates. Guess they were noticing too much of a loss or.....?

Also, outside of that, as an X4 I'm supposed to make an extra 1% on all sales and all affiliate sales. I'm not seeing that either. Maybe something to forward to support?



Hey @ericplotz1,

I haven't heard about any changes regarding affiliate commissions at all. However, I'm not 100% sure of this, but the way I understand things, the extra % on sales for being a X4-5 member isn't visible for you and automatically added to your balance after the clearing period..

That being said, I personally think that the extra % should be visible for those of us who's eligible, as we have no control at all over those % if what I stated above is the truth.


Sorry for not being able to give you accurate answers for this. I'll send a ticket to the support regarding this and update the thread when I get proper answers, as I might be wrong.


Regards,
hitmeasap



Are you sure you want to delete this post?

ericplotz1
Thanks bud, keep me posted when they respond plaease.

Hey @ericplotz1,

I haven't heard about any changes regarding affiliate commissions at all. However, I'm not 100% sure of this, but the way I understand things, the extra % on sales for being a X4-5 member isn't visible for you and automatically added to your balance after the clearing period..

That being said, I personally think that the extra % should be visible for those of us who's eligible, as we have no control at all over those % if what I stated above is the truth.


Sorry for not being able to give you accurate answers for this. I'll send a ticket to the support regarding this and update the thread when I get proper answers, as I might be wrong.


Regards,
hitmeasap



Are you sure you want to delete this post?

aditya
I think this is not only about extra % of level X even total amount is not visible when you affiliate purchase your own services.
They are showing only regular amount(After deducting 20%).



Are you sure you want to delete this post?

ericplotz1
@hitmeasap in the TOS it says it. Should I send a ticket or did you find something out?

Affiliate commissions question



Are you sure you want to delete this post?

hitmeasap
Hey @ericplotz1,
I've just got an answer from the support.

Here's what they said:

I apologize for the delay in updating you, I missed this assignment.

If a user is your affiliate and purchases from you, you get 100% of that sale.

If you're level 4, you get 1% extra.

If you're level 5, you get 2% extra.

The extra 1 / 2 % is indicated on the balance page next to the order in red text. The actual price still shows the 80% based value but still indicated as getting the extra %.



Regards,
hitmeasap



Are you sure you want to delete this post?

ericplotz1
@hitmeasap Lol. Did I miss something or did their response make sense to you???? About the only thing that made sense is the affiliate buying a service from me and me making 100% of the sale. I see they add a red 100% next to those sales. But what is 100% of the sale. Is it really 100%???? SeoClerks takes no cut?

What doesn't make even more sense is the affiliate and the 1-2% with the 80 percent said here:

The extra 1 / 2 % is indicated on the balance page next to the order in red text. The actual price still shows the 80% based value but still indicated as getting the extra %.


The percentage is 10%. You earn an extra 1-2% on affiliate purchases making it in total 11-12%.

Either way where does it show up???? Support said:

The extra 1 / 2 % is indicated on the balance page next to the order in red text


The affiliate balance page indicates nothing like that. The only thing in red are incomplete orders.

This is the affiliate "balance page"

Affiliate commissions question



Are you sure you want to delete this post?

hitmeasap
@hitmeasap Lol. Did I miss something or did their response make sense to you???? About the only thing that made sense is the affiliate buying a service from me and me making 100% of the sale. I see they add a red 100% next to those sales. But what is 100% of the sale. Is it really 100%???? SeoClerks takes no cut?

What doesn't make even more sense is the affiliate and the 1-2% with the 80 percent said here:



The percentage is 10%. You earn an extra 1-2% on affiliate purchases making it in total 11-12%.

Either way where does it show up???? Support said:



The affiliate balance page indicates nothing like that. The only thing in red are incomplete orders.

This is the affiliate "balance page"

Affiliate commissions question



Hey @ericplotz1,
Truth to be told.. I didn't actually get that much out of their answer either..

About the 100%:
If you refer a user using your affiliate link and they purchase your own service(s), you will earn 100% of the funds minus fees. Fees are between 5-10% and cover the inbound and outbound payment charge issued by our payment processors. The affiliate cannot be linked to you in any way, including IP address.

To earn 100%, the order must be $5 or more and the buyer cannot be linked to the seller in any way.


That basically means you'll get 90-95% of the funds.
So, I guess we've managed to bring some clarity into that at least.


And regarding the 1-2%, at least I know that these doesn't add up. If you're a level X5, like I am. It's still 2%, as it would have been if I where a Level 5 user, but you're correct. I can't see these extra % indicated anywhere either.


( I'll Re-open the ticket and ask for a better explanation Affiliate commissions question)


Regards,
hitmeasap



Are you sure you want to delete this post?

chetaseo
Thanks both of you are working on clarifying this affiliate issue of a thing. though i am not an active affiliate, i must say that i have learnt one or two stuffs from the posts above. keep it up. not much for me to say. Thank you.



Are you sure you want to delete this post?

hitmeasap
@ericplotz1 I've been discussing things with support and I'll update this thread as soon as I get a proper answer to this. Their statement is still that the extra % should be indicated on the balance page, but since we can't see it, they'll look into this further.


Regards,
hitmeasap



Are you sure you want to delete this post?

chetaseo
good job you are doing here hitmeasap. keep up the good work. i am also interested in this affiliate issue of a thing too because it also affects me as a seller and affiliate.



Are you sure you want to delete this post?

exjordanary
@hitmeasap
@ericplotz1

I believe what you're looking for is this:
Affiliate commissions question


The "RED 100%" does NOT show up in the "Affiliate Earnings" Section, rather, it's in your "Personal Sales" Section

I only "Skimmed" through your conversation, but in case that wasn't it, I HAVE noticed that the Actual Price of that Service at the time was $5, so if I get 100% of the (20%) Commissions (from my own Affiliates), it's displaying that only 80% went to my Balance.

I hope it IS being Accounted for though....Somewhere.

-ex



Are you sure you want to delete this post?

hitmeasap
@hitmeasap
@ericplotz1

I believe what you're looking for is this:
Affiliate commissions question


The "RED 100%" does NOT show up in the "Affiliate Earnings" Section, rather, it's in your "Personal Sales" Section

I only "Skimmed" through your conversation, but in case that wasn't it, I HAVE noticed that the Actual Price of that Service at the time was $5, so if I get 100% of the (20%) Commissions (from my own Affiliates), it's displaying that only 80% went to my Balance.

I hope it IS being Accounted for though....Somewhere.

-ex



Thank you @exjordanary.
I was looking for that to begin with, but I got an answer for that already. Thanks though for providing such a clear screenshot. That might be of help for others Affiliate commissions question


Now we're looking for the 1 / 2 % extra on all sales, (both affiliate sales and sales). That should be indicated somewhere too, but none of us seems to see it.


Regards,
hitmeasap



Are you sure you want to delete this post?

sanfora
wow you must be guru seller here do you feature your service to get that much,



Are you sure you want to delete this post?

hitmeasap
@ericplotz1,
I will probably have the information by tomorrow. (judging by their last reply)

I'll let you know whenever I hear from them!


Regards,
hitmeasap



Are you sure you want to delete this post?

anwebservices
As Level x4 i don't see extra 1% on my balance ether Affiliate commissions question or is it too small to show up Affiliate commissions question



Are you sure you want to delete this post?

ericplotz1
@hitmeasap So Ive found a few more discrepancies. In the SS below all of those sales are my service that were purchased by affiliates. Yet only one has the 100% next to it.

Affiliate commissions question



Are you sure you want to delete this post?

hitmeasap
@hitmeasap So Ive found a few more discrepancies. In the SS below all of those sales are my service that were purchased by affiliates. Yet only one has the 100% next to it.

Affiliate commissions question



Hey @ericplotz1
I still haven't heard back from the support yet. I'll have them look into this once they get back to me with the current issues.

I'll let you know once I hear anything!


Regards,
hitmeasap



Are you sure you want to delete this post?

W130SN
I had been wondering about this for some time. Thanks guys for trying to clear it up.
Look forward to hearing the latest update.



Are you sure you want to delete this post?

ericplotz1
I figured out why only one of those services had the 100% next to it. It's only for services over $5. My apologies for that, as it was my fault that I did not fully read the details.

The 1-2% is still a mystery tho.



Are you sure you want to delete this post?

hitmeasap
I figured out why only one of those services had the 100% next to it. It's only for services over $5. My apologies for that, as it was my fault that I did not fully read the details.

The 1-2% is still a mystery tho.



Answers to this is what I'm still waiting for. Hopefully they'll get back to me shortly. Thanks for letting me know about the other things though!



Are you sure you want to delete this post?

hitmeasap
@ericplotz1, support just replied!

Here's what they said:

Hi André,

I'm very sorry you should have been updated the other day when I said, I don't know what's happened.

I was mistaken initially, the 1/2% is not directly indicated and is simply added onto the funds when they clear to your account. Values show at 80%/normal but the amount actual added to your balance after clearing will be the 80% + extra percentage.

The extra percentage is for sales/affiliate sales but will not apply if the order is a sale with an affiliate(as you would already be getting 100% minus fees rather than the usual 80%), they don't get the extra 1/2%.

The indicator in red text I had mentioned in a passed reply was actually only related to 100% orders, that was my mistake.

Regards,
Dillon



Regards,
hitmeasap



Are you sure you want to delete this post?

jabed92
I am really amazing to see this post.... It is really inspiring me to build up my business...... thanks



Are you sure you want to delete this post?

ericplotz1
@ericplotz1, support just replied!

Here's what they said:



Regards,
hitmeasap


I'm guessing they keep saying 80% as a mistake? It's 10 percent not 80. Either way, I'm getting the entire message is "we're adding it and you'll just have to trust us".

Thanks for looking into it though @hitmeasap

Cheers man!



Are you sure you want to delete this post?

ericplotz1
I am really amazing to see this post.... It is really inspiring me to build up my business...... thanks

I see you like spamming the forum with your signature by posting one-liner junk that doesn't benefit anyone. Chill out man



Are you sure you want to delete this post?

Order Now
Process Time: 1.8106389045715

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=1218141SELECT googleplus_profile FROM seoclerks.members WHERE USERID=121814

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='11994' 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='11994' 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=55100 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=55100 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=55101 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=55101 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=55102 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=55102 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=55103 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=55103 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=55104 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=55104 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=55105 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=55105 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=55106 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=55106 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=55107 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=55107 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=55108 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=55108 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=55109 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=55109 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=55110 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=55110 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=55111 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=55111 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=55112 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=55112 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=55113 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=55113 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=55114 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=55114 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=55115 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=55115 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=55116 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=55116 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=55117 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=55117 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=55118 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=55118 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=55119 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=55119 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=55120 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=55120 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=55121 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=55121 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=55122 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=55122 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=55123 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=55123 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='11994' AND status='1' AND (question like '%Affiliate commissions question%' OR question like '%Affiliate%' OR question like '%commissions%' OR question like '%question%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='11994' AND status='1' AND (question like '%Affiliate commissions question%' OR question like '%Affiliate%' OR question like '%commissions%' OR question like '%question%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='205476.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='205476.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.1092951SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 67214 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Coding Code Coder%' ) LIMIT 40.1092950.109295