Downtown Long Beach Associates

SELECT * FROM artist_info WHERE artist_id=#artist_id# SELECT * FROM art_specs WHERE artist_id=#artist_id# SELECT * FROM event_2 WHERE artist_id=#artist_id# AND (evnt_st_date <= #today# AND evnt_end_date >= #today#) OR (evnt_st_date >= #today# AND evnt_end_date >= #today# AND artist_id=#artist_id#) OR evnt_st_date >= #today# AND artist_id=#artist_id# OR event_part LIKE '%#artist_id#%' AND evnt_st_date >= #today# OR event_part LIKE '%#artist_id#%' AND (evnt_st_date <= #today# AND evnt_end_date >= #today#) ORDER BY evnt_st_date ASC SELECT * FROM song_info WHERE artist_id=#artist_id# ORDER BY song_title ASC

#get_artist_info.artist_name#

Example Photo

Scene Shot / Theater Company Logo

Logo

Artist/Bands' Logo

Play a
10 second
sound byte!
Click here to visit the website!

Help

Artist Photo

Sample Songs

No Samples Available #song_title#

Style/Type: #REReplace("#get_art_specs.art_style#","_"," ","ALL")#

Artists' Bio:
#get_art_specs.art_bio#

Upcoming Event Information

Venue / Event	Date
#venue_name#	#DateFormat(evnt_st_date, "ddd, mmm d, yyyy")# #DateFormat(evnt_st_date, "ddd, mmm d, yyyy")# thru #DateFormat(evnt_end_date, "ddd, mmm d, yyyy")#

Contact Information
Contact: #get_artist_info.contact_fname# #get_artist_info.contact_lname#	Title: #get_artist_info.contact_title#
Mailing Address: #get_artist_info.contact_address1# #get_artist_info.contact_address2# #get_artist_info.contact_city#, #get_artist_info.contact_state# #get_artist_info.contact_postal_code#
Telephone: #get_artist_info.contact_phone#	E-Mail: #get_artist_info.contact_email#

Contact Information
Artist E-Mail: #get_artist_info.artist_email#