user warning: Unknown table 'og_ancestry' in where clause
query: SELECT DISTINCT(node.nid), node_data_field_start_time.field_start_time_value AS node_data_field_start_time_field_start_time_value, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN content_type_event node_data_field_start_time ON node.vid = node_data_field_start_time.vid LEFT JOIN workflow_node workflow_node ON node.nid = workflow_node.nid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ( (node.status = '1') AND (node.type IN ('event')) AND (( REPLACE(node_data_field_start_time.field_start_time_value,'T',' ') + INTERVAL (-28800) SECOND) > ((NOW() - INTERVAL -25200 SECOND) + INTERVAL (-28800) SECOND)) AND (workflow_node.sid IN ('2','3')) AND (og_ancestry.group_nid = 1019) ) ORDER BY node_data_field_start_time_field_start_time_value ASC LIMIT 0, 10 in /home/rockth5/public_html/includes/database.mysql.inc on line 167.
Submitted by fossilfool on Tue, 07/10/2007 - 14:30.
The new Choprical Fish Soul Cycle is finally road-worthy after years in the workshop. It's loaded with amazing features, making this the most versatile Soul Cycle to date. I took it out in Berkeley the night before the Independence Day Cruiser Ride. The late night crowd near the Berkeley campus loved the bike and wanted to dance almost immediately. People would start dancing and moving before even seeing the bike. Just hearing the clean, clear music would get them moving, but when they saw the bike, they would bust out with laughter and a huge smile too.
The best way to learn about the features of the bike is to check out the Flickr photoset of the build process for the chopper. http://www.flickr.com/photos/rockthebike/sets/72157594296549639/
Here are some of the main features:
- Twin subwoofers with ported subwoofer cabinets give this Soul Cycle the best bass output possible for its size - 4 midrange speakers and 2 tweeters, including rotating midrange speakers integrated with the front Ectoplasmic console - 400 watt digital amp - Three different lighting circuits: single tube Down Low Glow, cabinet backlighting, and headlights, all controlled through the main ectoplasmic console, which is molded into the cruiser handlebars. - Wireless microphone and wireless transmitter for bike-to-bike audio. - Convertible chopper has both a classic chopping and an upright hill-climbing position built in. - Bamboo cargo rack supports passenger seat and allows general cargo capacity for light and leisurely commuting - 8-speed Sturmey Archer internally geared rear hub with front and rear disc brakes.
Some features are still in the works: - Human power mode. This option allows the entire system to be human powered. - Passenger backrest mounted on a pivot (backrest becomes a laptop stand for live performance. - Polishing fiberglass surfaces -
