How to Embed Coupon Codes & Affiliate ID's into Service URLs

exjordanary Level X⁵

October 11, 2013, 2:25 pm

Write the reason you're deleting this FAQ

How to Embed Coupon Codes & Affiliate ID's into Service URLs

Every Service on SEOClerks has a Unique Service ID Number.
If you browse through a few different Services, you'll notice a Number located in each URL following the "Category".

For example, the URL below is in the "Youtube" Category:

https://www.seoclerks.com/ youtube/19672/3-Bucks-OFF-20k-100k-YOUTUBE-Views-15-100-Likes-10-200-Video-Favs-PLUS-30-100-Channel-Subscribers

And it's Unique Service ID Number is: 19672

Let's Say you had a Service in the "Traffic" Category and the URL was:

https://www.seoclerks.com/Traffic/ 7579/Guarantee-Targeted-Ad-Clicks-for-0-03-CPC-or-Less-on-Real-Human-Traffic-4-LIFE

And you created a 20% Coupon Code for the above Service called: "TwentyOFF"

CLICK HERE FOR TUTORIAL ON HOW TO CREATE COUPONS FOR YOUR SERVICE

You can create a SINGLE URL that would AUTOMATICALLY APPLY the 20% Discount to your Gig WITHOUT having to give out your Coupon Code or Display it Publicly (as seen below):

https://www.seoclerks.com/order?id=7579&coupon=TwentyOFF

Simply Take the Unique Service ID (found after the "Category" in your Service URL:

https://www.seoclerks.com/Traffic/ 7579/Guarantee-Targeted-Ad-Clicks-for-0-03-CPC-or-Less-on-Real-Human-Traffic-4-LIFE

and Put your Coupon Code TwentyOFF at the End:

https://www.seoclerks.com/ order?id=7579&coupon=TwentyOFF <-----Go ahead, try it!!

You can even embed your Affiliate ID <---Click to find yours

So if your Affiliate ID is: https://www.seoclerks.com/ linkin/3764/

Then, you can add it as such:

https://www.seoclerks.com/linkin/3764/order?id=7579&coupon=TwentyOFF

The Discount will Automatically be Applied and Subtracted from the Total

-And you can do this with ANY Discount Percentage!! The possibilities are endless.

So let's call the above URL a "Discount URL"

Use your favorite URL Shortener and give discounts to Special People- or use it as an Incentive for people to Share or Tweet your Message for access to the Discount URL. (which is what I do).

Apps such as PWAT (PaywithaTweet) will keep your Discount URL Hidden, then Automatically Re-Direct Users to your Discount URL once they Tweet or Share your Message.

Choose what you want shared and which Social Networks you want people to Share to (keeping in mind that Twitter no longer allows anything Linking back to SEOClerks).

Once you're finished, you'll be provided with a Link that you can use which will look like this:
https://www.paywithatweet.com/pay/ ?id=d225952702f09ece74e8aceb1905cca7

Which I'll usually shorten:
http://goo.gl/5VfliY

Then, I'll I use these in my Gigs to offer incentives for Discounts. I'll usually place this Button I made to match the New Theme at the Top of My Services:

Can also Apply to FB LeadGates', RSS Feeds, and many more features ETC,

Ok, hope this helps,

Comments

Please login or sign up to leave a comment

Join

angie828

Good tutorial!

13 years ago

Are you sure you want to delete this post?

jakemadness

Nice diagram showing us all how it works

How to Embed Coupon Codes & Affiliate ID

13 years ago

Are you sure you want to delete this post?

exjordanary

If you want a license to use these Buttons in your Services -

including multiple Buttons with different Percentages, let me know.
Thanks

12 years ago

Are you sure you want to delete this post?

puttter

Nice,,

thank you for this tutorials..

12 years ago

Are you sure you want to delete this post?

twayne

Just learned how discount coupons work..something have been looking for and also how to embed. Thanks

12 years ago

Are you sure you want to delete this post?

SyedBahadurShah

Really Great Post

- Syed Bahadur Shah

12 years ago

Are you sure you want to delete this post?

dragonhunter95

good one , thank you;)

12 years ago

Are you sure you want to delete this post?

rejvi

Great tutorial.

12 years ago

Are you sure you want to delete this post?

nextsocialworld

Every Service on SEOClerks has a Unique Service ID Number.
If you browse through a few different Services, you'll notice a Number located in each URL following the "Category".

For example, the URL below is in the "Youtube" Category:

https://www.seoclerks.com/ youtube/19672/3-Bucks-OFF-20k-100k-YOUTUBE-Views-15-100-Likes-10-200-Video-Favs-PLUS-30-100-Channel-Subscribers

And it's Unique Service ID Number is: 19672

Let's Say you had a Service in the "Traffic" Category and the URL was:

https://www.seoclerks.com/Traffic/ 7579/Guarantee-Targeted-Ad-Clicks-for-0-03-CPC-or-Less-on-Real-Human-Traffic-4-LIFE

And you created a 20% Coupon Code for the above Service called: "TwentyOFF"

CLICK HERE or IMAGE BELOW FOR TUTORIAL ON HOW TO CREATE COUPONS FOR YOUR SERVICE:

You can create a SINGLE URL that would AUTOMATICALLY APPLY the 20% Discount to your Gig WITHOUT having to give out your Coupon Code or Display it Publicly (as seen below):

https://www.seoclerks.com/ order?id=7579&coupon=TwentyOFF

Simply Take the Unique Service ID (found after the "Category" in your Service URL:

https://www.seoclerks.com/Traffic/ 7579/Guarantee-Targeted-Ad-Clicks-for-0-03-CPC-or-Less-on-Real-Human-Traffic-4-LIFE

and Put your Coupon Code TwentyOFF at the End:

https://www.seoclerks.com/ order?id=7579&coupon=TwentyOFF <-----Go ahead, try it!!

You can even embed your Affiliate ID <---Click to find yours

So if your Affiliate ID is: https://www.seoclerks.com/ linkin/####/

Then, you can add it as such:

https://www.seoclerks.com/linkin/####/order?id=7579&coupon=TwentyOFF

Notice the 20% Discount Automatically Applied and Subtracted from the Total? (don't worry, you can click the above without committing to a purchase- it's merely viewing a Shopping Cart)

-And you can do this with ANY Discount Percentage!! The possibilities are endless.

So let's call the above URL a "Discount URL"

Use your favorite URL Shortener and give discounts to Special People- or use it as an Incentive for people to Share or Tweet your Message for access to the Discount URL. (which is what I do).

Apps such as PWAT (PaywithaTweet) will keep your Discount URL Hidden, then Automatically Re-Direct Users to your Discount URL once they Tweet or Share your Message.

Choose what you want shared and which Social Networks you want people to Share to (keeping in mind that Twitter no longer allows anything Linking back to SEOClerks).

Once you're finished, you'll be provided with a Link that you can use which will look like this:
https://www.paywithatweet.com/pay/ ?id=d225952702f09ece74e8aceb1905cca7

Which I'll usually shorten:
http://goo.gl/ HzuRuz

Then, I'll I use these in my Gigs to offer incentives for Discounts. I'll usually place this Button I made to match the New Theme at the Top of my Gig:

Here's a Quick Video I made a while back, which explains the process:

Ok, hope this helps,

wow thanks for sharing :cool: [quote]Every Service on SEOClerks has a Unique Service ID Number. If you browse through a few different Services, you'll notice a Number located in each URL following the "Category". For example, the URL below is in the "[U][COLOR=#ff0080]Youtube[/COLOR]" Category[/U]: [U][url]https://www.seoclerks.com/[/url] [COLOR=#ff0080]youtube[/COLOR]/[COLOR=#00b359]19672[/COLOR]/3-Bucks-OFF-20k-100k-YOUTUBE-Views-15-100-Likes-10-200-Video-Favs-PLUS-30-100-Channel-Subscribers[/U] And it's Unique [U]Service ID Number[/U] is: [COLOR=#00b300]19672[/COLOR] Let's Say you had a Service in the "[COLOR=#ff0080]Traffic[/COLOR]" Category and the URL was: [U][url]https://www.seoclerks.com/[/url][COLOR=#ff0080]Traffic[/COLOR]/[COLOR=#00b359] 7579[/COLOR]/Guarantee-Targeted-Ad-Clicks-for-0-03-CPC-or-Less-on-Real-Human-Traffic-4-LIFE[/U] And you created a [I][B]20% Coupon Code[/B][/I] for the above Service called: "[B][COLOR=#ff8000]TwentyOFF[/COLOR][/B]" [B][U][COLOR=#0000ff][I]CLICK HERE[/I][/COLOR][COLOR=#ff0000] or IMAGE BELOW[/COLOR] FOR TUTORIAL ON HOW TO CREATE COUPONS FOR YOUR SERVICE[/U]: [url=http://communityclerks.com/wp-content/uploads/2013/10/Screen-shot-2013-10-11-at-4.06.28-AM6.png][IMG]http://communityclerks.com/wp-content/uploads/2013/10/Screen-shot-2013-10-11-at-4.06.28-AM6.png[/IMG][/url] [/B] You can create a [U][B]SINGLE URL[/B][/U] that would [B][I]AUTOMATICALLY[/I] APPLY the 20% Discount to your Gig[/B] [U]WITHOUT[/U] having to give out your Coupon Code or Display it Publicly (as seen below): [U][url]https://www.seoclerks.com/[/url] order?id=7579&coupon=TwentyOFF[/U] Simply Take the Unique Service ID (found after the "Category" in your Service URL: [U][url]https://www.seoclerks.com/Traffic/[/url][COLOR=#00b359] 7579[/COLOR]/Guarantee-Targeted-Ad-Clicks-for-0-03-CPC-or-Less-on-Real-Human-Traffic-4-LIFE[/U] and Put your Coupon Code [I][COLOR=#ff8000]TwentyOFF[/COLOR] [/I]at the End: [U][url]https://www.seoclerks.com/[/url] order?id=[COLOR=#00b359]7579[/COLOR]&coupon=[I][COLOR=#ff8000]TwentyOFF[/COLOR][/I][/U] [B]<-----Go ahead, try it!! [/B] You can even embed your Affiliate ID [B]<---Click to find yours[/B] So if your Affiliate ID is: [U][url]https://www.seoclerks.com/[/url] [COLOR=#ff0000]linkin/####[/COLOR]/[/U] [U][B]Then, you can add it as such[/B][/U]: [U][url]https://www.seoclerks.com/[/url][COLOR=#ff0000]linkin/####[/COLOR]/order?id=[COLOR=#00b359]7579[/COLOR]&coupon=[I][COLOR=#ff8000]TwentyOFF[/COLOR][/I][/U] [B][U]Notice the 20% Discount Automatically Applied and Subtracted from the Total?[/U][/B] (don't worry, you can click the above without committing to a purchase- it's merely viewing a Shopping Cart) -And you can do this with ANY Discount Percentage!! The possibilities are endless. So let's call the above URL a [B][U][I]"Discount URL"[/I][/U][/B] Use your favorite URL Shortener and give discounts to Special People- or use it as an Incentive for people to Share or Tweet your Message for access to the [U]Discount URL[/U]. (which is what I do). Apps such as PWAT ([B][U][COLOR=#0000ff]PaywithaTweet[/COLOR][/U][/B]) will keep your [U]Discount URL[/U] Hidden, then Automatically Re-Direct Users to your [U]Discount URL[/U] once they Tweet or Share your Message. [url=http://communityclerks.com/wp-content/uploads/2013/10/Screen-shot-2013-10-11-at-10.52.43-AM.png][IMG]http://communityclerks.com/wp-content/uploads/2013/10/Screen-shot-2013-10-11-at-10.52.43-AM.png[/IMG][/url] Choose what you want shared and which Social Networks you want people to Share to (keeping in mind that Twitter no longer allows anything Linking back to SEOClerks). Once you're finished, you'll be provided with a Link that you can use which will look like this: [U][url]https://www.paywithatweet.com/pay/[/url] ?id=d225952702f09ece74e8aceb1905cca7[/U] Which I'll usually shorten: [U][url]http://goo.gl/[/url] HzuRuz[/U] Then, I'll I use these in my Gigs to offer incentives for Discounts. I'll usually place this Button I made to match the New Theme at the Top of my Gig: [url=https://www.seoclerks.com/files/user/images/_20-OFF-NEW-Theme_button.png][IMG]https://www.seoclerks.com/files/user/images/_20-OFF-NEW-Theme_button.png[/IMG][/url] Here's a Quick Video I made a while back, which explains the process: [media=youtube]L6AGuJd11Gw[/media] Ok, hope this helps,[/quote] wow thanks for sharing :cool:

12 years ago

Are you sure you want to delete this post?

sweetcupcake

Good share. Looks easy enough to do.

12 years ago

Are you sure you want to delete this post?

IshaMukherjee

i'll definitely try

12 years ago

Are you sure you want to delete this post?

exjordanary

Just so you know, you can now go to your service after you create and activate a Coupon Code, and if you right-click on your coupon, and copy the Link, It'll give you the URL u need (minus your Affiliate ID):

(REMINDER: The Service's Coupons shown below are only visible to YOU, while you're signed in - NOBODY else can see them!!)

Remember, you'll always get an error when trying to use Test your own Discount URLs since you can't purchase from yourself. So make sure you're careful to do this properly.

Then, you can add your affiliate ID after the domain, or, as shown below:

Also, instead of this standard format:
https://www.seoclerks.com/linkin/3764/order?id=7579&coupon=TwentyOFF

Alternatively, you can format your Discount URL like this:
https://www.seoclerks.com/order?id=7579&coupon=TwentyOFF&aff=3764

Try THIS one to test:
https://www.seoclerks.com/order?id=5635&coupon=newsletter&aff=3764

It also REALLY REALLY makes a HUGE difference when you add a button at the bottom of the service on the RIGHT side of the Page using BBCode - just use the word "right" in [brackets] with [opening] and [/closing] brackets on each side of the image like this:

[right][url=https://www.seoclerks.com/files/user/images/20r-OFF-FB-LIKE-button.png][url=https://www.seoclerks.com/files/user/images/20r-OFF-FB-LIKE-button.png][img=https://www.seoclerks.com/files/user/images/20r-OFF-FB-LIKE-button.png][/img][/url][/url][/right]

Which would result in THIS:

Because people usually read the Service before they place an Order, which by that time, they're at the bottom of your page and if your Service has lots of Feedback, your Discount button shows up WAY before the actual checkout button - scroll to the bottom of THIS SERVICE and you'll see what I mean.

-ex Just so you know, you can now go to your service after you create and activate a Coupon Code, and if you right-click on your coupon, and copy the Link, It'll give you the URL u need (minus your Affiliate ID): [B][COLOR=#ff0000](REMINDER: The Service's Coupons shown below are only visible to YOU, while you're signed in - NOBODY else can see them!!)[/COLOR][/B] [url=https://www.seoclerks.com/files/user/images/Screen%20Shot%202014-10-19%20at%202_07_03%20AM.png][IMG]https://www.seoclerks.com/files/user/images/Screen%20Shot%202014-10-19%20at%202_07_03%20AM.png[/IMG][/url] Remember, you'll always get an error when trying to use Test your own Discount URLs since you can't purchase from yourself. So make sure you're careful to do this properly. [B][U]Then, you can add your affiliate ID after the domain, or, as shown below:[/U][/B] [B]Also, instead of this standard format:[/B] [U][url]https://www.seoclerks.com/linkin/[/url][COLOR=#ff0000]3764[/COLOR]/order?id=[COLOR=#00b300]7579[/COLOR]&coupon=[COLOR=#ff8000]TwentyOFF[/COLOR][/U] [B]Alternatively, you can format your Discount URL like this:[/B] [U][url]https://www.seoclerks.com/order?id=[/url][COLOR=#00b300]7579[/COLOR]&coupon=[COLOR=#ff8000]TwentyOFF[/COLOR]&aff=[COLOR=#ff0000]3764[/COLOR][/U] [B]Try THIS one to test:[/B] [url=https://www.seoclerks.com/order?id=5635&coupon=newsletter&aff=3764][U][B]https://www.seoclerks.com/order?id=5635&coupon=newsletter&aff=3764[/B][/U][/URL] [B][SIZE=5]It also REALLY REALLY makes a HUGE difference when you add a button at the bottom of the service on the RIGHT side of the Page using BBCode - just use the word "right" in [brackets] with [opening] and [/closing] brackets on each side of the image like this: [/SIZE][/B] [CODE][right][url=https://www.seoclerks.com/files/user/images/20r-OFF-FB-LIKE-button.png][url=https://www.seoclerks.com/files/user/images/20r-OFF-FB-LIKE-button.png][IMG]https://www.seoclerks.com/files/user/images/20r-OFF-FB-LIKE-button.png[/IMG][/url][/url][/right][/CODE] [RIGHT] [B]Which would result in THIS: [/B] [url=http://on.fb.me/1a0sYpg][url=https://www.seoclerks.com/files/user/images/20r-OFF-FB-LIKE-button.png][url=https://www.seoclerks.com/files/user/images/20r-OFF-FB-LIKE-button.png][IMG]https://www.seoclerks.com/files/user/images/20r-OFF-FB-LIKE-button.png[/IMG][/url][/url][/URL] [/RIGHT] [SIZE=5]Because people usually read the Service before they place an Order, which by that time, they're at the bottom of your page and if your Service has lots of Feedback, your Discount button shows up WAY before the actual checkout button - scroll to the bottom of [url=https://www.seoclerks.com/linkin/3764/Traffic/20349/][B][I][U]THIS SERVICE[/U][/I][/B][/URL] and you'll see what I mean. -ex[/SIZE]

12 years ago

Are you sure you want to delete this post?

rejvi

Got a problem.. when the user is not logged in the order page redirects to order_signup page and the coupon code goes away from url.

12 years ago

Are you sure you want to delete this post?

exjordanary

Got a problem.. when the user is not logged in the order page redirects to order_signup page and the coupon code goes away from url.

@rejvi

SO if you had your Affiliate URL embedded, that's good. That would mean you gained a potential Affiliate. It shouldn't be too difficult for them to either find your Gig again after that sign in, or for you to simply add some Text, or a Banner telling people to Signin/Up before checking out and that way it will open the signup window in a new frame so they won't lose your Service Page.

Simply link it to the signup Page via your Affiliate Link in your Gig's Description.

This can also increase your Chances of Gaining more Affiliates all-around- since over 30% of Shoppers are NON-Members anyways.

I made this Banner and stuck it in all my Gigs with my Affiliate ID included a while back:

So I would suggest making something similar.

Also, have you tried formatting your Coupon URL like this?:
https://www.seoclerks.com/order?id...OFF&aff=3764

rather than like the original way shown above???

See if that redirects them properly.

Thanks!!

12 years ago

Are you sure you want to delete this post?

rejvi

Thank you @exjordanary

Also, have you tried formatting your Coupon URL like this?:
https://www.seoclerks.com/order?id...OFF&aff=3764
rather than like the original way shown above???
See if that redirects them properly.

No luck. The idea of a Banner telling people to Signin/Up before checking out is great!

12 years ago

Are you sure you want to delete this post?

exjordanary

STEP ONE:
Signup/in to SEOClerks via THIS LINK (which would include your affiliate Link)
Just say something like,
"Must first be signed in using the Link above or Discount Link will not work"

STEP TWO:
CLICK HERE Access Discount Page

Also, now that Facebook has changed it's Policy on "Fangates", you can NOT make people "Like" you anymore. So here's the solution:

If you'd like to Test out the experience I've setup, try the New Discount Buttons (I had to make) at THIS SERVICE)

Or, you can try them below:

But Asking Users to Subscribe to something or perform any other Social Action is accepted by Facebook's new Terms.

So just use an HTML Static iFrame to create a Form.

Here's the Code I used for the "Subscription Gate" used at the Page from the Buttons above (Copy & Paste it into your iFrame Tab on Facebook):

[HTML] <link href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.0/css/bootstrap.min.css" rel="stylesheet">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/3.3.0/js/bootstrap.min.js"></script>
<style>
body {margin:32px;} .btn {padding: 6px 74px;}
</style>
<body>

<div class="container">
<div class="row">
<h3> <p style="text-align: center; ">Fill Out Form Below for Access to FULL Tutorial:</h3></p>
</div>
<p><b><u><p style="text-align: center; ">Be sure to Provide your <i>"SEOClerk Username"</i> either in the <i>"Username" Field</i>, or the <i>"Message" Box</u></i></b></p>
<p><p style="text-align: center; "><i>(MUST use your REAL email address because we will be sending you a Confirmation email after you've placed the Order so we can Verify you're a HUMAN and not a BOT -We can only Proceed with Orders once your Info is Confirmed)</i></p>
<div class="row">
<div class="col-md-4">
<form role="form">
<div class="form-group">
<label class="control-label">SEOClerks Username</label>
<input name="name" class="form-control" placeholder="enter name">
</div>
<div class="form-group">
<label class="control-label">a REAL Email Address</label>
<input name="email" class="form-control" placeholder="enter email">
</div>
<div class="form-group">
<label class="control-label">Additional Notes, etc</label>
<textarea class="form-control" rows="3"></textarea>
</div>
<button type="submit" class="btn btn-success">Submit</button>
</form>
</div>
</div>
</div>

</body>

<div align="left"><p><img src="http://communityclerks.com/wp-content/uploads/2013/09/3_big_RED_arrow_diff-Pattern64-e1384215719953.gif" alt="Click 'Like' to get this Discount!!" title="Click 'Like' to get this Discount!!" border="0" /></a></a></a></div>
</a></div>[/HTML]

Hope this helps.
-ex [CENTER][B][U]STEP ONE:[/U][/B] Signup/in to SEOClerks via [url=http://a.seoclerks.com/linkin/3764/signup][U][B][I]THIS LINK[/I][/B][/U][/URL] (which would include your affiliate Link) Just say something like, [I][B]"Must first be signed in using the Link above or Discount Link will not work" [/B][/I] [B][U]STEP TWO: [/U][/B] [url=https://www.seoclerks.com/order?id=5635&coupon=newsletter&aff=3764][U][B][I]CLICK HERE[/I][/B][/U][/URL] Access Discount Page [/CENTER] Also, now that Facebook has changed it's Policy on "Fangates", you can NOT make people "Like" you anymore. So here's the solution: If you'd like to Test out the experience I've setup, try the New Discount Buttons (I had to make) at [url=https://www.seoclerks.com/linkin/3764/Traffic/20349/][B][U][I]THIS SERVICE[/I][/U][/B][/URL]) [CENTER]Or, you can try them below: [/CENTER] [LEFT][url=http://bit.ly/1ojJE3z][url=https://www.seoclerks.com/files/user/images/20-of.png][IMG]https://www.seoclerks.com/files/user/images/20-of.png[/IMG][/url][/URL][/LEFT] [RIGHT][url=http://bit.ly/1ojJE3z][url=https://www.seoclerks.com/files/user/images/20-off.png][IMG]https://www.seoclerks.com/files/user/images/20-off.png[/IMG][/url][/URL][/RIGHT] [CENTER][B][U]But Asking Users to Subscribe to something or perform any other Social Action [I][COLOR=#ff0000]is[/COLOR][/I] accepted by Facebook's new Terms.[/U][/B] So just use an HTML Static iFrame to create a Form. [B][U]Here's the Code I used for the "[/U][/B][url=https://www.facebook.com/InstaGate?sk=app_160430850678443][I][B][U][COLOR=#0000ff]Subscription Gate[/COLOR][/U][/B][/I][/URL][B][U]" used at the Page from the Buttons above [/U][/B][U](Copy & Paste it into your iFrame Tab on Facebook)[/U]:[/CENTER] [HTML]

Fill Out Form Below for Access to FULL Tutorial:

Be sure to Provide your "SEOClerk Username" either in the "Username" Field, or the "Message" Box

(MUST use your REAL email address because we will be sending you a Confirmation email after you've placed the Order so we can Verify you're a HUMAN and not a BOT -We can only Proceed with Orders once your Info is Confirmed)

Click 'Like' to get this Discount!!

[/HTML] Hope this helps. -ex

11 years ago

Are you sure you want to delete this post?

SEOClerks

How to Embed Coupon Codes & Affiliate ID's into Service URLs

How to Embed Coupon Codes & Affiliate ID's into Service URLs

Comments

Please login or sign up to leave a comment

angie828

jakemadness

exjordanary

puttter

twayne

SyedBahadurShah

dragonhunter95

rejvi

nextsocialworld

sweetcupcake

IshaMukherjee

exjordanary

rejvi

exjordanary

rejvi

exjordanary

Fill Out Form Below for Access to FULL Tutorial:

Invalid SQL

Expensive SQL

Suspicious SQL

Match	Count	SQL	Script
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='12098'	1	SELECT 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='12098'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='3764'	1	SELECT * FROM seoclerks.members WHERE USERID='3764'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM seoclerks.members WHERE USERID=3764	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=3764	/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=12098 LIMIT 5	1	SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=12098 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12098' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	1	SELECT 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='12098' 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=56057 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56057 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=56058 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56058 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=56059 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56059 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=56061 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56061 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=56062 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56062 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=56063 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56063 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=56066 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56066 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=56067 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56067 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=56068 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56068 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=56069 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56069 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=56071 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56071 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=56072 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56072 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=56073 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56073 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=56074 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56074 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=56075 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56075 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=56076 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56076 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='12098'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='12098'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='12098' AND status='1' AND (question like '%How Embed Coupon Codes & Affiliate ID\'s Service URLs%' OR question like '%Embed%' OR question like '%Coupon%' OR question like '%Codes%' OR question like '%&%' OR question like '%Affiliate%' OR question like '%ID\'s%' OR question like '%Service%' OR question like '%URLs%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='12098' AND status='1' AND (question like '%How Embed Coupon Codes & Affiliate ID\'s Service URLs%' OR question like '%Embed%' OR question like '%Coupon%' OR question like '%Codes%' OR question like '%&%' OR question like '%Affiliate%' OR question like '%ID\'s%' OR question like '%Service%' OR question like '%URLs%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='5392' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='5392' 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 1	1	SELECT 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='3644' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='3644' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='1490' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1490' 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 1	1	SELECT 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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=12098%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	1	SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=12098%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM categories	1	SELECT * FROM categories	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
select * from categories_software order by name asc	1	select * 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 asc	1	select * 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 asc	1	select * 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='632.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='632.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='33015.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='33015.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='3764.png'	1	SELECT 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='40977.gif'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='40977.gif'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='292.gif'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='292.gif'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='58499.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='58499.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='56997.jpg'	1	SELECT 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='224642.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='224642.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='132232.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='132232.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='49776.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='49776.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
select * from categories_faq order by name asc	1	select * from categories_faq order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()