SEOClerks

Answers from user trafficsmania Page 2

Showing page: 2 of 2

What is the most important thing to check when buying a website?

7 14 years ago

Is there an easy way to increase my Alexa rankings fast?

  • SEONewBoy
    SEONewBoy Level 1
  • 5 14 years ago

    Is blackhat SEO really considered as an illegal thing to do?

  • SEONewBoy
    SEONewBoy Level 1
  • 5 14 years ago

    How important is keyword research when it comes on creating a website?

  • SEONewBoy
    SEONewBoy Level 1
  • 5 14 years ago

    To be successful in anything, we all need to beat and stand on top of our competition. But when it comes to websites, and keywords, what is the advantage of having a tough competition?

  • SEONewBoy
    SEONewBoy Level 1
  • 2 14 years ago

    I have like 3 active gigs on my account but sales are slow to come by. How can I get more sales on my SEOClerks gigs?

    4 14 years ago

    Someone I don't know is spamming my links on a bad site, what should I do?

    5 14 years ago

    how to verify paypal without credit cards? i havent credit card but i want to verify my paypal account..

  • rissa
    rissa Level 1
  • 3 14 years ago

    Is it acceptable to have a five to six-word keywords? Would that be better than using three to four-word keywords?

  • Lazerbeak
    Lazerbeak Level 1
  • 3 14 years ago

    How much time do I spend in doing keyword research?

  • Lazerbeak
    Lazerbeak Level 1
  • 3 14 years ago

    I'm just wondering, can I also earn here without selling anything?

  • Lazerbeak
    Lazerbeak Level 1
  • 7 14 years ago

    Two new features have been released today: the ability to follow users and sticky user info. The ability to follow a user is the first part of more features to come which will allow sellers to communicate with their loya...

  • ionicware
    ionicware Level X5
  • 14 14 years ago

    I was wondering, How many affiliate clicks you have and how much affiliate members you got from those clicks?

  • SeoExpertts
    SeoExpertts Level 1
  • 12 14 years ago

    Please tell me is there an order limit for level 1 user as i am not getting any order since 2 days

  • hamtech
    hamtech Level 1
  • 12 14 years ago

    We are considering the first SEOClerks $1,000 affiliate contest. As a participant you would be competing with other members based on affiliate sales. The person with the most sales during a given period would win the gr...

  • ionicware
    ionicware Level X5
  • 71 14 years ago

    Why should we can't sell here for 0.50$ or any decimal .

  • shubh
    shubh Level 4
  • 17 14 years ago

    I have a site with pagerank 8 but its domain name is something like 5u89y83y.info Note : the above site name is just example and not the actual site . I know this type of domain names doesnot even fetch a penny but...

    7 14 years ago

    Hi I have 18 affiliates at the moment and 5 purchases in total, but I only see 2 purchases which are incomplete , I dont see anything about the other purchases And yes I do know that I get paid only if my affiliates buy...

    6 14 years ago

    I joined SEO 3 days ago, since then I started to advertise my affiliate link, since than I got 14 referrals and 3 sales , so my question is how many affiliates have you got?

    23 14 years ago

    Hi, I saw people selling video intro's some for $6 and some for $7. I'm selling it for $1 but I didn't get a single sale. I mean I'm selling it really cheap! Here's the link: http://www.seoclerks.com/video/22077/make...

  • burhanhaq
    burhanhaq Level 1
  • 8 14 years ago

    Why I dont see any money in my affiliates sales section when one of my affiliates made 1 sale, the available section is 0$,Awaiting Approval 0$, Awaiting Clearance0$

    7 14 years ago
    Order Now
    Process Time: 0.05253791809082

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

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

    SELECT * FROM answers WHERE userid=110301SELECT distinct quesid FROM answers WHERE userid=11030

    /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 (870,872,901,905,1017,1011,1070,1105,1125,1163,1753,1745,1748,1906,1905,1903,1900,1899,1892,1890,1888,1885,1881,1878,1856,1854,1851,1845,1841,1837,1831,1828,1829,1823,1820,1791,1788,1787,1770,1761,1744,1739,1722,1970,2072,2070,2069,2064,2051,2044,2030,2157,2752,2803,5060,4876,4822,4944,4967,4903,4807,4786,4777,10410,10414,10444,10446,10452,12228,13637,21015,21021) 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 (870,872,901,905,1017,1011,1070,1105,1125,1163,1753,1745,1748,1906,1905,1903,1900,1899,1892,1890,1888,1885,1881,1878,1856,1854,1851,1845,1841,1837,1831,1828,1829,1823,1820,1791,1788,1787,1770,1761,1744,1739,1722,1970,2072,2070,2069,2064,2051,2044,2030,2157,2752,2803,5060,4876,4822,4944,4967,4903,4807,4786,4777,10410,10414,10444,10446,10452,12228,13637,21015,21021) 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 (870,872,901,905,1017,1011,1070,1105,1125,1163,1753,1745,1748,1906,1905,1903,1900,1899,1892,1890,1888,1885,1881,1878,1856,1854,1851,1845,1841,1837,1831,1828,1829,1823,1820,1791,1788,1787,1770,1761,1744,1739,1722,1970,2072,2070,2069,2064,2051,2044,2030,2157,2752,2803,5060,4876,4822,4944,4967,4903,4807,4786,4777,10410,10414,10444,10446,10452,12228,13637,21015,21021) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 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 (870,872,901,905,1017,1011,1070,1105,1125,1163,1753,1745,1748,1906,1905,1903,1900,1899,1892,1890,1888,1885,1881,1878,1856,1854,1851,1845,1841,1837,1831,1828,1829,1823,1820,1791,1788,1787,1770,1761,1744,1739,1722,1970,2072,2070,2069,2064,2051,2044,2030,2157,2752,2803,5060,4876,4822,4944,4967,4903,4807,4786,4777,10410,10414,10444,10446,10452,12228,13637,21015,21021) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 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='43'1SELECT profilepicture FROM seoclerks.members WHERE USERID='43'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    /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