select
Namespace,
e.*,
v.Name as VenueName,
v.Address,
v.City,
v.Region,
v.PostalCode,
v.Country,
v.Latitude,
v.Longitude,
v.Source as VenueSource,
v.SourceURL as VenueSourceUrl,
(select count(*) from tickets where EventID = e.EventID) as Tickets
from
data_events e
inner join data_venues v on e.VenueID = v.VenueID
inner join data_event_categories ec on e.EventID = ec.EventID
where
e.Status = 3
and Namespace in ('music','sports','performing_arts') and StartTime > NOW() order by
e.StartTime
Limit 50
E0-001-054795106-8
V0-001-000728026-0
Branches Band - Andy and Rachel
/nampa/events/branches-band-andy-and-rachel-/E0-001-054795106-8
Join Branches Band for a FREE Christian concert!
06-20-2013 07:00 PM
06-20-2013 06:13 AM
2013-06-20 19:00:00
evdb
Messiah Lutheran Church
%VenueURL%
534 W Iowa Avenue
Nampa
ID
83686
-116.5822811
-116.5822811
1
06-20-2013 07:00 PM
Messiah Lutheran Church - Nampa, ID
Category: music
Source: evdb Price:
E0-001-052548731-2@2013062019
V0-001-000535977-9
A Funny Thing Happened on the Way to the Forum
/nampa/events/funny-thing-happened-way-forum-/E0-001-052548731-2@2013062019
Location: Nampa Civic Center Brandt Auditorium
Broadway’s greatest farce is light, fast-paced, witty, irreverent and one of the funniest musicals ever written. A Funny Thing Happened on the Way to the Forum takes comedy back to its roots, combining situations from time-tested, 2000 year old comedies of Roman playwright Plautus with the infectious energy of classic vaudeville.
A Funny Thing Happened on the Way to the Forum is a non-stop laugh-fest in which Pseudolus, a crafty slave, struggles to win the hand of a beautiful but slow-witted courtesan named Philia, for his young master, Hero, in exchange for freedom. The plot twists and turns with cases of mistaken identity, slamming doors, and a showgirl or two thrown in.
06-20-2013 07:30 PM
06-20-2013 06:13 AM
2013-06-20 19:30:00
$17.00
evdb
Nampa Civic Center
%VenueURL%
311 Third Street South
Nampa
ID
83651
-116.5710268
-116.5710268
2
06-20-2013 07:30 PM
Nampa Civic Center - Nampa, ID
Category: music
Source: evdb Price: $17.00
E0-001-055471066-3
V0-001-000296657-8
Deadly Sinz - Eternal North
/payette/events/deadly-sinz-eternal-north-/E0-001-055471066-3
COME CHECK OUT IDAHO METAL !!
06-21-2013 06:00 PM
06-20-2013 06:13 AM
2013-06-21 18:00:00
evdb
Sundance Saloon
%VenueURL%
216 N. Main. St.
Payette
ID
83661
-116.9348438
-116.9348438
3
06-21-2013 06:00 PM
Sundance Saloon - Payette, ID
Category: music
Source: evdb Price:
E0-001-054620768-7
V0-001-001140831-3
Supersuckers with guests
/boise/events/supersuckers-guests-/E0-001-054620768-7
06-21-2013 07:00 PM
06-20-2013 06:13 AM
2013-06-21 19:00:00
$12.00
evdb
Neurolux
%VenueURL%
111 N Eleventh
Boise
ID
83702
-116.2066749
-116.2066749
4
06-21-2013 07:00 PM
Neurolux - Boise, ID
Category: music
Source: evdb Price: $12.00
E0-001-054682381-0
V0-001-001140831-3
Eidola
/boise/events/eidola-/E0-001-054682381-0
TBA
06-21-2013 08:00 PM
06-20-2013 06:13 AM
2013-06-21 20:00:00
evdb
Neurolux
%VenueURL%
111 N Eleventh
Boise
ID
83702
-116.2066749
-116.2066749
5
06-21-2013 08:00 PM
Neurolux - Boise, ID
Category: music
Source: evdb Price:
E0-001-054779059-1
V0-001-002359017-6
RIPCHAIN - The Sammus Theory - Adler
/jerome/events/ripchain-sammus-theory-adler-/E0-001-054779059-1
Adler w/ The Sammus Theory and Ripchain
06-21-2013 08:00 PM
06-20-2013 06:13 AM
2013-06-21 20:00:00
evdb
Diamondz Bar & Grill
%VenueURL%
220 W. Main St.
Jerome
ID
83338
-114.5207739
-114.5207739
6
06-21-2013 08:00 PM
Diamondz Bar & Grill - Jerome, ID
Category: music
Source: evdb Price:
E0-001-054974905-0
V0-001-005194844-6
The Lost - City Of Vain - Crashed Out - New Iron Front
/boise/events/lost-city-vain-crashed-out-new-iron-front-/E0-001-054974905-0
06-21-2013 08:00 PM
06-20-2013 06:13 AM
2013-06-21 20:00:00
evdb
The Shredder
%VenueURL%
430 S 10th St
Boise
ID
83702
-116.2085990
-116.2085990
7
06-21-2013 08:00 PM
The Shredder - Boise, ID
Category: music
Source: evdb Price:
E0-001-055301531-2
V0-001-000139485-3
Tesla featuring Gypsy Saints
/boise/events/tesla-featuring-gypsy-saints-/E0-001-055301531-2
06-21-2013 08:00 PM
06-20-2013 06:13 AM
2013-06-21 20:00:00
$25.00 - $70.00
evdb
Knitting Factory Concert House
%VenueURL%
416 S Ninth Street
Boise
ID
83702
-116.2073485
-116.2073485
8
06-21-2013 08:00 PM
Knitting Factory Concert House - Boise, ID
Category: music
Source: evdb Price: $25.00 - $70.00
E0-001-055154856-0
V0-001-000867410-1
JACK+JILL
/ketchum/events/jackjill-/E0-001-055154856-0
JACK+JILL LIVE AT WHISKEY JACQUES (KETCHUM, ID)
06-21-2013 09:00 PM
06-20-2013 06:13 AM
2013-06-21 21:00:00
evdb
Whiskey Jacques' (Ketchum, ID)
%VenueURL%
Main Street
Ketchum
ID
83340
-114.3680166
-114.3680166
9
06-21-2013 09:00 PM
Whiskey Jacques' (Ketchum, ID) - Ketchum, ID
Category: music
Source: evdb Price:
E0-001-054353899-3
V0-001-001044054-3
JACK+JILL
/boise/events/jackjill-/E0-001-054353899-3
JACK+JILL ROCK TOM GRAINEY'S (BOISE, ID)
06-21-2013 10:00 PM
06-20-2013 06:13 AM
2013-06-21 22:00:00
evdb
Tom Grainey's Sporting Pub
%VenueURL%
109 S Sixth
Boise
ID
83702
-116.2014354
-116.2014354
10
06-21-2013 10:00 PM
Tom Grainey's Sporting Pub - Boise, ID
Category: music
Source: evdb Price:
E0-001-053733265-3
V0-001-000541581-7
Montana Skies
/boise/events/montana-skies-/E0-001-053733265-3
Age Limit: All Ages
Montana Skies
06-23-2013 08:00 PM
06-20-2013 06:13 AM
2013-06-23 20:00:00
evdb
Redfish Lake Lodge
%VenueURL%
Redfish Lake Rd
Boise
ID
-116.2245718
-116.2245718
11
06-23-2013 08:00 PM
Redfish Lake Lodge - Boise, ID
Category: music
Source: evdb Price:
E0-001-055559077-4
V0-001-001383870-3
Blaze and Kelly
/boise/events/blaze-and-kelly-/E0-001-055559077-4
06-25-2013 08:00 PM
06-20-2013 06:13 AM
2013-06-25 20:00:00
evdb
Sockeye Grill & Brewery
%VenueURL%
3019 Cole Rd
Boise
ID
-116.2741045
-116.2741045
12
06-25-2013 08:00 PM
Sockeye Grill & Brewery - Boise, ID
Category: music
Source: evdb Price:
E0-001-054993033-3
V0-001-000541581-7
Johnny Shoes
/boise/events/johnny-shoes-/E0-001-054993033-3
06-26-2013 05:00 PM
06-20-2013 06:13 AM
2013-06-26 17:00:00
evdb
Redfish Lake Lodge
%VenueURL%
Redfish Lake Rd
Boise
ID
-116.2245718
-116.2245718
13
06-26-2013 05:00 PM
Redfish Lake Lodge - Boise, ID
Category: music
Source: evdb Price:
E0-001-055583291-7
V0-001-000257374-9
PLAGUES - Griever
/boise/events/plagues-griever-/E0-001-055583291-7
Age Limit: All Ages
PLAGUES
Grieverwebsite:
06-26-2013 07:00 PM
06-20-2013 06:13 AM
2013-06-26 19:00:00
evdb
The Venue
%VenueURL%
523 Broad St
Boise
ID
83702
-116.2033222
-116.2033222
14
06-26-2013 07:00 PM
The Venue - Boise, ID
Category: music
Source: evdb Price:
E0-001-055625963-4
V0-001-005194844-6
Domino & the Derelicts - PIRANHAS BC - Survey Says...
/boise/events/domino-derelicts-piranhas-bc-survey-says-/E0-001-055625963-4
06-26-2013 08:00 PM
06-20-2013 06:13 AM
2013-06-26 20:00:00
evdb
The Shredder
%VenueURL%
430 S 10th St
Boise
ID
83702
-116.2085990
-116.2085990
15
06-26-2013 08:00 PM
The Shredder - Boise, ID
Category: music
Source: evdb Price:
E0-001-055696139-5
V0-001-005194844-6
Survay Says! - PIRANHAS BC
/boise/events/survay-says-piranhas-bc-/E0-001-055696139-5
06-26-2013 08:00 PM
06-20-2013 06:13 AM
2013-06-26 20:00:00
evdb
The Shredder
%VenueURL%
430 S 10th St
Boise
ID
83702
-116.2085990
-116.2085990
16
06-26-2013 08:00 PM
The Shredder - Boise, ID
Category: music
Source: evdb Price:
E0-001-055325648-7
V0-001-001502710-7
Barenaked Ladies with Ben Folds Five
/boise/events/barenaked-ladies-ben-folds-five-/E0-001-055325648-7
06-28-2013 06:00 PM
06-20-2013 06:13 AM
2013-06-28 18:00:00
evdb
Idaho Botanical Garden
%VenueURL%
2355 N Penitentiary Road
Boise
ID
-116.1638445
-116.1638445
17
06-28-2013 06:00 PM
Idaho Botanical Garden - Boise, ID
Category: music
Source: evdb Price:
E0-001-054799665-4
V0-001-000467040-8
Joshua Tree - Neo Tundra Cowboy - Johnny Shoes - Boyd Wilson
/boise/events/joshua-tree-neo-tundra-cowboy-johnny-shoes-boyd-wi-/E0-001-054799665-4
06-28-2013 09:00 PM
06-20-2013 06:13 AM
2013-06-28 21:00:00
evdb
Blues Bouquet
%VenueURL%
1010 W. Main Street
Boise
ID
-116.2060870
-116.2060870
18
06-28-2013 09:00 PM
Blues Bouquet - Boise, ID
Category: music
Source: evdb Price:
E0-001-054671500-7
V0-001-000257374-9
MDC
/boise/events/mdc-/E0-001-054671500-7
Supporting Acts: Verbal Abuse, In Defence, Little Miss and The No Names, New Iron Front
MDC
Formed in 1979 as The Stains and playing their first gig under this name in April 1980, MDC were one of three pioneering hardcore punk bands in Austin, Texas, in the early '80s, alongside The Dicks and Big Boys. These bands frequently played together and established the Austin hardcore scene. They released one single as the Stains in 1981, featuring a slower version of the future MDC song "John Wayne Was a Nazi" backed with "Born to Die". Both songs were later released on the debut MDC album. [edit] 1980s By 1982 the band had relocated to San Francisco, California, and renamed themselves MDC. By this point the band were active participants in the growing hardcore scene and released their debut LP Millions of Dead Cops on their own label, R Radical; Jello Biafra's Alternative Tentacles helped with distribution. The album is now widely considered a punk classic, and features songs such as "John Wayne Was a Nazi", "Dick for Brains", and the harsh criticism of the police, "I Remember". Other targets of criticism devoid of irony included capitalism ("Corporate Death Burger"), homophobia ("America's So Straight"),[1] and American culture ("Violent Rednecks"). During the summer of 1982 they became involved in the Rock Against Reagan Tour, during which time they fell out with the band Bad Brains when Rastafarian singer H.R. learned that Big Boys' singer , Randy Turner, was homosexual. H.R. and MDC's Dave Dictor had an intense confrontation. Upon Bad Brains' departure from the bill, they refused to return a loan owed to Big Boys and instead left a note that reportedly read, "burn in hell bloodclot faggot."[2] The indcident resulted in the MDC song Pay to Come Along.[3] For MDC, 1982 ended with a tour of Europe with the Dead Kennedys which brought the band greater exposure in the punk scene outside of the U.S., especially in the UK. Their involvement in the Rock Against Reagan activities continued through 1983 and they returned to recording with the EP "Multi-Death Corporations" which was distributed in the UK by British anarcho-punk label Crass Records and R Radical in the U.S. The EP broke new ground by addressing, in the lengthy liner notes and artwork, the growth of corporations and the violent suppression of Communism in Central America. In 1984 they released another EP, Millions of Dead Children (also known as Chicken Squawk), this time dealing with Vegetarian and Vegan issues via a cowpunk tune. Smoke Signals was released in 1986, their second album featuring a more diverse style than previously, with a foray into '70s rock with the song "South Africa Is Free". This album also saw Gordon Fraser's first appearance as main guitarist. Their third album, This Blood's for You, followed in 1987 and saw them returning to a more orthodox hardcore punk style with themes again including intervention in Central America and criticism of the Reagan Administration. MDC toured Europe in 1988, where the live album Elvis - In the Rhineland was recorded. The band released the album Metal Devil Cokes in 1989. [edit] 1990s The 1990s opened with a number of lineup changes, swiftly followed by the 1991 album Hey Cop! If I Had a Face Like Yours..., featuring Bill Collins on guitar and Matt Freeman (of Operation Ivy) on bass. The acclaimed Shades of Brown album appeared in 1993, released by New Red Archives in the U.S. and We Bite in Europe. The album featured the Hip-Hop vegetarian song "Real Food, Real People, Real Bullets". The band, now with guitarist Chris Wilder and bassist Erica Liss, marked the album with a tour of the former Soviet Union, making MDC the first American punk band to tour Russia. This was followed by two more European tours and several U.S. tours until 1995, where began a lull in the band's activity. The lack of new recorded material (other than a 7-inch release on Slap-a-Ham Records) and live performances after 1994, plus personal problems of band members, pointed to an informal break-up of the band. [edit] 2000s MDC's singer, Dave Dictor, returned with an entirely new backing line-up in 2000, and MDC released a new album, Magnus Dominus Corpus, in 2004. They took part in a 25th anniversary world tour in 2005, with an all-original lineup. Following the death of Mikey Donaldson in September 2007, MDC has been touring the U.S. and Europe extensively with the Dictor/Posner/Smith/Schvitz lineup. Recently, the band has been based in Portland, Oregon. Instrumentation Dave Dictor- Vocals Ron Posner - Guitar Alschvitz - Drums Mike Smith - Bass Russ Kalita - Guitar Discography The Stains - John Wayne was a Nazi / Born to Die MDC - Millions of Dead Cops More Dead Cops Multi Death Corporation Millions of Dead Children Smoke signals This Bloods for you Elvis in the Rhineland (live) Metal Devil Cokes Hey Cop! If I had a face like yours Millions of Damn Christians Shades of Brown No More Then Ever Magnus Dominus Corpus MDC Unplugged / John the Baker Split MDC Unplugged / Riot Cop Split MDC Unplugged - Zombie Love Split The Solid EP The Human EP Mobocracy Split w/ the Restarts
06-29-2013 07:30 PM
06-20-2013 06:13 AM
2013-06-29 19:30:00
$13.00 - $15.00
evdb
The Venue
%VenueURL%
523 Broad St
Boise
ID
83702
-116.2033222
-116.2033222
19
06-29-2013 07:30 PM
The Venue - Boise, ID
Category: music
Source: evdb Price: $13.00 - $15.00
E0-001-055763401-8
V0-001-002359017-6
Danger Alley
/jerome/events/danger-alley-/E0-001-055763401-8
06-29-2013 08:00 PM
06-20-2013 06:13 AM
2013-06-29 20:00:00
evdb
Diamondz Bar & Grill
%VenueURL%
220 W. Main St.
Jerome
ID
83338
-114.5207739
-114.5207739
20
06-29-2013 08:00 PM
Diamondz Bar & Grill - Jerome, ID
Category: music
Source: evdb Price:
E-2034DC-C94-C890B067
V0-001-000307781-7
Celtic Thunder: Mythology
/boise/events/celtic-thunder:-mythology/E-2034DC-C94-C890B067
The awesome power of world music and live performance are taken to the next level with Celtic Thunder's new show MYTHOLOGY. The world-renowned supergroup continues to astonish audiences, traveling as easily across the genres of folk, traditional Irish, adult contemporary, rock and classical crossover, as they travel the world, performing for an ever-growing number of fans.
MYTHOLOGY presents the perfect blend of entertainment, ideology and Gaelic spirituality, providing a modern twist on the old Celtic storytelling tradition.
12-01-2013 05:00 PM
06-20-2013 06:13 AM
2013-12-01 17:00:00
Ticket Prices (service fees not included): P1 $75.00 Orchestra Rows A - C; Floor Rows AA - S P2 $65.00 Floor Rows T - Z P3 $65.00 Mezzanine Rows A - N
tixx
Morrison Center
%VenueURL%
2201 Cesar Chavez Lane
Boise
ID
83706
-116.2045630
-116.2045630
21
12-01-2013 05:00 PM
Morrison Center - Boise, ID
Category: music
Source: tixx Price: Ticket Prices (service fees not included): P1 $75.00 Orchestra Rows A - C; Floor Rows AA - S P2 $65.00 Floor Rows T - Z P3 $65.00 Mezzanine Rows A - N