WordPress database error: [Table './mmajorow_MBDwp/wp_comments' is marked as crashed and should be repaired]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE ID IN (40,39,37,32,27,16) GROUP BY ID

Magic Bean Dip » Search Engines

Archive for the 'Search Engines' Category

Google Trends - Someone Was Listening

Thursday, May 18th, 2006

Google Trends is what I had in mind when I mentioned monetizing traffic data previously. The graph at the right shows the searches for Bean Dip during the last quarter of 2005. The spike it shows at the end of the year is similar to the spike in traffic data shown in my own […]

WordPress database error: [Table './mmajorow_MBDwp/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 40 AND comment_approved = '1';

Comments Off

Page Rank Tool

Sunday, May 7th, 2006

This Page Rank Reporting tool (aka: Page Rank Bean Counter) checks the Google page rank of several urls at once and gives you the option of displaying the results in .CSV format.
I wrote the script myself using a slightly modified version of the PHP pagerank script that’s been floating around the internet. […]

WordPress database error: [Table './mmajorow_MBDwp/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 39 AND comment_approved = '1';

Comments Off

Traffic Data As An Asset

Tuesday, January 3rd, 2006

Traffic data is an unmonetized asset of the Internet. This graph represents the web traffic on MagicBeanDip over the New Years holiday. The red line represents the average traffic over the past month.
Why Google should care about bean dip
As you can see, there’s a relatively large spike on New Years Eve. […]

WordPress database error: [Table './mmajorow_MBDwp/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 37 AND comment_approved = '1';

Comments Off

Standards Compliant Solution for 302 Web Page Hijacking

Monday, May 30th, 2005

The HTTP Content-Location header is a standards compliant solution for the 302 web page hijacking problem. Depending on how it’s evaluated, it can be effective as either an HTTP header, or as an HTML meta tag. If two different locations provide conflicting Content-Location data, then priority should be given to the information that […]

WordPress database error: [Table './mmajorow_MBDwp/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 32 AND comment_approved = '1';

Comments Off

Google AutoLink, Enhancing User Experience or Stealing Traffic?

Sunday, March 6th, 2005

This overview of what people are saying about Google AutoLinks compiled by kuro5hin.org (via Phil) presents many different points of view.

From what I see, it’s not so much about modifying the content as fiddling with traffic. I have a right to direct the traffic that comes to my website as I see fit.

I’ve seen some people compare AutoLinks to having a butler that anticipates your needs and finds information for you just in case you might want to use it. I think a better analogy is comparing a website to a store and your website traffic to people in your store.

WordPress database error: [Table './mmajorow_MBDwp/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 27 AND comment_approved = '1';

Comments Off

Find Back-Links for Multiple URLs

Friday, January 14th, 2005

I’ve been using this query format for checking back-links on yahoo and msn:
link:http://v1.magicbeandip.com/ -site:magicbeandip.com
Try it at: MSN Search and Yahoo!
It’s nice because it excludes all pages at Magic Bean Dip that link to http://v1.magicbeandip.com, so all I see are links from other websites. The thing I dislike about this method of finding back-links […]

WordPress database error: [Table './mmajorow_MBDwp/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 16 AND comment_approved = '1';

Comments Off