LISTE POUR : Dropkick Murphys

SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers WHERE tbEventsID = 3454 AND tevoEventPerformers.performerId = 3454 AND tevoEventPerformers.isPrimary = 1 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID ORDER BY tbproductions.Eventdate
DATES
ÉVÉNEMENT
SELECT * from toolvenuepagelink WHERE venueid = 26215
SELECT * from toolcitypagelink WHERE cityname = 'Palmer'

August

Dropkick Murphys
Alaska State Fair Borealis Theatre Palmer Palmer, AK
Aug 30, 7:00 pm 2019
Friday
Aug 30
7:00 pm
Dropkick Murphys
Alaska State Fair Borealis Theatre, Palmer, AK
SELECT * from toolvenuepagelink WHERE venueid = 1466
SELECT * from toolcitypagelink WHERE cityname = 'Springfield'

September

Dropkick Murphys
MassMutual Center Springfield Springfield, MA
Sep 20, 8:00 pm 2019
Friday
Sep 20
8:00 pm
Dropkick Murphys
MassMutual Center, Springfield, MA
SELECT * from toolvenuepagelink WHERE venueid = 5300
SELECT * from toolcitypagelink WHERE cityname = 'Erie'
Dropkick Murphys
Erie Insurance Arena Erie Erie, PA
Sep 21, 7:00 pm 2019
Saturday
Sep 21
7:00 pm
Dropkick Murphys
Erie Insurance Arena, Erie, PA
SELECT * from toolvenuepagelink WHERE venueid = 7333
SELECT * from toolcitypagelink WHERE cityname = 'Raleigh'
Dropkick Murphys with Clutch
Red Hat Amphitheatre Raleigh Raleigh, NC
Sep 24, 6:30 pm 2019
Tuesday
Sep 24
6:30 pm
Dropkick Murphys with Clutch
Red Hat Amphitheatre, Raleigh, NC
SELECT * from toolvenuepagelink WHERE venueid = 8847
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Dropkick Murphys
Charlotte Metro Credit Union Amphitheatre Charlotte Charlotte, NC
Sep 25, 6:45 pm 2019
Wednesday
Sep 25
6:45 pm
Dropkick Murphys
Charlotte Metro Credit Union Amphitheatre, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 30835
SELECT * from toolcitypagelink WHERE cityname = 'Birmingham'
Dropkick Murphys
Avondale Brewing Company Birmingham Birmingham, AL
Sep 26, 5:45 pm 2019
Thursday
Sep 26
5:45 pm
Dropkick Murphys
Avondale Brewing Company, Birmingham, AL
SELECT * from toolvenuepagelink WHERE venueid = 939
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Dropkick Murphys
Masonic Temple Theatre Detroit Detroit, MI
Sep 29, 6:00 pm 2019
Sunday
Sep 29
6:00 pm
Dropkick Murphys
Masonic Temple Theatre, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 56
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Dropkick Murphys
Aragon Ballroom Chicago Chicago, IL
Sep 30, 6:45 pm 2019
Monday
Sep 30
6:45 pm
Dropkick Murphys
Aragon Ballroom, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 3734
SELECT * from toolcitypagelink WHERE cityname = 'St Paul'

October

Dropkick Murphys
Myth St Paul St Paul, MN
Oct 1, 7:15 pm 2019
Tuesday
Oct 1
7:15 pm
Dropkick Murphys
Myth, St Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 7793
SELECT * from toolcitypagelink WHERE cityname = 'Moorhead'
Dropkick Murphys
Bluestem Center For The Arts Moorhead Moorhead, MN
Oct 3, 6:15 pm 2019
Thursday
Oct 3
6:15 pm
Dropkick Murphys
Bluestem Center For The Arts, Moorhead, MN
SELECT * from toolvenuepagelink WHERE venueid = 4221
SELECT * from toolcitypagelink WHERE cityname = 'Broomfield'
Dropkick Murphys
1stBank Center Broomfield Broomfield, CO
Oct 5, 6:30 pm 2019
Saturday
Oct 5
6:30 pm
Dropkick Murphys
1stBank Center, Broomfield, CO
SELECT * from toolvenuepagelink WHERE venueid = 33723
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Dropkick Murphys
The Union Event Center Salt Lake City Salt Lake City, UT
Oct 6, 6:15 pm 2019
Sunday
Oct 6
6:15 pm
Dropkick Murphys
The Union Event Center, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 670
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Dropkick Murphys
Hollywood Palladium Los Angeles Los Angeles, CA
Oct 8, 6:00 pm 2019
Tuesday
Oct 8
6:00 pm
Dropkick Murphys
Hollywood Palladium, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 2775
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Dropkick Murphys
Petco Park San Diego San Diego, CA
Oct 9, 6:00 pm 2019
Wednesday
Oct 9
6:00 pm
Dropkick Murphys
Petco Park, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 30602
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Dropkick Murphys
Brooklyn Bowl Las Vegas at The LINQ Las Vegas Las Vegas, NV
Oct 12, 7:00 pm 2019
Saturday
Oct 12
7:00 pm
Dropkick Murphys
Brooklyn Bowl Las Vegas at The LINQ, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 6633
SELECT * from toolcitypagelink WHERE cityname = 'Boise'
Dropkick Murphys
Idaho Botanical Garden Boise Boise, ID
Oct 14, 5:45 pm 2019
Monday
Oct 14
5:45 pm
Dropkick Murphys
Idaho Botanical Garden, Boise, ID
SELECT * from toolvenuepagelink WHERE venueid = 4291
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Dropkick Murphys
WaMu Theater Seattle Seattle, WA
Oct 15, 6:45 pm 2019
Tuesday
Oct 15
6:45 pm
Dropkick Murphys
WaMu Theater, Seattle, WA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football