SEOClerks

Clear
Sign In Join

Fun Friday Contest-Most Unique Promotion Method

  • EricElliott Level 1
    • 14

    Write the reason you're deleting this FAQ

    Fun Friday Contest-Most Unique Promotion Method

    Hello Clerks Nation,

    It's time again for the Fun Friday Contest.

    For this weeks contest, we want to find the most unique method you have used to promote SEOClerks. This can include on or offline methods and of course, it should be interesting.

    The winner of the contest will receive a $25 coupon and the contest will conclude on Monday, May 5th at 12:00 a.m. EST.

    Good luck to everyone!

    # Announcements
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    sunil0021

    sunil0021

    Here are my methods i use to promote SC:

    1. My Website: iloveseoclerks.com
    2. Talking with my class friends and telling them about SEOClerks ($5 promo)
    3. Yahoo answers
    4. Quora answers
    5. Youtube videos
    6. Done guest posts on many blogs
    6. Fb group posting
    7. Tweeted
    8. Pinterest pins
    9. Digg
    10. Facebook chat box (told people about sc via inbox)
    11. Google+ Promotion

    These are the few methods i use to promote my affiliate link and website.

    - Sunil Bishnoi
    12 years ago

    Are you sure you want to delete this post?

    Jadster

    Jadster

    I try to promote via Youtube, Twitter, Facebook, and have also promoted at my school with a large banner for a banner competition and I got to have my banner hung up in the main hallway of my High School.
    12 years ago

    Are you sure you want to delete this post?

    hitmeasap

    hitmeasap

    Cool contest Fun Friday Contest-Most Unique Promotion Method

    Here's my methods:

    1. hitmeasap.com - Newly launched site. (weekly contests shortly + $5 coupons for new users.)
    2. Social Media Platforms. (FB, Twitter, Quora, Yahoo, Youtube etc.)
    3. Forums. (Making threads & posts about SEOClerks, contests, services etc.)
    4. Talking to personal clients.
    5. SEO-Clerk.com (Recently purchased domain which I've redirected to my affiliate link.)
    6. Blog comments.
    7. Facebook page (in my signature.) Not active at the moment.

    8. (A couple of things I can't share at this time.)

    Regards,
    hitmeasap
    12 years ago

    Are you sure you want to delete this post?

    akshat112

    akshat112

    I used some quiet silly but unique ways.
    Whenever I visit any store like Apple store or Dell store or somewhere like that, I pretend to try the device and then open Seoclerks and listing dock randomly in the devices.

    Then my special wall promotion... Just write website names on the wall of streets..
    And also writing on school boards is fun.. Its was the most enjoying method.

    Then, facebook pages, writing on different forums about seoclerks and listing dock, my blog aktechz, mouth promotion, etc..

    I liked seoclerks, I like seoclerks and I will always love seoclerks... It rocks.. !
    12 years ago

    Are you sure you want to delete this post?

    deencode

    deencode

    i paid money to watch seoclerks site with my affiliate id
    its 2 benifit
    new users comes by unique ips and get alexa ranking of seoclerks and i got some affilitates Fun Friday Contest-Most Unique Promotion Method
    12 years ago

    Are you sure you want to delete this post?

    fivercraze

    fivercraze

    I have more then 60 facebook accounts having more then 4000 friends in each where i have shared seoclerks links on my accounts wall ...
    .
    12 years ago

    Are you sure you want to delete this post?

    Asmodeus

    Asmodeus

    I create unique domain affiliate stores and then print them on T-shirts and hire students to wear them around campus and the area Fun Friday Contest-Most Unique Promotion Method
    12 years ago

    Are you sure you want to delete this post?

    EricElliott

    EricElliott

    Hey Clerks Nation,

    You guys are great sellers on our websites and it's great to see the vast ways you promote SEOClerks, ListingDock and CodeClerks. The winner this week is @Jadster. Congratulations to Jadster and your coupon is on the way via PM.

    Thanks to everyone that participated!
    12 years ago

    Are you sure you want to delete this post?

    vinothmech

    vinothmech

    Congrats @Jadster
    12 years ago

    Are you sure you want to delete this post?

    sunil0021

    sunil0021

    Congrats @Jadster Fun Friday Contest-Most Unique Promotion Method

    - Sunil Bishnoi
    12 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.87685894966125

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

    		/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=421241SELECT googleplus_profile FROM seoclerks.members WHERE USERID=42124

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

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='10503' 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='10503' 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=46834 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=46834 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=46835 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=46835 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=46836 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=46836 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=46837 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=46837 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=46838 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=46838 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=46841 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=46841 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=46842 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=46842 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=46844 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=46844 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=46845 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=46845 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=46846 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=46846 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='10503' AND status='1' AND (question like '%Fun Friday Contest-Most Unique Promotion Method%' OR question like '%Friday%' OR question like '%Contest-Most%' OR question like '%Unique%' OR question like '%Promotion%' OR question like '%Method%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='10503' AND status='1' AND (question like '%Fun Friday Contest-Most Unique Promotion Method%' OR question like '%Friday%' OR question like '%Contest-Most%' OR question like '%Unique%' OR question like '%Promotion%' OR question like '%Method%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='23280.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='23280.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.1749041SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%characteranimati%' OR A.skills LIKE '%characteranimati%') ORDER BY A.lastgigedit desc LIMIT 0,400.1749040.174904
    0.1350681SELECT 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 AND (A.tags LIKE '%characteranimati%' OR A.skills LIKE '%characteranimati%')0.1350680.135068