SEOClerks

Clear
Sign In Join

Questions from user Enter

Date Hot Date (old to new)
Unanswered Votes
Showing page: 1 of 1
Start a discussion

What is Google Dance? Is it normal? How can we prevent it for hitting our sites? Answered

What is Google Dance? Is it normal? How can we prevent it for hitting our sites?

  • Enter
    Enter Level 1
    • 2 13 years ago

    What feature of BING is the most important and helpful to webmasters? Answered

    What feature of BING is the most important and helpful to webmasters?

  • Enter
    Enter Level 1
    • 2 13 years ago

    How important are URL structure in SEO? Would it be ok if I use CAPS? Answered

    How important are URL structure in SEO? Would it be ok if I use CAPS?

  • Enter
    Enter Level 1
    • 2 13 years ago

    How effective are blog comments compared to forum signatures? Answered

    How effective are blog comments compared to forum signatures? Which one is better?

  • Enter
    Enter Level 1
    • 4 13 years ago

    How can I check how much competition I have on my selected keywords? Answered

    How can I check how much competition I have on my selected keywords?

  • Enter
    Enter Level 1
    • 2 13 years ago

    How can we prevent having duplicate content on our forums? Answered

    How can we prevent having duplicate content on our forums?

  • Enter
    Enter Level 1
    • 3 13 years ago

    Is blogging or forum platform important when doing SEO? Answered

    Is blogging or forum platform important when doing SEO? Is one for important than the other?

  • Enter
    Enter Level 1
    • 5 13 years ago

    Could dead forums and websites be a good source of quality backlinks? Answered

    Could dead forums and websites be a good source of quality backlinks?

  • Enter
    Enter Level 1
    • 5 13 years ago

    Where can I learn more about SEO? IS there a book that I can buy? Answered

    Where can I learn more about SEO? IS there a book that I can buy?

  • Enter
    Enter Level 1
    • 3 13 years ago

    Is there a way to sell domain names here? Answered

    Is there a way to sell domain names here? I have some old one that I want to discard and give them a new owner

  • Enter
    Enter Level 1
    • 5 13 years ago

    How much weight do Wikipedia links can bring to a blog? Answered

    How much weight do Wikipedia links can bring to a blog?

  • Enter
    Enter Level 1
    • 2 13 years ago

    How can I improve a site having high bounce rate? Answered

    How can I improve a site having high bounce rate? Current bounce rate is 70%.

  • Enter
    Enter Level 1
    • 2 13 years ago

    What are the best ways to get huge traffic from twitter and facebook? Answered

    What are the best ways to get huge traffic from twitter and facebook?

  • Enter
    Enter Level 1
    • 13 13 years ago

    Can I do blackhat SEO if I have Adsense published on my blog? Answered

    Can I do blackhat SEO if I have Adsense published on my blog?

  • Enter
    Enter Level 1
    • 4 13 years ago

    What are the minimum requirements for my website to get accepted in Google Adsense? Answered

    What are the minimum requirements for my website to get accepted in Google Adsense?

  • Enter
    Enter Level 1
    • 5 13 years ago

    How can I get more affiliate sales on Amazon and Clickbank? Answered

    How can I get more affiliate sales on Amazon and Clickbank?

  • Enter
    Enter Level 1
    • 3 13 years ago

    If I were to buy SEOClerks, how much will you sell it to me? Answered

    If I were to buy SEOClerks, how much will you sell it to me?

  • Enter
    Enter Level 1
    • 6 13 years ago

    Will it be ok to have adsense on a blog about PTC? Answered

    Will it be ok to have adsense on a blog about PTC?

  • Enter
    Enter Level 1
    • 3 13 years ago

    What is does it meant if my website have PR N/A instead of PR0? Answered

    What is does it meant if my website have PR N/A instead of PR0?

  • Enter
    Enter Level 1
    • 3 13 years ago

    What is link wheel? What is its difference on reciprocal link building? Answered

    What is link wheel? What is its difference on reciprocal link building?

  • Enter
    Enter Level 1
    • 2 13 years ago

    Do article directories accepts rewritten content? Answered

    Do article directories accepts rewritten content? Or do I need to write a new one?

  • Enter
    Enter Level 1
    • 3 13 years ago

    Changed titles on my article. How to tell Google to update the search engine listings? Answered

    Changed titles on my article. How to tell Google to update the search engine listings?

  • Enter
    Enter Level 1
    • 2 13 years ago

    What is the difference of whitehat and blackhat link building? Answered

    What is the difference of whitehat and blackhat link building?

  • Enter
    Enter Level 1
    • 2 13 years ago

    SEO Analysis: What are the things that I should need to check? Answered

    SEO Analysis: What are the things that I should need to check?

  • Enter
    Enter Level 1
    • 4 13 years ago

    Do paid search engine listings help in the site's SEO? Answered

    Do paid search engine listings help in the site's SEO?

  • Enter
    Enter Level 1
    • 6 13 years ago

    What are the things my site should have if I want to sell it? Answered

    What are the things my site should have if I want to sell it?

  • Enter
    Enter Level 1
    • 8 13 years ago

    What are some link building strategies that WON'T work and that we need to refrain from doing? Answered

    What are some link building strategies that WON'T work and that we need to refrain from doing?

  • Enter
    Enter Level 1
    • 1 13 years ago

    What is the best way to outrank wikipedia pages on your major keywords? Answered

    What is the best way to outrank wikipedia pages on your major keywords?

  • Enter
    Enter Level 1
    • 3 13 years ago

    Would it just be fine to use a mix of whitehat and blackhat techniques? Answered

    Would it just be fine to use a mix of whitehat and blackhat techniques?

  • Enter
    Enter Level 1
    • 2 13 years ago

    What is the difference between white and black hat SEO? Answered

    What is the difference between white and black hat SEO?

  • Enter
    Enter Level 1
    • 4 13 years ago

    Will it be ok to buy an aged domain from a dead website? Answered

    Will it be ok to buy an aged domain from a dead website?

  • Enter
    Enter Level 1
    • 4 13 years ago

    How effective are forum link building after the Panda and Penguin updates? Answered

    How effective are forum link building after the Panda and Penguin updates?

  • Enter
    Enter Level 1
    • 1 13 years ago

    What is Keyword Stuffing? Is it similar to keyword spamming? Answered

    What is Keyword Stuffing? Is it similar to keyword spamming?

  • Enter
    Enter Level 1
    • 3 13 years ago

    How hard is it to rank non-English websites using non-English keywords? Answered

    How hard is it to rank non-English websites using non-English keywords?

  • Enter
    Enter Level 1
    • 1 13 years ago

    What is the most reliable tool to check the total of backlinks on my blog? Answered

    What is the most reliable tool to check the total of backlinks on my blog?

  • Enter
    Enter Level 1
    • 4 13 years ago

    What does tier 1, tier 2 and tier 3 meant in link building? Answered

    What does tier 1, tier 2 and tier 3 meant in link building?

  • Enter
    Enter Level 1
    • 1 13 years ago

    What is the relationship of Google PageRank and Search Engine Rankings? Answered

    What is the relationship of Google PageRank and Search Engine Rankings?

  • Enter
    Enter Level 1
    • 5 13 years ago

    Order Now
    Process Time: 0.13954186439514

    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='Enter' AND status='1'1SELECT USERID FROM seoclerks.members WHERE username='Enter' AND status='1'

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

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

    		/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
    6.8563061SELECT 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'%plants%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 406.8563066.856306
    6.8108871SELECT 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'%Girls%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 406.8108876.810887
    0.3052821SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (87) AND gtags like'%ufabet%' AND type !=99 0.3052820.305282
    0.1086321SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Fyuse%') ORDER BY total_recommendations desc LIMIT 0,400.1086320.108632
    0.0898831SELECT 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 (66,83) AND gtags like'%Hits%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.0898830.089883