SEOClerks

Answers from user Narayanram Page 3

Showing page: 3 of 3

My website is not indexed by Google. It is live from one month now. I have rechecked the content of my website. It had some grammatical mistakes. I have corrected them. But I really wanted to know if grammatical mistakes...

9 12 years ago

Hi friends I want to take good rank of my website so which technique i use to promote my website. Please reply me with your own opinion. Thanks in advance

12 12 years ago

Bumping your service could be one of the easiest ways to increase sales. And, I've always noticed an increase in sales, not just for the service bumped but others. But, how often do you bump your services? Is this some...

  • Beverly
    Beverly Level X3
  • 55 12 years ago

    As title says, am stuck in one or so of my keywords on 3rd page of Google for 2-3 weeks, there is no SERP movement even in single position UP or DOWN. Here are some little bit details of what I did so far, Ordered lin...

    2 12 years ago

    Could anyone tell me that theme base blog commenting is still effective as the ranking point of view?

  • Haider
    Haider Level 1
  • 55 12 years ago

    i have blog for download free movies , i have upload 1111 movies on my blog ...and also my blog is ossum but i get 40-45 visitor and 3 to 4 clicks per day....its seoriously big problem ...i has to hard work of 3 month to...

  • Theonebuyer
    Theonebuyer Level 1
  • 3 12 years ago

    Which of the following URLs can the Google search engine spider? a. http://www.expertrating.com/exams/seo.asp?examnum=243&examtype=244 b. http://www.expertrating.com/exams/seo.asp?examnum=243 c. http://www.expert...

  • spykaushik
    spykaushik Level 1
  • 7 13 years ago

    Anybody can write articles, as it is easy to write if you don't thing about grammar & SEO ! Articles which are written without thinking, doesn't get indexed easily by google or any search engine. In most cases, badly...

  • shek
    shek Level 1
  • 6 13 years ago

    Do you use Google search as the default search engine on your site? Or, do you use another search engine so your users can search your site?

  • Beverly
    Beverly Level X3
  • 21 13 years ago

    What's the best job search engine? For instance, have you tried some job specific search engines such as Indeed.com to find a job?

  • Beverly
    Beverly Level X3
  • 14 13 years ago

    Check out this video where Matt Cutts discusses the value of 'editorial links' (such as links freely given by a site owner who is endorsing your site) versus low quality, boilerplate text backlinks (such as those backlin...

  • Beverly
    Beverly Level X3
  • 3 13 years ago
    Order Now
    Process Time: 0.067476034164429

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

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

    SELECT * FROM answers WHERE userid=2832441SELECT distinct quesid FROM answers WHERE userid=283244

    /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 (9180,8987,7939,9183,9089,9155,8428,7903,7795,9185,10323,10352,10353,10355,10357,11976,12050,12116,12117,12745,13053,13168,13170,13173,13175,13176,13187,13188,13190,13196,13205,13206,13215,13388,13389,13397,13592,13598,14784,14787,14790,14793,14794,14795,14798,14799,14800,14801,14812,14813,14814,15038,15041,15048,15051,15052,15056,15514,15550,15551,15553,15564,15589,15778,15779,15780,15781,15786,15809,15812,15825,15826,15829,15834,15835,15836,15837,15841,15842,15844,15846,15847,15859,15860,15866,15869,15893,15904,15908,16287,16311,16338,16578,16603,16604,16614,17371,21017,24585) 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 (9180,8987,7939,9183,9089,9155,8428,7903,7795,9185,10323,10352,10353,10355,10357,11976,12050,12116,12117,12745,13053,13168,13170,13173,13175,13176,13187,13188,13190,13196,13205,13206,13215,13388,13389,13397,13592,13598,14784,14787,14790,14793,14794,14795,14798,14799,14800,14801,14812,14813,14814,15038,15041,15048,15051,15052,15056,15514,15550,15551,15553,15564,15589,15778,15779,15780,15781,15786,15809,15812,15825,15826,15829,15834,15835,15836,15837,15841,15842,15844,15846,15847,15859,15860,15866,15869,15893,15904,15908,16287,16311,16338,16578,16603,16604,16614,17371,21017,24585) 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 (9180,8987,7939,9183,9089,9155,8428,7903,7795,9185,10323,10352,10353,10355,10357,11976,12050,12116,12117,12745,13053,13168,13170,13173,13175,13176,13187,13188,13190,13196,13205,13206,13215,13388,13389,13397,13592,13598,14784,14787,14790,14793,14794,14795,14798,14799,14800,14801,14812,14813,14814,15038,15041,15048,15051,15052,15056,15514,15550,15551,15553,15564,15589,15778,15779,15780,15781,15786,15809,15812,15825,15826,15829,15834,15835,15836,15837,15841,15842,15844,15846,15847,15859,15860,15866,15869,15893,15904,15908,16287,16311,16338,16578,16603,16604,16614,17371,21017,24585) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 80, 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 (9180,8987,7939,9183,9089,9155,8428,7903,7795,9185,10323,10352,10353,10355,10357,11976,12050,12116,12117,12745,13053,13168,13170,13173,13175,13176,13187,13188,13190,13196,13205,13206,13215,13388,13389,13397,13592,13598,14784,14787,14790,14793,14794,14795,14798,14799,14800,14801,14812,14813,14814,15038,15041,15048,15051,15052,15056,15514,15550,15551,15553,15564,15589,15778,15779,15780,15781,15786,15809,15812,15825,15826,15829,15834,15835,15836,15837,15841,15842,15844,15846,15847,15859,15860,15866,15869,15893,15904,15908,16287,16311,16338,16578,16603,16604,16614,17371,21017,24585) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 80, 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='153230'1SELECT profilepicture FROM seoclerks.members WHERE USERID='153230'

    /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='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='114307'1SELECT profilepicture FROM seoclerks.members WHERE USERID='114307'

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

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

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

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

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

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

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

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

    /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.3728592SELECT 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.1866430.186216

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.3124151SELECT 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.3124150.312415
    0.1864302SELECT 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.1866430.186216
    0.1171801SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 33686 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Sales Seo%' ) LIMIT 40.1171800.117180