SEOClerks

awesome new SEO Clerks affiliate widget, convert 300% more, FREE! ;)



Write the reason you're deleting this FAQ

awesome new SEO Clerks affiliate widget, convert 300% more, FREE! ;)

Hi,

1st of all, I wold like to thank all this awesome website stuff, it's really a great work ;)

Here I'm offering a new script it's "SEO Clerks affiliate widget"

Some Features:
- enhanced ad design
- rotate add when page refresh
- choose from 20 ads for every single add (this awesome feature automatically get 20 random ads and just display the highest feedback from those 20 gigs, it make your add always better)
- show and hide add animation
- popup & fixed box in the page
- show integrated ad elements (seller avatar, seller name, seller level, gig title, gig image, gig ratings & order button)
- easy to install

sure it's most welcome with your feedback ^^

You may now want to see demo, check here:
http://www.scriptestore.com/sclrkAPI/

Now how to install it?
as I promise that it's easy to install, just put this code in your webpage(s) before closing head tag (before </head>)

<script>
    var sclrkRefId = xxxxxx;
    var script = document.createElement('script');
    script.src = 'http://scriptestore.com/sclrkAPI/api.js';
    document.head.appendChild(script);
</script>

don't forget to replace the xxxxxx in the code to your "Affiliate ID", get it from this page:
https://www.seoclerk.com/balance?tab=affiliate
It should be something like: 21882


Try it don't hesitate, some of us here make thousands of dollars with the awesome SEO Clerks affiliate programs.

Comments

Please login or sign up to leave a comment

Join
seoguru24x7
Wow great , will definitely try this



Are you sure you want to delete this post?

dragonhunter95
thank you very much I will use it sure



Are you sure you want to delete this post?

SEOeStore
Wow great , will definitely try this

Thanks, hope you like it ^^



Are you sure you want to delete this post?

SEOeStore
but this affiliate store will i buy a domain or whar because i do not understand much when it comes to affiliate store and can you explian it to me

No this plugin assume that you have a website in SEO niche and want to promote your affiliate link on it, check those live examples ^^
http://freeindexer.com/
http://freeseostatus.com/



Are you sure you want to delete this post?

SEOeStore
thank you very much I will use it sure

Thanks very much, also your feedback will be great ^^



Are you sure you want to delete this post?

Topseoservice
Some nice work for all the affiliates.



Are you sure you want to delete this post?

cyberspot
Good one here. Is it possible to make it show only 1 gig ?



Are you sure you want to delete this post?

SEOeStore
Some nice work for all the affiliates.

many thanks for review ^^



Are you sure you want to delete this post?

SEOeStore
Good one here. Is it possible to make it show only 1 gig ?

it's already showing only one gig,
do you mean you need it to promote a defined gig, for example to get a per-defined gig?
also just note that this is an affiliate widget,
know more about SEO Clerks affiliate from this link:
https://www.seoclerks.com/affiliate



Are you sure you want to delete this post?

SEOeStore
how much the you sell it or is it for free to buy

Hi,
I really con not understand your request,
this plugin is free

If you need custom modifications please explain it for me ^^



Are you sure you want to delete this post?

SEOeStore
please i need the custom modifications

I sent you a message in SEO clerks main website asking for more details ^^



Are you sure you want to delete this post?

aditya
Hi SEOeStore, First time i see you here.
Script is too good, i really want to use this at my blogs.

Thanks



Are you sure you want to delete this post?

SEOeStore
Hi SEOeStore, First time i see you here.
Script is too good, i really want to use this at my blogs.

Thanks


Yes,
I'm not an active forum member ^^
Thanks, and hope it convert more for you ;)



Are you sure you want to delete this post?

aditya
Yes,
I'm not an active forum member ^^
Thanks, and hope it convert more for you ;)


Sure, Now I will make more sales.
I love your services & widget here at forum too



Are you sure you want to delete this post?

SEOeStore
Sure, Now I will make more sales.
I love your services & widget here at forum too

Wow thanks for review ^_^



Are you sure you want to delete this post?

topclassseo
i will choose it next time.



Are you sure you want to delete this post?

SEOeStore
i will choose it next time.

Great,
installing the widget in your site, is free & easy ;)



Are you sure you want to delete this post?

cyberspot
it's already showing only one gig,
do you mean you need it to promote a defined gig, for example to get a per-defined gig?
also just note that this is an affiliate widget,
know more about SEO Clerks affiliate from this link:
https://www.seoclerks.com/affiliate


Yes i know much about affiliate and already banking with it. My request is, Is it possible to define a preset gig(s) to show on this widget ?

Thumbs up for this lovely tool.



Are you sure you want to delete this post?

SEOeStore
I think it's not possible in direct options of the affiliate API, as we shown the some user details (image, name & level)
may be with a some tricks,
but there is a similar option, it's possible to define the seller who want to show his gigs, let me know and I may make this custom modification for you ^^

regards,
B.Shahin



Are you sure you want to delete this post?

webseo123kh
Hi,

Now how to install it?
as I promise that it's easy to install, just put this code in your webpage(s) before closing head tag (before </head>)
<script>
    var sclrkRefId = xxxxxx;
    var script = document.createElement('script');
    script.src = 'http://scriptestore.com/sclrkAPI/api.js';
    document.head.appendChild(script);
</script>

don't forget to replace the xxxxxx in the code to your "Affiliate ID", get it from this page:
https://www.seoclerk.com/balance?tab=affiliate
It should be something like: 21882
.


Interesting, but code is of two digits. Will it work? thnx



Are you sure you want to delete this post?

SEOeStore
Interesting, but code is of two digits. Will it work? thnx

Hi,
do you mean your "affiliate ID" is consists of 2 digits?
if you are sure it's your right one, then yes it will be working properly ^^



Are you sure you want to delete this post?

webseo123kh
Yes. It is 44. Anyways I have used it. Please check goo.gl/DI466T



Are you sure you want to delete this post?

SEOeStore
Yes. It is 44. Anyways I have used it. Please check goo.gl/DI466T

Yes I see it's working, you are an old member to have the ID 44 awesome new SEO Clerks affiliate widget, convert 300% more, FREE! ;)



Are you sure you want to delete this post?

webseo123kh
Okay. Yeah I registered here long ago but started promoting my gigs very lately. Anyways, thnx.

Can you help me with some other similar interesting widgets or other fruitful things to earn more here.



Are you sure you want to delete this post?

SEOeStore
Okay. Yeah I registered here long ago but started promoting my gigs very lately. Anyways, thnx.

Can you help me with some other similar interesting widgets or other fruitful things to earn more here.

Yes sure, let me know your idea, and I may do it for you ^^



Are you sure you want to delete this post?

webseo123kh
Something like a marquee.



Are you sure you want to delete this post?

SEOeStore
Something like a marquee.

Yes sure, it's simple, but I choose to work with more modern design



Are you sure you want to delete this post?

webseo123kh
Like? Any suggestion?



Are you sure you want to delete this post?

SEOeStore
Like? Any suggestion?

mean any suggestions that may increase the conversion,
I'm thinking about that much time, to enhance this plugin



Are you sure you want to delete this post?

anwebservices
@SEOeStore This is great looking addition to any website. Would you mind if i use it as addition to my WordPress Theme? I am about to release new version very soon and this would be nice to add too awesome new SEO Clerks affiliate widget, convert 300% more, FREE! ;)



Are you sure you want to delete this post?

SEOeStore
@SEOeStore This is great looking addition to any website. Would you mind if i use it as addition to my WordPress Theme? I am about to release new version very soon and this would be nice to add too awesome new SEO Clerks affiliate widget, convert 300% more, FREE! ;)

Sure you can use it as you can, I will be also happy for that ^^



Are you sure you want to delete this post?

chetaseo
@SEOeStore, thanks so much for this affiliate widget. very cool. this will surely add some sales and make money. thank you so much.



Are you sure you want to delete this post?

SEOeStore
@SEOeStore, thanks so much for this affiliate widget. very cool. this will surely add some sales and make money. thank you so much.

You are welcome, really happy that you like it ^^



Are you sure you want to delete this post?

chetaseo
You are welcome, really happy that you like it ^^

sure, i like ti, thanks once again.



Are you sure you want to delete this post?

plansmm
Is it free or I have to pay for this?



Are you sure you want to delete this post?

SEOeStore
Is it free or I have to pay for this?

Hi,
It's free and will stay free awesome new SEO Clerks affiliate widget, convert 300% more, FREE! ;)



Are you sure you want to delete this post?

SEOeStore
its free for some time

it's free also will stay free for ever awesome new SEO Clerks affiliate widget, convert 300% more, FREE! ;)



Are you sure you want to delete this post?

aditya
It's free as you can see code already given there.



Are you sure you want to delete this post?

SEOeStore
can i get one of this if it is free

sure, it's free,
code and installation steps are here:
https://www.seoclerk.com/forum/thr...more-free.12288/



Are you sure you want to delete this post?

plansmm
Where I will put my affiliate id in this code?

<script>
var sclrkRefId = xxxxxx;
var script = document.createElement('script');
script.src = 'http://scriptestore.com/sclrkAPI/api.js';
document.head.appendChild(script);
</script>



Are you sure you want to delete this post?

SEOeStore
ok thanks for that

You are most welcome ^^



Are you sure you want to delete this post?

SEOeStore
before </head>
Where I will put my affiliate id in this code?

<script>
var sclrkRefId = xxxxxx;
var script = document.createElement('script');
script.src = 'http://scriptestore.com/sclrkAPI/api.js';
document.head.appendChild(script);
</script>

before </head>



Are you sure you want to delete this post?

topclassseo
how i can use that ?



Are you sure you want to delete this post?

SEOeStore
how i can use that ?

Please read the main thread, it have a step by step installation guid
https://www.seoclerk.com/forum/thr...more-free.12288/



Are you sure you want to delete this post?

aditya
Yes, I also tried this code.
All Working fine



Are you sure you want to delete this post?

SEOeStore
Yes, I also tried this code.
All Working fine

Sounds great ^^



Are you sure you want to delete this post?

SEOeStore
nice one keep it up

Thanks awesome new SEO Clerks affiliate widget, convert 300% more, FREE! ;)
also all comments or suggestions are welcome, so we may update awesome new SEO Clerks affiliate widget, convert 300% more, FREE! ;)



Are you sure you want to delete this post?

Order Now
Process Time: 1.4689149856567

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=218821SELECT googleplus_profile FROM seoclerks.members WHERE USERID=21882

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='13893' 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='13893' 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=71665 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=71665 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=71667 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=71667 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=71668 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=71668 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=71669 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=71669 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=71670 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=71670 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=71671 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=71671 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=71672 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=71672 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=71673 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=71673 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=71674 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=71674 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=71677 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=71677 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=71679 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=71679 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=71680 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=71680 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=71681 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=71681 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=71682 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=71682 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=71683 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=71683 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=71684 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=71684 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=71685 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=71685 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=71686 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=71686 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=71687 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=71687 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=71688 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=71688 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=71689 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=71689 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=71690 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=71690 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=71691 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=71691 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=71692 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=71692 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=71693 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=71693 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=71694 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=71694 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=71695 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=71695 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=71696 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=71696 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=71697 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=71697 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=71698 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=71698 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=71699 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=71699 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=71700 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=71700 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=71701 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=71701 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=71702 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=71702 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=71703 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=71703 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=71704 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=71704 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=71706 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=71706 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=71707 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=71707 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=71709 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=71709 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=71711 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=71711 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=71712 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=71712 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=71713 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=71713 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=71714 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=71714 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=71715 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=71715 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=71716 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=71716 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=71717 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=71717 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=71719 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=71719 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='13893' AND status='1' AND (question like '%awesome SEO Clerks affiliate widget, convert 300% more, FREE! ;)%' OR question like '%awesome%' OR question like '%Clerks%' OR question like '%affiliate%' OR question like '%widget,%' OR question like '%convert%' OR question like '%300%%' OR question like '%more,%' OR question like '%FREE!%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='13893' AND status='1' AND (question like '%awesome SEO Clerks affiliate widget, convert 300% more, FREE! ;)%' OR question like '%awesome%' OR question like '%Clerks%' OR question like '%affiliate%' OR question like '%widget,%' OR question like '%convert%' OR question like '%300%%' OR question like '%more,%' OR question like '%FREE!%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

select * from 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.1038901SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 28426 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Youtub Youtubeservice Subscribers%' ) LIMIT 40.1038900.103890
0.1013361SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Dofollowbac%') ORDER BY total_recommendations desc LIMIT 0,400.1013360.101336