SEOClerks

Answers from user TeamWarrior

Showing page: 1 of 1

Are they still offering the 1 free bump for logging in and 2 free bumps for completed service? because i don't think I'm getting them. please check. thank you.

  • SexyModel
    SexyModel Level 3
  • 15 10 years ago

    I just want to use this opportunity to thank the staff of SEOClerks for being able to bring back the Payza withdrawal option, it really helped some of us a lot, thanks!

  • powerstone
    powerstone Level 1
  • 6 10 years ago

    Hello everybody, any experience about bump your services?? If you bump your services its mean when people search with your tag or your title, does it means you will be ranked first? Or on Seoclerks homepage, you will b...

  • TeamWarrior
    TeamWarrior Level 3
  • 1 10 years ago

    Hai to every seoclerks users! I am newbie, it is difficult to always stay tuned to seoclerks website for any alerts and messages that're why I proposed this android app concept.... For any alerts and messages getting pus...

  • Naveenclerk
    Naveenclerk Level 1
  • 6 10 years ago

    Now you can easily offer services in your own language (or any language) with a new Clerks Nation feature. Just another way we are supporting our diverse, international community. Simply edit your service as usual. F...

  • Beverly
    Beverly Level X3
  • 110 11 years ago

    Here's great news for our valued Clerks Buyers! Now you can easily purchase more extras, even after the order is started by clicking the Buy link in the upper left hand corner of your order URL. Once you click on t...

  • Beverly
    Beverly Level X3
  • 165 11 years ago

    We are so proud to bring you a new feature that allows you to request an official extension of your deadline. So no more late deliveries! Now rather than letting your order go past-due, you can ask for an official ex...

  • Beverly
    Beverly Level X3
  • 57 11 years ago

    Hi, When i free bumpled my service then i saw, Earn Free Bumps Earn one free bump per day for logging in (1 per account and all linked) Complete an order on time (2 per day) Generate an affiliate sale for $5 or m...

  • Ahad4smm
    Ahad4smm Level 1
  • 7 11 years ago

    Winter is a time when many people suffer from S.A.D or seasonal affective disorder, a winter time depression that can result from too little sunlight. Possible remedies include light therapy. If you suffer from winter ...

  • Beverly
    Beverly Level X3
  • 30 12 years ago

    Google handles all of my daily web searching, email, chat, RSS feeds, blog monetization, etc. In my opinion, it blows Yahoo and most other Internet companies clear out of the water.

    22 14 years ago
    Order Now
    Process Time: 0.047507047653198

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM seoclerks.members WHERE username='TeamWarrior' AND status='1'1SELECT USERID FROM seoclerks.members WHERE username='TeamWarrior' AND status='1'

    /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() ()

    SELECT * FROM answers WHERE userid=3582041SELECT distinct quesid FROM answers WHERE userid=358204

    /opt/clerks-staging/docroot/faq.php 258 () ()

    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.quesid IN (9144,9399,10327,10357,10359,12226,12227,12323,14663,17479) 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.quesid IN (9144,9399,10327,10357,10359,12226,12227,12323,14663,17479) 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.quesid IN (9144,9399,10327,10357,10359,12226,12227,12323,14663,17479) 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.quesid IN (9144,9399,10327,10357,10359,12226,12227,12323,14663,17479) 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='132248'1SELECT profilepicture FROM seoclerks.members WHERE USERID='132248'

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

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

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

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

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

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

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

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

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

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

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

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

    /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
    0.3725522SELECT 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.1945010.178051

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.4073951SELECT 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 (84) AND gtags like'%Dr80%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4073950.407395
    0.3230951SELECT 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 ORDER BY A.viewcount desc LIMIT 0,400.3230950.323095
    0.3104331SELECT 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 ORDER BY A.bdays desc LIMIT 0,400.3104330.310433
    0.1862762SELECT 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.1945010.178051