Submitted by bdragon on Tue, 04/17/2007 - 10:58.
mysql> select n.nid+400 as nid, n.title as title, n.type as type, n2.title as cat from node n inner join category_node cn on n.nid=cn.nid inner join category c on cn.cid=c.cid inner join node n2 on c.cid=n2.nid order by cat; +-----+----------------------------------------------------------------------------------------------+----------------------------------+---------------------------------------------------+ | nid | title | type | cat | +-----+----------------------------------------------------------------------------------------------+----------------------------------+---------------------------------------------------+ | 528 | Moonlight Classic (Denver) | content-cruiser_ride_0 | Annual Late Night Rides Around the World | | 547 | Baby On Bike | image | Be a more effective bicycle advocate | | 459 | Xtracycle FreeRadical | content-product | Be a more effective bicycle advocate | | 548 | Baby On Bike (2) | image | Be a more effective bicycle advocate | | 476 | Starting Fossil Fool in 2003 | story | Be a more effective bicycle advocate | | 495 | New Down Low Glow batteries provide nearly 3 hours of bright light | story | Bicycle Commuting | | 421 | Starting Fossil Fool in 2003 | book | Bike Advocates | | 635 | Bitter Cyclist Logo | image | Bike Culture | | 536 | Kryptonite lock as self-defense for cyclists? | blog | Bike Culture | | 661 | Let's Greenwash this City. | blog | Bike Culture | | 608 | Riding Squirrel by Max Chen | image | Bike Culture | | 652 | SomaFM.com helping me get through the night | blog | Bike Culture | | 548 | Baby On Bike (2) | image | Bike Culture | | 636 | Rock The Bike Co-Founder Paul Freedman interviewed by Bitter Cyclist | story | Bike Culture | | 538 | Discoverer: classic Mission Cruiser | content-bike | Bike Culture | | 665 | Gabe from Shake Your Peace reveals plan for his Soul Cycle | blog | Bike Culture | | 609 | Squirrel Riding Companion | blog | Bike Culture | | 654 | Should a chopper bicycle have a fake gas tank, fake tailpipe, or fake engine? | blog | Bike Culture | | 549 | Baby On Bike (What message are you sending?) | blog | Bike Culture | | 608 | Riding Squirrel by Max Chen | image | Bike Culture | | 637 | Paul Cumpian Rocks the Bike | blog | Bike Culture | | 547 | Baby On Bike | image | Bike Culture | | 521 | Cruiser Tuesday | content-cruiser_ride_0 | Carrboro Cruiser Ride | | 419 | Down Low Glow on a pair of bikes | image | Commuters | | 555 | Reggae DJ trike | blog | cruising with music on your bicycle | | 472 | FM Transmitter | forum | Custom Soul Cycles | | 639 | Community Bike Ride with the Southbay Cruisers | content-cruiser_ride_0 | Cyclists in Hermosa Beach | | 639 | Community Bike Ride with the Southbay Cruisers | content-cruiser_ride_0 | Del Aire | | 486 | Mobile PA system for bicycle-touring band | forum | DIY Soul Cycles | | 604 | DIY Soul Cycles For Dummies | forum | DIY Soul Cycles | | 631 | Hot Pants Pink | image | Down Low Glow: Neon Safety Lights for Bikes | | 538 | Discoverer: classic Mission Cruiser | content-bike | Down Low Glow: Neon Safety Lights for Bikes | | 453 | Kids don't like wearing / using safety products they think are 'uncool' | story | Down Low Glow: Neon Safety Lights for Bikes | | 629 | Hot Pants Pink DLG | image | Down Low Glow: Neon Safety Lights for Bikes | | 495 | New Down Low Glow batteries provide nearly 3 hours of bright light | story | Down Low Glow: Neon Safety Lights for Bikes | | 551 | Breezer Zag 8 Folder | image | Down Low Glow: Neon Safety Lights for Bikes | | 473 | Fireside chat on a Russian Hill sidewalk | image | Down Low Glow: Neon Safety Lights for Bikes | | 539 | Discoverer in front of Delfina's Restaurant | image | Down Low Glow: Neon Safety Lights for Bikes | | 455 | Add neon lights to your Lowrider Bicycle | story | Down Low Glow: Neon Safety Lights for Bikes | | 630 | Hot Pants Pink | image | Down Low Glow: Neon Safety Lights for Bikes | | 525 | Jack O Lantern | image | Down Low Glow: Neon Safety Lights for Bikes | | 442 | plush lowrider bicycle | image | Down Low Glow: Neon Safety Lights for Bikes | | 552 | Will the Down Low Glow fit my Breezer Zag 8 folding bicycle? | content-frequently_asked_questio | Down Low Glow: Neon Safety Lights for Bikes | | 476 | Starting Fossil Fool in 2003 | story | Down Low Glow: Neon Safety Lights for Bikes | | 546 | How to install a Two Fish Bike Block. | story | Down Low Glow: Neon Safety Lights for Bikes | | 456 | Cruising the Embarcadero | image | Down Low Glow: Neon Safety Lights for Bikes | | 639 | Community Bike Ride with the Southbay Cruisers | content-cruiser_ride_0 | El Segundo | | 633 | Rock the Bike Party Bikes In Effect at Songbird / Creative Commons Party. | story | Fender Blender | | 545 | Working headlight | image | Fixing up an old cruiser | | 543 | Starry Chainring | image | Fixing up an old cruiser | | 534 | The FIRST OFFICIAL FREMONT CRUISER RIDE! | content-cruiser_ride_0 | Fremont, CA Cruiser Ride | | 501 | Jojo's first Cruiser Ride | content-cruiser_ride_0 | Fremont, CA Cruiser Ride | | 570 | Fremont Cruiser Ride event summary | blog | Fremont, CA Cruiser Ride | | 530 | Fremont Cruiser Routes/Meet Up Spots | blog | Fremont, CA Cruiser Ride | | 508 | Sphygmosis Sound System Profile | image | Go cruising with music on your bike | | 647 | Soul Cycle Slim at a recent Mission District Party | image | Go cruising with music on your bike | | 540 | German Sound System with turntable. | image | Go cruising with music on your bike | | 509 | Sphygmosis Sound System on ride | image | Go cruising with music on your bike | | 665 | Gabe from Shake Your Peace reveals plan for his Soul Cycle | blog | Go cruising with music on your bike | | 423 | Soul Cycle head unit | image | Go cruising with music on your bike | | 573 | Wally demonstrates his vision for the becak sound system. | image | Go cruising with music on your bike | | 510 | A powerful bike sound system from England | story | Go cruising with music on your bike | | 422 | Cruising through a supermarket in Davis | image | Hipsters | | 686 | Shake your peace tour underway in Utah, crowds "Awed" by the band and their human power P/A. | blog | human power | | 453 | Kids don't like wearing / using safety products they think are 'uncool' | story | Keep your kids safe | | 518 | New Chain = happy biking. | blog | maintenance | | 639 | Community Bike Ride with the Southbay Cruisers | content-cruiser_ride_0 | Manhattan Beach | | 516 | BCAT Workshop Day | blog | manufacturing | | 539 | Discoverer in front of Delfina's Restaurant | image | Organize a cruiser ride in your town | | 456 | Cruising the Embarcadero | image | Organize a cruiser ride in your town | | 473 | Fireside chat on a Russian Hill sidewalk | image | Organize a cruiser ride in your town | | 652 | SomaFM.com helping me get through the night | blog | Our web site | | 515 | Rock The Bike Workshop Panorama | image | Products | | 442 | plush lowrider bicycle | image | Products | | 419 | Down Low Glow on a pair of bikes | image | Products | | 539 | Discoverer in front of Delfina's Restaurant | image | Products | | 503 | Soul Cycle Party Bike | image | Products | | 422 | Cruising through a supermarket in Davis | image | Products | | 629 | Hot Pants Pink DLG | image | Products | | 482 | Bike Music Promoters? | forum | Promoting new / unsung / local music | | 507 | Sergio -- a local bike DJ who doesn't ride a bike. | forum | Promoting new / unsung / local music | | 478 | Does the Down Low Glow work with a hub generator? | forum | Questions about features / safety benefits | | 639 | Community Bike Ride with the Southbay Cruisers | content-cruiser_ride_0 | Redondo Beach | | 459 | Xtracycle FreeRadical | content-product | Ride to the farmers' market | | 637 | Paul Cumpian Rocks the Bike | blog | Rock The Bike customers in action | | 458 | July 4th Fireworks Cruise | content-cruiser_ride_0 | San Francisco Cruiser Ride | | 652 | SomaFM.com helping me get through the night | blog | San Francisco Cruiser Ride | | 523 | Paul and Nate leading a mobile party in Las Vegas at the Interbike Trade Show | image | San Francisco Cruiser Ride | | 605 | Rolling with the Conference Bike | content-cruiser_ride_0 | San Francisco Cruiser Ride | | 475 | Offroading with the Xtracycle SUB | image | San Francisco Cruiser Ride | | 533 | Hip Hop in The Park Cruiser Ride! | blog | San Francisco Cruiser Ride | | 462 | Critical Mass | content-cruiser_ride_0 | San Francisco Cruiser Ride | | 524 | Halloween Cruiser Ride | content-cruiser_ride_0 | San Francisco Cruiser Ride | | 456 | Cruising the Embarcadero | image | San Francisco Cruiser Ride | | 648 | Soul Cycle Slim at Halloween Critical mass | image | San Francisco Cruiser Ride | | 499 | Stern Grove Ozomatli Hip Hop Cruiser Ride | content-cruiser_ride_0 | San Francisco Cruiser Ride | | 535 | Rock The Bike to create human powered lounge at SF Veloswap | content-event | San Francisco Cruiser Ride | | 473 | Fireside chat on a Russian Hill sidewalk | image | San Francisco Cruiser Ride | | 525 | Jack O Lantern | image | San Francisco Cruiser Ride | | 639 | Community Bike Ride with the Southbay Cruisers | content-cruiser_ride_0 | San Pedro | | 686 | Shake your peace tour underway in Utah, crowds "Awed" by the band and their human power P/A. | blog | shake your peace | | 659 | Soul Cycle Head Unit Owners- How have you mounted speakers to your bike? | forum | Soul Cycle Head Units | | 649 | Soul Cycle front mounted controls | image | Soul Cycle Mobile Audio System | | 509 | Sphygmosis Sound System on ride | image | Soul Cycle Mobile Audio System | | 647 | Soul Cycle Slim at a recent Mission District Party | image | Soul Cycle Mobile Audio System | | 503 | Soul Cycle Party Bike | image | Soul Cycle Mobile Audio System | | 602 | Why should a bicycle not have a stereo? | story | Soul Cycle Mobile Audio System | | 510 | A powerful bike sound system from England | story | Soul Cycle Mobile Audio System | | 648 | Soul Cycle Slim at Halloween Critical mass | image | Soul Cycle Mobile Audio System | | 508 | Sphygmosis Sound System Profile | image | Soul Cycle Mobile Audio System | | 633 | Rock the Bike Party Bikes In Effect at Songbird / Creative Commons Party. | story | Soul Cycle Mobile Audio System | | 523 | Paul and Nate leading a mobile party in Las Vegas at the Interbike Trade Show | image | Soul Cycle Mobile Audio System | | 660 | Cruisin' with the Southbay Cruisers - The Java Man Ride | content-cruiser_ride_0 | South Bay Cruiser Ride (Hermosa, Manhattan Beach) | | 671 | South Bay Cruisers | image | South Bay Cruiser Ride (Hermosa, Manhattan Beach) | | 639 | Community Bike Ride with the Southbay Cruisers | content-cruiser_ride_0 | South Bay Cruiser Ride (Hermosa, Manhattan Beach) | | 665 | Gabe from Shake Your Peace reveals plan for his Soul Cycle | blog | Sponsorships | | 476 | Starting Fossil Fool in 2003 | story | Starting the company | | 483 | Best way to share music within the Rock the bike community? | forum | Suggest music for cruiser rides | | 656 | Fossil Fool or anyone else out there-What's your favorite Cruiser music? | forum | Suggest music for cruiser rides | | 664 | Reproduction Bicycle Catalogs | forum | Tech Questions | | 639 | Community Bike Ride with the Southbay Cruisers | content-cruiser_ride_0 | Torrance | | 488 | Check out the new Fossil Fool slide show. | page | Trick out your lowrider bicycle | | 455 | Add neon lights to your Lowrider Bicycle | story | Trick out your lowrider bicycle | | 512 | Fossil Fool Joining Forces with the Juice Peddler | story | vision | | 475 | Offroading with the Xtracycle SUB | image | Xtracycle Sport Utility Bicycles | | 586 | Shake your Peace Rocks the Bike | story | Xtracycle Sport Utility Bicycles | | 459 | Xtracycle FreeRadical | content-product | Xtracycle Sport Utility Bicycles | +-----+----------------------------------------------------------------------------------------------+----------------------------------+---------------------------------------------------+ 127 rows in set (0.13 sec)
Current status
Content types imported:
Image
Blog
Comments imported:
Image
Blog