Database error: [Can't open file: 'bb_comments.MYI' (errno: 145)]
SELECT ID, COUNT( comment_ID ) AS ccount FROM bb_posts LEFT JOIN bb_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE post_status = 'publish' AND ID IN (7,6,5,4,3,2) GROUP BY ID

Business Blogs

Google new patent overview

April 26th, 2005

Google recently filed patent named “Information retrieval based on historical data". This patent contains points related to algorithm Google uses/will use, to rank web pages.

The major part of the patent deals with links. As we know that google relies on links in a great way to rank web pages. Historical information is the new entrant other then the page rank, anchor text, and number of links. Lets have a look at some of the points mentioned in the patent (it is not actual patent lines but my understanding between the lines of the patent):

  • Discovery dates of the links with anchor text are recorded.
  • Appearance and disappearance of link could be monitored
  • Growth rate of the links could also be monitored.
  • Rate at which links appear and disappear could be monitored as well
  • Change in anchor text with time could be recorded.
  • Permanent links will get high rating then non-permanent one.
  • Appearance of links, slow and constant gets a higher rating.
  • Multiple anchor text for a site will be given higher preference.
  • Sudden link growth could be considered as Spam.
  • New website with large number of links would be considered somewhat Spam
  • Links from pages that is updated regularly will be considered more important.
  • Old pages with fresh links will be considered as fresh.

Database error: [Can't open file: 'bb_comments.MYI' (errno: 145)]
SELECT COUNT(comment_ID) FROM bb_comments WHERE comment_post_ID = 7 AND comment_approved = '1';

Database error: [Can't open file: 'bb_comments.MYI' (errno: 145)]
SELECT COUNT(*) FROM bb_comments WHERE comment_post_ID = 7 AND comment_approved = '1'

No Comments »

You must have a Blog…..

October 27th, 2004

Benifits of Seo in Blogs

You must have a Blog for your business if you have timely information to share with your customers. If you’re unhappy with the results and ROI from banner and email marketing. You would like your web site to have top-ranking positions in Google.

There are tons of benefits, a business blog could bring to your site. Think it this way. You have optimized your main site, got backlinks and rankings for keywords. if you make a blog, you will be optimizing it seperately, getting backlinks and its own traffic. Think of what would be transferred and gained from blog and to your main site. To name a few- PR, traffic, customer relationship, fresh content and …..

Database error: [Can't open file: 'bb_comments.MYI' (errno: 145)]
SELECT COUNT(comment_ID) FROM bb_comments WHERE comment_post_ID = 6 AND comment_approved = '1';

Database error: [Can't open file: 'bb_comments.MYI' (errno: 145)]
SELECT COUNT(*) FROM bb_comments WHERE comment_post_ID = 6 AND comment_approved = '1'

No Comments »

When should one blog?

October 20th, 2004

• When the company is equipped with the enough information.
• When the company has a specific objective in mind to achieve with the blog.
• If the blogs fits in well with the company’s profile.
• It includes also e-mails, wikis, PR releases etc.

Blogs are unusual, yet effective means for communication. Though they might not satisfy for everybody’s strategy, many SOHOs and SMEs will benefit by creating a distinct image for themselves by conveying important messages with the outside world.

Database error: [Can't open file: 'bb_comments.MYI' (errno: 145)]
SELECT COUNT(comment_ID) FROM bb_comments WHERE comment_post_ID = 5 AND comment_approved = '1';

Database error: [Can't open file: 'bb_comments.MYI' (errno: 145)]
SELECT COUNT(*) FROM bb_comments WHERE comment_post_ID = 5 AND comment_approved = '1'

No Comments »

How a business benefit from a blog?

October 20th, 2004

Blogs can really boost companies’ profits.

• They are almost free, easy to launch and one need not be a tech savvy person at all. They can be created by any person who is reasonably net-savvy.
• They enable to build communities online.
• They can be more effective and interesting than mere e-mails.
• They strengthen relationships inside and outside the organization
• They are very effective communication channels as they are interactive.
• Unlike e-mails, they do not encroach on your privacy, as users need a URL to access the content.
• They have the ability to improve branding by communicating effectively rather than a dry PR release.
• They are permanent and therefore more accessible than e-mails.

Database error: [Can't open file: 'bb_comments.MYI' (errno: 145)]
SELECT COUNT(comment_ID) FROM bb_comments WHERE comment_post_ID = 4 AND comment_approved = '1';

Database error: [Can't open file: 'bb_comments.MYI' (errno: 145)]
SELECT COUNT(*) FROM bb_comments WHERE comment_post_ID = 4 AND comment_approved = '1'

No Comments »

What are Business blogs?

October 20th, 2004

. It facilitates individuals and companies (big and small) to reach out to new audiences. Information dissemination through blogging is the first genuinely easy solution that allows small businesses and freelancers to write, publish, and share it with new and existing customers.

They are created in various ways. Many companies use blogs, these days, for communicating and coordinating with colleagues and associates who might be stationed at different locations. Right now, that is the reason it is most prominently used for. They also can uniquely placed by making them informal so as to build a company’s reputation or also to promote their brands. Other businesses use them to bolster their existing operations. This gives them a platform to exhibit their skills which will eventually carve a niche for them. Blogs let companies reach out to their associates with in-house news, sales promotions and more.

Database error: [Can't open file: 'bb_comments.MYI' (errno: 145)]
SELECT COUNT(comment_ID) FROM bb_comments WHERE comment_post_ID = 3 AND comment_approved = '1';

Database error: [Can't open file: 'bb_comments.MYI' (errno: 145)]
SELECT COUNT(*) FROM bb_comments WHERE comment_post_ID = 3 AND comment_approved = '1'

No Comments »

What is a blog?

October 20th, 2004

Blog is a space for personal expression on the net. The entries comprise of a few brief paragraphs. They have links to other sites, which are prominent. The authors of these blogs are generally well-informed on the subjects they write about. They provide a fora for like-minded persons to converse on the net too. But, unlike a forum the process here is one-to-many, though readers can post their views or comment. They can also write back to the authors.

Another type of blog is known as “wiki". A wiki is like a web page than anyone can contribute to, and the WordPress wiki documentation has grown rich from the many who have contributed to it. It is usually up-to-date and well-hyperlinked.

Database error: [Can't open file: 'bb_comments.MYI' (errno: 145)]
SELECT COUNT(comment_ID) FROM bb_comments WHERE comment_post_ID = 2 AND comment_approved = '1';

Database error: [Can't open file: 'bb_comments.MYI' (errno: 145)]
SELECT COUNT(*) FROM bb_comments WHERE comment_post_ID = 2 AND comment_approved = '1'

No Comments »