SEOClerks

Discussions about Contest

Showing page: 1 of 1

I wish SEO Clerks would have a raffle or contest for the community this Christmas. It would be fun and exciting for the members if there was one. What are your thoughts about this?

  • Kakashi2020
    Kakashi2020 Level 1
  • 35 7 years ago

    I have a suggestion to put forward for seoclerks. Now might sound weird like but what if seoclerks put together like a monthly contest. Like contests every month for the most popular or most earners to who ever purchases...

  • keen2write
    keen2write Level 1
  • 4 9 years ago

    Have you ever entered an SEO contest/competition? And won? Or just taken part anyway just for the crack of it? Would you be interested in entering an SEO contest to see who can get the most affiliates or earnings from on...

  • idealmike
    idealmike Level X3
  • 9 10 years ago

    are there any currently running seoclerks contests like the one where you get free money

  • abetti17
    abetti17 Level 3
  • 1 13 years ago

    Just wondering if i am still able to enter the contest where you make a 30-40 second youtube video. Thanks!

  • abetti17
    abetti17 Level 3
  • 5 13 years ago

    Is SEOClerks taking precautions against Cheaters?? If so, what kinds? Couldn't people essentially create multiple SEOClerks accounts, or agree to become each other's Affiliates then Split the Winnings? Then continuously...

  • exjordanary
    exjordanary Level X5
  • 4 13 years ago

    Hi. Im sorry with the question but i am just really curios what if the contest does not reach its $10,000 minimum requirement? What will happen to the contest and winners? I have seen that there is only about $3K+ sales ...

  • Maranatha
    Maranatha Level 5
  • 10 13 years ago

    I am trying to make my forum get some users and promote at the same time as contestant is required to give a backlink. Will SEO forum work on a tech forum, what prices can you suggest?

  • seoguy
    seoguy Level 1
  • 4 14 years ago
    Order Now
    Process Time: 0.16522097587585

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% Contest %' OR A.tags LIKE 'Contest %' OR A.tags LIKE '% Contest' OR A.tags='Contest') LIMIT 11SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% Contest %' OR A.tags LIKE 'Contest %' OR A.tags LIKE '% Contest' OR A.tags='Contest') LIMIT 1

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

    SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% Contest %' OR A.tags LIKE 'Contest %' OR A.tags LIKE '% Contest' OR A.tags='Contest') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 401SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% Contest %' OR A.tags LIKE 'Contest %' OR A.tags LIKE '% Contest' OR A.tags='Contest') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40

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

    SELECT * from questions as A where A.status='1' 1SELECT count(A.quesid) as total from questions as A where A.status='1'

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

    SELECT * FROM answers as A where A.status='1' 1SELECT count(A.ansid) as total FROM answers as A where A.status='1'

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

    SELECT * FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') 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='663192'1SELECT profilepicture FROM seoclerks.members WHERE USERID='663192'

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

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

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

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

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

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

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

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

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

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

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

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

    /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.5769071SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (17,18,22,30,33,47,49,50,72,84) AND gtags like'%Price%' AND type !=99 0.5769070.576907
    0.2692491SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (74) AND gtags like'%Woocommerece%' AND type !=99 0.2692490.269249
    0.2576801SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (74) AND gtags like'%Sqaurespace%' AND type !=99 0.2576800.257680