SEOClerks

Clear
Sign In Join

How to create coupon code and using "Pay With A Tweet"

  • sunil0021 Level 1
    • 32

    Write the reason you're deleting this FAQ

    How to create coupon code and using "Pay With A Tweet"

    Hi friends,

    today i tell you how to create a coupon code and how to use pay with a tweet - With this you get more sales !

    • Create coupon code like this :

    How to create coupon code and using "Pay With A Tweet"

    • Now copy that code in text file and save it on desktop !
    • Now go here and fill the details given in image : Pay With A Tweet

    How to create coupon code and using "Pay With A Tweet"

    • Select options according to your settings !
    • Now click create my button - After that you will be redirected to a new page,
    • Copy first link from there:

    How to create coupon code and using "Pay With A Tweet"

    • Now add the below code in source section of your service :

    [color=#ff0000][b][size=200][url=http://Pay with a tweet link here][img=https://www.seoclerks.com/files/user/images/_Discounted_Gig_animation_10_200_64bt.gif][/img][/url]


    You can also use different image by adding new in the above code [According to your need]


    In the above code replace this text Pay with a tweet link here
    with your link



    That's it now when someone tweet your service link you get more visitors and the buyer get discount !
    Hope you all like my tutorial How to create coupon code and using "Pay With A Tweet" don't forget to like this, Reply below if something is missing !

    - Sunil Bishnoi

    # Tutorials & Guides
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    robertman11

    robertman11

    Pretty cool tutorial!
    13 years ago

    Are you sure you want to delete this post?

    sunil0021

    sunil0021

    Pretty cool tutorial!


    Thanks robert How to create coupon code and using "Pay With A Tweet"
    13 years ago

    Are you sure you want to delete this post?

    hitmeasap

    hitmeasap

    Cool tutorial!

    Maybe I'm just to stupid to understand, but what do you mean by:
    "url of file containing coupon" ?

    Do you mean the actual url to the service I created a coupon for?

    Cheers,
    hitmeasap
    13 years ago

    Are you sure you want to delete this post?

    sunil0021

    sunil0021

    Cool tutorial!

    Maybe I'm just to stupid to understand, but what do you mean by:
    "url of file containing coupon" ?

    Do you mean the actual url to the service I created a coupon for?

    Cheers,
    hitmeasap


    Check the 2nd step again ! I mean when someone tweet your link they get a text file which contain coupon code of your service How to create coupon code and using "Pay With A Tweet"

    - Sunil Bishnoi
    13 years ago

    Are you sure you want to delete this post?

    Recommended

    Recommended

    thank you sir for your tutorial
    13 years ago

    Are you sure you want to delete this post?

    angie828

    angie828

    Great job on thisHow to create coupon code and using "Pay With A Tweet"
    13 years ago

    Are you sure you want to delete this post?

    tangee

    tangee

    Nice tutorial. Explained very well.
    13 years ago

    Are you sure you want to delete this post?

    exjordanary

    exjordanary

    I see you ordered my Gig and tried your best make a Tutorial out of it. NICE!! Thank u.
    A couple things:

    • Twitter's API has been BLOCKING all Tweets from PaywithaTweet from being Tweeted if the Tweet contains a Link back to your Gig on SEOClerks (doesn't matter which URL Shortener you use) - This is because Twitter has Marked SEOClerks as a SPAM Site. So the User will gain access to your Coupon, but you won't get a Tweet linking to your gig. If you DO manage to get a couple through, when a User clicks on the URL on Twitter, they'll still get the "Twitter UNSAFE SITE Warning Page". One way around this is purchasing a New Domain and creating a Frame Redirect- then subtracting a couple things from the Service URL. (or, there's always the option of keeping things simple and ordering my Gig and I'll do all this for you - OR - ordering a Landing Page at CommunityClerks featuring only your Gigs with YOUR Affiliate ID's embedded into each Service URL so u can have the Tweets Link back to your Landing Page so u can gain Sales AND Affiliates- BTW- I have 2,000 Active Affiliates and average 20 to 35 New ones per day that mostly come from these Pages)

    • The Image you offered
      [url=https://www.seoclerks.com/files/user/images/_Discounted_Gig_animation_10_200_64bt.gif][url=https://www.seoclerks.com/files/user/images/_Discounted_Gig_animation_10_200_64bt.gif][img=https://www.seoclerks.com/files/user/images/_Discounted_Gig_animation_10_200_64bt.gif][/img][/url][/url]
      is only good for 10% Off:

    How to create coupon code and using "Pay With A Tweet"

    What about the other 90%?

    I guess, since I am the original Creator of this Image, if anyone needs a different Percentage, please let me know. But I highly doubt anyone will want those old Designs.
    Since the New Theme, I have Redesigned my PWAT Buttons which are a much more Suitable Match.


    How to create coupon code and using "Pay With A Tweet"


    What's cool with the new theme is you can float the Top Button to the LEFT, and the Bottom Button to the RIGHT via the
    [left][/left], [right][/right]
    BBCode functions.

    How to create coupon code and using "Pay With A Tweet"


    It'll make sense once you see how the New layout is.

    I've spent way too much of my time designing ALL Original Images, & Videos for all my Gigs as well as EVERY Single Image on the Blog (CommunityClerks) and have even lost Jobs over this- because I don't believe in Copying other Works from Google Images, etc. (unless it's from Derek How to create coupon code and using "Pay With A Tweet" -).

    So PLEASE, if you want to use the images above, or if you need a different Discount Percentage, just ask. I will ALWAYS be cool with it - Heck, I may even provide the PSD as a Free Download via PWAT in the "Resources" Section of the Blog one day.

    • Lastly, and MOST Importantly, there is no need to "Download" a Text Document containing your Coupon Code. Plus, this would mean that after a User Tweets your gig just ONCE, they have Your Code now- So they'd have no incentive to Tweet/Share your Gig each time unless you keep changing it (which means updating your PWAT Button, every time) You may as well display it publicly.

    But- There is a way to embed your Code into the Checkout URL, (and even Your affiliate Link too) so that the whole process functions Seamlessly from start to finish w/ discount applied to Total and User redirected to Service Checkout once they've Tweeted. I will be making a Tutorial on this (until then- feel free to order my gig)


    How to create coupon code and using "Pay With A Tweet"
    13 years ago

    Are you sure you want to delete this post?

    exjordanary

    exjordanary

    13 years ago

    Are you sure you want to delete this post?

    loulou

    loulou

    Seems like it will help someone out.
    13 years ago

    Are you sure you want to delete this post?

    clipping

    clipping

    Great tutorial. It's very helpful for me. I learn a lot to read and like this tutorial. Thanks...
    12 years ago

    Are you sure you want to delete this post?

    wikicrunch

    wikicrunch

    Cool work man
    12 years ago

    Are you sure you want to delete this post?

    tionna

    tionna

    Nice tutorial!
    12 years ago

    Are you sure you want to delete this post?

    iArvi

    iArvi

    Nice tutorial dude...Social Payment is the latest trend...and pay with a tweet or a like/follow is indeed very useful..Thanks again
    12 years ago

    Are you sure you want to delete this post?

    sunil0021

    sunil0021

    Thank you for letting me know i have updated the link.

    - Sunil Bishnoi
    12 years ago

    Are you sure you want to delete this post?

    blueeyes

    blueeyes

    Thanks so much for this! It is very helpful.
    12 years ago

    Are you sure you want to delete this post?

    rejvi

    rejvi

    Nice tutorial.
    12 years ago

    Are you sure you want to delete this post?

    ssam

    ssam

    Thanks I Will Soon Start Creating it.
    12 years ago

    Are you sure you want to delete this post?

    Roshu

    Roshu

    Thanks for this! Never heard about paywithatweet untill now, could be very useful for promoting, I'll check it out and see how it works out. Thanks Sunil!
    12 years ago

    Are you sure you want to delete this post?

    nextsocialworld

    nextsocialworld

    Hi friends,

    today i tell you how to create a coupon code and how to use pay with a tweet - With this you get more sales !

    • Create coupon code like this :

    How to create coupon code and using "Pay With A Tweet"

    • Now copy that code in text file and save it on desktop !
    • Now go here and fill the details given in image : Pay With A Tweet

    How to create coupon code and using "Pay With A Tweet"

    • Select options according to your settings !
    • Now click create my button - After that you will be redirected to a new page,
    • Copy first link from there:

    How to create coupon code and using "Pay With A Tweet"

    • Now add the below code in source section of your service :

    [color=#ff0000][b][size=200][url=http://Pay with a tweet link here][url=https://www.seoclerks.com/files/user/images/_Discounted_Gig_animation_10_200_64bt.gif][img=https://www.seoclerks.com/files/user/images/_Discounted_Gig_animation_10_200_64bt.gif][/img][/url][/url]


    You can also use different image by adding new in the above code [According to your need]


    In the above code replace this text Pay with a tweet link here
    with your link



    That's it now when someone tweet your service link you get more visitors and the buyer get discount !
    Hope you all like my tutorial How to create coupon code and using "Pay With A Tweet" don't forget to like this, Reply below if something is missing !

    - Sunil Bishnoi

    wow!!thanks for sharing!!
    12 years ago

    Are you sure you want to delete this post?

    andreasjordan

    andreasjordan

    Amazing, thanks for the tutorial
    12 years ago

    Are you sure you want to delete this post?

    twilight

    twilight

    Looks easy to do. Thanks for the tips.
    11 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 2.9169011116028

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=231121SELECT googleplus_profile FROM seoclerks.members WHERE USERID=23112

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

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12096' 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='12096' 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=56008 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=56008 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=56009 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=56009 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=56010 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=56010 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=56011 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=56011 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=56012 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=56012 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=56013 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=56013 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=56014 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=56014 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=56015 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=56015 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=56016 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=56016 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=56017 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=56017 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=56019 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=56019 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=56020 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=56020 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=56021 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=56021 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=56022 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=56022 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=56026 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=56026 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=56028 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=56028 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=56029 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=56029 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=56030 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=56030 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=56031 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=56031 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=56032 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=56032 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=56034 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=56034 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=56038 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=56038 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='12096' AND status='1' AND (question like '%How create coupon code "Pay Tweet"%' OR question like '%create%' OR question like '%coupon%' OR question like '%code%' OR question like '%"Pay%' OR question like '%Tweet"%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='12096' AND status='1' AND (question like '%How create coupon code "Pay Tweet"%' OR question like '%create%' OR question like '%coupon%' OR question like '%code%' OR question like '%"Pay%' OR question like '%Tweet"%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='7' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='7' 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=12096%' 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=12096%' 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='9.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='9.png'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='132232.png'1SELECT 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='217574.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='217574.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.4067071SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (89) AND gtags like'%sports%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4067070.406707
    0.1826841SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID 0.1826840.182684