SEOClerks

Answers from user dutchseo

Showing page: 1 of 1

For your average small biz, how much time to devote to SEO?

  • sureshjacob
    sureshjacob Level 1
  • 5 13 years ago

    What does 'nofollow' or 'no follow' mean in an A HREF / link?

  • sureshjacob
    sureshjacob Level 1
  • 2 13 years ago

    What does 'indexed' mean in terms of Google search and SEO?

  • sureshjacob
    sureshjacob Level 1
  • 2 13 years ago

    What is duplicate content and how does it impact SEO?

  • sureshjacob
    sureshjacob Level 1
  • 4 13 years ago

    Is one site better for SEO, or many cross-linked domains?

  • sureshjacob
    sureshjacob Level 1
  • 3 13 years ago

    What is CPC in the Google keywords tool, and how do you use it for SEO?

  • sureshjacob
    sureshjacob Level 1
  • 2 13 years ago

    For e-commerce sites, do multiple domains help or hurt SEO?

  • sureshjacob
    sureshjacob Level 1
  • 3 13 years ago

    Duplicate content and SEO, how can you prevent a Google penalty?

  • sureshjacob
    sureshjacob Level 1
  • 3 13 years ago

    What are the best SEO plugins? For instance best SEO plugins for WordPress?

  • sureshjacob
    sureshjacob Level 1
  • 2 13 years ago

    How long does it take to get to the top of Google / SEO?

  • sureshjacob
    sureshjacob Level 1
  • 4 13 years ago

    What on page SEO factors are the most important, in rank order?

  • sureshjacob
    sureshjacob Level 1
  • 3 13 years ago

    What is a high (low) bounce rate and does it matter?

  • sureshjacob
    sureshjacob Level 1
  • 2 13 years ago

    Why do some sites rank higher on Google / SEO searches?

  • sureshjacob
    sureshjacob Level 1
  • 1 13 years ago

    Is the keywords meta tag obsolete? What is it, and does the meta keywords tag matter for SEO?

  • sureshjacob
    sureshjacob Level 1
  • 2 13 years ago

    How do you get more inbound links and link juice for SEO?

  • sureshjacob
    sureshjacob Level 1
  • 3 13 years ago

    What is a custom 404 page and does it help for SEO purposes?

  • sureshjacob
    sureshjacob Level 1
  • 1 13 years ago

    What is local SEO, and how does local SEO differ from regular SEO?

  • sureshjacob
    sureshjacob Level 1
  • 1 13 years ago

    Google Analytics Not Provided Not Set, What does this mean?

  • sureshjacob
    sureshjacob Level 1
  • 1 13 years ago

    What is the difference between a short tail and a long tail keyword for SEO?

  • sureshjacob
    sureshjacob Level 1
  • 2 13 years ago

    META DESCRIPTION vs. META KEWYORDS tag - what is the difference, in terms of SEO?

  • sureshjacob
    sureshjacob Level 1
  • 3 13 years ago

    What is natural link building and why should you do that for SEO purposes?

  • sureshjacob
    sureshjacob Level 1
  • 2 13 years ago

    Which is better for SEO: a subdomain or a subdirectory?

  • sureshjacob
    sureshjacob Level 1
  • 2 13 years ago
    Order Now
    Process Time: 0.054770946502686

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT 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 seoclerks.members WHERE username='dutchseo' AND status='1'1SELECT USERID FROM seoclerks.members WHERE username='dutchseo' AND status='1'

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

    SELECT * FROM answers WHERE userid=496671SELECT distinct quesid FROM answers WHERE userid=49667

    /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 (4817,4816,4815,4814,4813,4808,4810,4804,4797,4812,4809,4803,4802,4800,4792,4778,4784,4779,4793,4790,4759,4795) 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 (4817,4816,4815,4814,4813,4808,4810,4804,4797,4812,4809,4803,4802,4800,4792,4778,4784,4779,4793,4790,4759,4795) 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 (4817,4816,4815,4814,4813,4808,4810,4804,4797,4812,4809,4803,4802,4800,4792,4778,4784,4779,4793,4790,4759,4795) 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 (4817,4816,4815,4814,4813,4808,4810,4804,4797,4812,4809,4803,4802,4800,4792,4778,4784,4779,4793,4790,4759,4795) 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='12794'1SELECT profilepicture FROM seoclerks.members WHERE USERID='12794'

    /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.6483892SELECT 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.3365080.311881
    0.3951512SELECT 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.2035900.191561

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    4.0433641SELECT 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 (42,64,90) AND gtags like'%Medical%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 404.0433644.043364
    0.3241952SELECT 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.3365080.311881
    0.1975762SELECT 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.2035900.191561
    0.1926481SELECT 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 (24) AND gtags like'%social%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.1926480.192648