WordPress database error: [Incorrect file format 'wp_comments']
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE post_status = 'publish' AND ID IN (101,100) GROUP BY ID

2006 October | TicTap Blog

Archive for October, 2006

Are Star Ratings on Amazon.com Harmful?

Wednesday, October 18th, 2006

There is a discussion in the Amazon ECS forum about negative reviews hurting book sales.

That lead me to wonder if people actually read reviews. Or do they look at the stars and read those reviews with many stars or only 1 star? Or even worse, do they make a decision to purchase based on the […]

Posted in General (talk) |

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 101 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '101' AND comment_approved = '1'

No Comments »

Alternate Formats for Books

Monday, October 9th, 2006

TicTap now shows alternate formats for books, if they exist.

With this feature, it is easy to check if your favourite book (in hardcover) is also available in paperback, audio CD, and even MP3.

Try this Rich Dad, Poor Dad book for an example.

Posted in General (talk) |

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 100 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '100' AND comment_approved = '1'

No Comments »