WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 145)]
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 (19,18,16,13,11,9,7) GROUP BY ID

Chopper Kast from Count’s Kustoms, Las Vegas

Chopper Kast - Show #7

November 12th, 2006

A montage of the infamous “Leather Chopper” by Count’s Kustoms. This chopper is currently on tour with Motley Crue and Aerosmith for the 2006 Route of All Evil Tour.

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 19 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 145)]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '19' AND comment_approved = '1'

No Comments »

Chopper Kast - Show #6

June 15th, 2006

A montage of Criss Angel’s “Mindfreak” chopper by Count’s Kustoms. Featured on the latest season of Mindfreak on the A&E.

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 18 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 145)]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '18' AND comment_approved = '1'

No Comments »

Chopper Kast - Show #5

April 29th, 2006

Godsmack and Count’s Kustoms. What better way to raise some serious noise in the city that never sleeps! Video podcast features behind the scenes footage of the band’s videoshoot and the Count’s Kustoms family of choppers and hot rods. A Count’s Kustoms exclusive.

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 16 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 145)]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '16' AND comment_approved = '1'

No Comments »

Chopper Kast - Show #4

November 18th, 2005

Join Steve Kalnasy, Editor of Hawaiian Choppers Magazine and Promoter of The Great Hawaiian Biker Build-Off as he gives us the 411 on this upcoming event between our very own Shannon Aikau and Roger Kuwahara of Kustom Fab. This is expected to be a “MUST SEE” build-off event of the year. Mark your calendars!! Dec.17, 2005, Honolulu Hawaii.

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 13 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 145)]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '13' AND comment_approved = '1'

No Comments »

Chopper Kast - Show #3

October 12th, 2005

Chopper Building Influences - The Count talks about Sugar Bear and Horror Movies.

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 11 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 145)]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '11' AND comment_approved = '1'

No Comments »

Chopper Kast - Show #2

September 9th, 2005

Pro Street Bikes and Long Front-End Choppers - Rideability and Customization.

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 9 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 145)]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '9' AND comment_approved = '1'

No Comments »

Chopper Kast - Show #1

July 8th, 2005

An introduction to the Count’s Kustoms team of Chopper Builders.

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 7 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_comments.MYD'. (errno: 145)]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '7' AND comment_approved = '1'

No Comments »