SEOClerks

Answers from user Augustinus

Showing page: 1 of 1

Hello, guys I d like to ask you more experienced freelancers how to get more sales, because to be honest, I am currently struggling with new sales. I have 4 services, bumping them and views are counting but no sales. ...

  • Augustinus
    Augustinus Level 1
  • 20 11 years ago

    Do you remember how you got your first freelance client(s)? Were you a member of SEOClerks then or did you get the client on your own?

  • Tandy
    Tandy Level 1
  • 29 11 years ago

    Are paid bumps worth here? Will it fetch me enough revenue for signature link, guest post, content writing and forum posting if I buy bumps for $8. Can I earn four to five times of this amount at least once I buy the bum...

  • webseo123kh
    webseo123kh Level 1
  • 30 11 years ago

    I've noticed how some freelancers work too hard, even 12 hours a day. You would not work so many hours a day at a regular job. Is the income of a freelance day (12 hours or more) really commensurate with what a 'job' w...

  • Justin
    Justin Level 1
  • 27 12 years ago

    What is a different between Off page and On page ?

  • Shagun
    Shagun Level 1
  • 11 12 years ago

    Hey Clerks Nation, today, i decided to share with you a few things that will help you succeed as a seller on SEOClerks. Some of you may already know this, but i am sure there are beginners that will find use of this thre...

  • Jovan
    Jovan Level 3
  • 81 12 years ago

    Hello Friends, please tell me which is method to get provide me more traffic on my site. Thanks................!!!!!

    58 12 years ago

    So I thought I would post a quick list of tips you could keep in mind while you are setting the price(s) on your service(s). Please have a read at them and they might help you get more sales and make bigger purchases. D...

  • Sean101
    Sean101 Level 1
  • 69 12 years ago
    Order Now
    Process Time: 0.05187201499939

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

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

    SELECT * FROM answers WHERE userid=1741311SELECT distinct quesid FROM answers WHERE userid=174131

    /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 (11675,11691,12110,12949,13019,13205,14252,15433) 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 (11675,11691,12110,12949,13019,13205,14252,15433) 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 (11675,11691,12110,12949,13019,13205,14252,15433) 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 (11675,11691,12110,12949,13019,13205,14252,15433) 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='174131'1SELECT profilepicture FROM seoclerks.members WHERE USERID='174131'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    /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.1050331SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 70596 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%wordpres developm website%' ) LIMIT 40.1050330.105033