water

http://www.smashingapps.com/2010/01/17/40-stunning-examples-of-high-speed-photography.html

Star trails

http://www.digitalfieldguide.com/blog/1413

long exposure shots

http://ilovesubstance.com/2008/amazing-long-exposure-photography-led-lights/

http://photoextremist.com/the-complete-guide-to-long-exposure-photography

http://thechive.com/2010/07/23/stellar-long-time-exposure-photography-30-hq-photos/

pictures with lights

http://www.ppmag.com/web-exclusives/2010/09/night-photog.html