Shows > 1987

  • User warning: Column 'uid' in on clause is ambiguous query: SELECT COUNT(*) FROM (SELECT users_flag_content.name AS users_flag_content_name, users_flag_content.uid AS users_flag_content_uid FROM node node LEFT JOIN users users_flag_content ON uid = users_flag_content.uid INNER JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND (flag_content_node.fid = 1 AND flag_content_node.uid = 0) WHERE (node.type in ('show')) AND (node.status = 1) ) count_alias in _db_query() (line 148 of /var/www/webfront.dead.net/includes/database.mysql.inc).
  • User warning: Column 'uid' in on clause is ambiguous query: SELECT users_flag_content.name AS users_flag_content_name, users_flag_content.uid AS users_flag_content_uid FROM node node LEFT JOIN users users_flag_content ON uid = users_flag_content.uid INNER JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND (flag_content_node.fid = 1 AND flag_content_node.uid = 0) WHERE (node.type in ('show')) AND (node.status = 1) LIMIT 0, 10 in _db_query() (line 148 of /var/www/webfront.dead.net/includes/database.mysql.inc).

Compton Terrace Amphitheatre - August 18, 1987

Compton Terrace Amphitheatre

August 18, 1987

Tempe, AZ US

0
Average: 4.3 (3 votes)

Notes:

new location for venue at Firebird Lake, Gila River Indian Reservation

Set List:

Hell in a Bucket
Sugaree
Walkin' Blues
Ramble on Rose
My Brother Esau
Peggy-O
Greatest Story Ever Told
Bertha

Crazy Fingers
Playin' in the Band
Terrapin Station
drums
Dear Mr. Fantasy
Wharf Rat
Throwin' Stones
Turn on Your Love Light

Black Muddy River

See an error in show info or set list? Let us know!

Attendees of this show

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Cus
Cus's picture
Offline

Location

United States
Joined: Jun 18 2007
What was that orange tab???

Other than the hard stop in at the end of Crazy Fingers the second set is continuous. Stellar.

Gr8fulDave's picture
Offline

Location

Avondale, AZ 85392
United States
Joined: Sep 14 2007
Too damn hot!

This was the first Grateful Dead show that i was on the local crew and actually was "chosen" to work with Steve Parish. What a thrill albeit shortlived because Steve was in a foul mood (probably exacerbated by the extreme heat and what appeared to be an argument with Graham Jr.) and ended up (LITERALLY) throwing some poor dosed deadhead (that somehow managed to get up on the stage) off the 8 foot high platform. OUCH! that will leave a mark.

Offline

Location

KY
United States
Joined: Jan 9 2008
the bus came by...

This was my first show since the Dead didn't make stops anywhere near Arizona very often. We drove up from Tucson and waited for what seemed an eternity to park in the dusty lot. Of course it was worth the wait. Terrapin>drumz>Mr. Fantasy was incredible. Brent will always be my favorite keyboardist - nobody plays the Hammond like he did!

Offline

Location

United States
Joined: Jun 13 2007
It was so hot at that show.

It was so hot at that show. The traffic was horrible came down from Telluride, what a mistake.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.