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).

Long Beach Arena - November 14, 1987

Long Beach Arena

November 14, 1987

Long Beach, CA US

0
Average: 4.3 (6 votes)

Set List:

Shakedown Street
Little Red Rooster
Althea
Masterpiece
Hey Pocky Way
Deal

Maggie's Farm
Cumberland Blues
Playin' in the Band
Terrapin Station
drums
I Need a Miracle
Stella Blue
Throwin' Stones
Turn on Your Love Light

Quinn the Eskimo

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.
May 20, 2008 - 7:50pm
#1
josh e bear
josh e bear's picture
Offline

Locations

United States
See map: Google Maps
Joined: Feb 29 2008
wow ! 2nd set looks smokin !

would lov to hear that sometime ~ whos got my copy ?

Josh E Bear !!

Top
April 16, 2009 - 10:25am
#2
fellow deadhead
Offline

Location

United States
See map: Google Maps
Joined: Apr 4 2009
long beach

this place sucked.all these metal heads runnen around breaking glass,left over from the metalica show the day before.very nice stagger lee.

Top
April 19, 2009 - 12:56am
#3
MissReddin
MissReddin's picture
Offline

Location

United States
See map: Google Maps
Joined: Jul 25 2008
conqured the hotel + placed small couch in elevator...nice

keep your character, enjoy living, share your fortune,
OXOX Merple Reddin

Top
February 13, 2011 - 11:26pm
#4
ChinaRider77
Offline
Joined: Nov 13 2010
grate show

This was a great show out of the many of the later 80's I saw this one has always stuck with me for some reason. A great shakedown as well as Brent rippin it up on the keys during the show but check him out on Pocky Way, I remember being dosed to the gills and watching the furious Brent pound those keys.

Top

Comment viewing options

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