Congrats Contest Winners!

ionicware Level X⁵

December 12, 2012, 1:40 pm

Write the reason you're deleting this FAQ

Congrats Contest Winners!

Congratulations winners of the contest! If you are a winner, the funds have already been added to your account. You can withdraw them, spend them, etc.

Check out the winners here: https://www.seoclerks.com/contest

We'd love to hear from each of you, what you did to rank in the contest.

We also have a nay-sayer so it would be great if you could let them know how much effort you put into winning (or losing, if you didn't rank): https://www.seoclerks.com/forum/posts/3873/

Comments

Please login or sign up to leave a comment

Join

Void

Congrats winners!

13 years ago

Are you sure you want to delete this post?

exjordanary

It's been a pleasure. I hope you have more Contests in the Future. It would be cool if each Contestant could see how close they are to the person directly ahead of, and/or behind them is.

This would push people to compete against their closest opponent harder without revealing the Statistics of the Contest to everyone at once.

Is there a specific Thread where I can Post the methods I used to get my Affiliates? It will include Screenshots, Links to Forums that Convert, as well as Promotional Images I created for the Contest.

I am gathering all the Data together now.

Thanks!!
~2nd Place Winner~
-exjordanary

13 years ago

Are you sure you want to delete this post?

Jerlene

Congratulations to the winners! I wish I tried harder and my products was more in demand.

I'll definitely market better next time though. Will there be another contest like this?

13 years ago

Are you sure you want to delete this post?

ionicware

Probably. Maybe $1k total over 2 months, rolling affiliate contest? Any ideas or suggestions?

13 years ago

Are you sure you want to delete this post?

robertman11

Well done guys! I can't believe you made it to 10k. At first it did not look like it at all.

13 years ago

Are you sure you want to delete this post?

cyberxcrime

I am Quit from then Contest in the beginning with 20 Affiliate Members because i know it's too hard to win.

Congratulations Guys! for your patience and hard working.

13 years ago

Are you sure you want to delete this post?

vipergum

Probably. Maybe $1k total over 2 months, rolling affiliate contest? Any ideas or suggestions?

I hope you have more Contests in the Future. Very like your way to make SEOCLERKS more Success.

13 years ago

Are you sure you want to delete this post?

exjordanary

You could also consider using a Dollar amount instead of a clock to determine the end of the Contest. That way, no need to worry about reaching a $10,000 Minimum
Something of this sort can be an infinite Rolling Contest with no end. - And the Cash Prizes can Fluctuate in Size depending on speed of the Market (kinda like the Lottery has a Jackpot).

There are a couple ways to do it, but I'm sure you'll think of something.

-ex

13 years ago

Are you sure you want to delete this post?

Void

You could also consider using a Dollar amount instead of a clock to determine the end of the Contest. That way, no need to worry about reaching a $10,000 Minimum
Something of this sort can be an infinite Rolling Contest with no end. - And the Cash Prizes can Fluctuate in Size depending on speed of the Market (kinda like the Lottery has a Jackpot).

There are a couple ways to do it, but I'm sure you'll think of something.

-ex

That is smart.

13 years ago

Are you sure you want to delete this post?

exjordanary

It would also be neat to have Multi-Tier Affiliates and earn a small percentage of all Members that our Affiliates Refer to SEOClerks - and all Members who they refer, and so on.

Or we could also consider Crediting us for Promoting ALL Ionicware Sites (not just SEOClerks): ForumClerks, PublicityClerks, SocialClerks, AudioClerks, etc..

To read my detailed Post about how I Won 2nd Place in the Contest, SEE THIS POST HERE

-exjordanary

13 years ago

Are you sure you want to delete this post?

wealth2010

Hi everyone. I won too but my question is there winning rewards besides affiliates sales? Also my suggestion is we should get paid second tier from the referrals by our affiliates not just their sales alone.
Thanks and hope you guys keep doing well.

13 years ago

Are you sure you want to delete this post?

alvinlah

wow, congrat my self. I am in the 5th place. SEOclerks now rank in 3562 in Alexa ranking. Affiliate program really bring in traffic. Hope to have such contest often. Maybe monthly or bi-monthly if possible.

13 years ago

Are you sure you want to delete this post?

NextSolu

Congrats winners!

13 years ago

Are you sure you want to delete this post?

sohibia

that would be me.. ha,,ha,,

13 years ago

Are you sure you want to delete this post?

alvinlah

I am getting seoclerks traffic in unconventional way. I do not use social marketing, article, forum, SEO. if you want to know see my GIGs " I will show you how to drive free unstoppable targeted millions of US,uk,australia,europe and the world traffic to your website without paying for the traffic for for $5" Ha ha , good luck!

I am in the 5th place for this contest

13 years ago

Are you sure you want to delete this post?

robertman11

Where? Link me to the gig u speak of. I want free traffic

13 years ago

Are you sure you want to delete this post?

alvinlah

I not suppose to post link because I did not post enough in the forum, follow my id in order to see my service, try it with no regret.

13 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.097816	1	SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Amazon-review%') ORDER BY total_recommendations desc LIMIT 0,40	0.097816	0.097816
0.070961	1	SELECT count(USERID) AS total FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Amazon-review%')	0.070961	0.070961

SEOClerks

Congrats Contest Winners!

Congrats Contest Winners!

Comments

Please login or sign up to leave a comment

Void

exjordanary

Jerlene

ionicware

robertman11

cyberxcrime

vipergum

exjordanary

Void

exjordanary

wealth2010

alvinlah

NextSolu

sohibia

alvinlah

robertman11

alvinlah

Invalid SQL

Expensive SQL

Suspicious SQL

Match	Count	SQL	Script
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400	1	SELECT 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='10416'	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='10416'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='1'	1	SELECT * FROM seoclerks.members WHERE USERID='1'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM seoclerks.members WHERE USERID=1	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=1	/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=10416 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=10416 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='10416' 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='10416' 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=43374 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=43374 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=43375 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=43375 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=43376 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=43376 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=43377 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=43377 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=43378 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=43378 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=43380 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=43380 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=43381 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=43381 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=43382 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=43382 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=43384 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=43384 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=43385 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=43385 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=43386 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=43386 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=43387 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=43387 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=43388 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=43388 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=43389 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=43389 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=43390 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=43390 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=43391 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=43391 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=43392 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=43392 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='10416'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='10416'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='10416' AND status='1' AND (question like '%Congrats Contest Winners!%' OR question like '%Congrats%' OR question like '%Contest%' OR question like '%Winners!%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='10416' AND status='1' AND (question like '%Congrats Contest Winners!%' OR question like '%Congrats%' OR question like '%Contest%' OR question like '%Winners!%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='42124' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='42124' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='39184' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='39184' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='17031' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='17031' 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=10416%' 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=10416%' 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='4.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='4.jpg'	/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='1.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='9.png'	1	SELECT 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='9874.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='9874.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='988.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='988.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='17897.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='17897.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='14984.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='14984.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='23965.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='23965.png'	/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()