LISTE POUR : Dashboard Confessional

SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers WHERE tbEventsID = 2877 AND tevoEventPerformers.performerId = 2877 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 = 794
SELECT * from toolcitypagelink WHERE cityname = 'Wilkes Barre'

January

Dashboard Confessional with Tigers Jaw
Kirby Center Wilkes Barre Wilkes Barre, PA
Jan 28, 6:15 pm 2018
Sunday
Jan 28
6:15 pm
Dashboard Confessional with Tigers Jaw
Kirby Center, Wilkes Barre, PA
SELECT * from toolvenuepagelink WHERE venueid = 1945
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'

February

Dashboard Confessional
Commodore Ballroom Vancouver Vancouver, BC
Feb 21, 8:00 pm 2018
Wednesday
Feb 21
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1945
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Dashboard Confessional
Commodore Ballroom Vancouver Vancouver, BC
Feb 23, 8:00 pm 2018
Friday
Feb 23
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 30565
SELECT * from toolcitypagelink WHERE cityname = 'Victoria'
Dashboard Confessional
Sugar Night Club Victoria Victoria, BC
Feb 23, 8:00 pm 2018
Friday
Feb 23
8:00 pm
Dashboard Confessional
Sugar Night Club, Victoria, BC
SELECT * from toolvenuepagelink WHERE venueid = 1645
SELECT * from toolcitypagelink WHERE cityname = 'Calgary'
Dashboard Confessional
MacEwan Hall Calgary Calgary, AB
Feb 27, 7:00 pm 2018
Tuesday
Feb 27
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1630
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
Dashboard Confessional
Union Hall Phoenix Phoenix, AZ
Feb 28, 7:00 pm 2018
Wednesday
Feb 28
7:00 pm
Dashboard Confessional
Union Hall, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 5495
SELECT * from toolcitypagelink WHERE cityname = 'Saskatoon'

March

Dashboard Confessional
Odeon Events Centre Saskatoon Saskatoon, SK
Mar 2, 7:00 pm 2018
Friday
Mar 2
7:00 pm
Dashboard Confessional
Odeon Events Centre, Saskatoon, SK
SELECT * from toolvenuepagelink WHERE venueid = 3021
SELECT * from toolcitypagelink WHERE cityname = 'Winnipeg'
Dashboard Confessional
Burton Cummings Theatre Winnipeg Winnipeg, MB
Mar 3, 8:00 pm 2018
Saturday
Mar 3
8:00 pm
Dashboard Confessional
Burton Cummings Theatre, Winnipeg, MB
SELECT * from toolvenuepagelink WHERE venueid = 27110
SELECT * from toolcitypagelink WHERE cityname = 'London'
Dashboard Confessional
London Music Club-ON London London, ON
Mar 6, 8:00 pm 2018
Tuesday
Mar 6
8:00 pm
Dashboard Confessional
London Music Club-ON, London, ON
SELECT * from toolvenuepagelink WHERE venueid = 5105
SELECT * from toolcitypagelink WHERE cityname = 'Ottawa'
Dashboard Confessional
Bronson Centre Ottawa Ottawa, ON
Mar 7, 7:30 pm 2018
Wednesday
Mar 7
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 6772
SELECT * from toolcitypagelink WHERE cityname = 'Quebec City'
Dashboard Confessional
Imperial Du Quebec Quebec City Quebec City, QC
Mar 8, 8:00 pm 2018
Thursday
Mar 8
8:00 pm
Dashboard Confessional
Imperial Du Quebec, Quebec City, QC
SELECT * from toolvenuepagelink WHERE venueid = 18123
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Dashboard Confessional
Corona Theatre Montreal Montreal, QC
Mar 9, 7:30 pm 2018
Friday
Mar 9
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Dashboard Confessional
Danforth Music Hall Toronto Toronto, ON
Mar 10, 7:00 pm 2018
Saturday
Mar 10
7:00 pm
Dashboard Confessional
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Dashboard Confessional
Danforth Music Hall Toronto Toronto, ON
Mar 11, 7:00 pm 2018
Sunday
Mar 11
7:00 pm
Dashboard Confessional
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 5679
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Dashboard Confessional
House of Blues - Houston Houston Houston, TX
Mar 20, 6:30 pm 2018
Tuesday
Mar 20
6:30 pm
Dashboard Confessional
House of Blues - Houston, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 4568
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Dashboard Confessional
House of Blues - Dallas Dallas Dallas, TX
Mar 21, 6:30 pm 2018
Wednesday
Mar 21
6:30 pm
Dashboard Confessional
House of Blues - Dallas, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 7465
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Dashboard Confessional
Buckhead Theatre Atlanta Atlanta, GA
Mar 23, 6:30 pm 2018
Friday
Mar 23
6:30 pm
Dashboard Confessional
Buckhead Theatre, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 744
SELECT * from toolcitypagelink WHERE cityname = 'St Petersburg'
Dashboard Confessional
Jannus Live St Petersburg St Petersburg, FL
Mar 24, 5:30 pm 2018
Saturday
Mar 24
5:30 pm
Dashboard Confessional
Jannus Live, St Petersburg, FL
SELECT * from toolvenuepagelink WHERE venueid = 681
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Dashboard Confessional
House of Blues - Orlando Orlando Orlando, FL
Mar 25, 7:30 pm 2018
Sunday
Mar 25
7:30 pm
Dashboard Confessional
House of Blues - Orlando, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 31828
SELECT * from toolcitypagelink WHERE cityname = 'Raleigh'
Dashboard Confessional
The Ritz Theatre - NC Raleigh Raleigh, NC
Mar 26, 6:30 pm 2018
Monday
Mar 26
6:30 pm
Dashboard Confessional
The Ritz Theatre - NC, Raleigh, NC
SELECT * from toolvenuepagelink WHERE venueid = 6693
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Dashboard Confessional
The Underground - Fillmore Charlotte Charlotte Charlotte, NC
Mar 27, 6:30 pm 2018
Tuesday
Mar 27
6:30 pm
Dashboard Confessional
The Underground - Fillmore Charlotte, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 33405
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
Dashboard Confessional
Brooklyn Steel Brooklyn Brooklyn, NY
Mar 29, 6:30 pm 2018
Thursday
Mar 29
6:30 pm
Dashboard Confessional
Brooklyn Steel, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Dashboard Confessional
House of Blues - Boston Boston Boston, MA
Mar 30, 6:30 pm 2018
Friday
Mar 30
6:30 pm
Dashboard Confessional
House of Blues - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 7900
SELECT * from toolcitypagelink WHERE cityname = 'Silver Spring'
Dashboard Confessional
The Fillmore Silver Spring Silver Spring Silver Spring, MD
Mar 31, 6:30 pm 2018
Saturday
Mar 31
6:30 pm
Dashboard Confessional
The Fillmore Silver Spring, Silver Spring, MD
SELECT * from toolvenuepagelink WHERE venueid = 1500
SELECT * from toolcitypagelink WHERE cityname = 'Asbury Park'

April

Dashboard Confessional
Stone Pony Asbury Park Asbury Park, NJ
Apr 2, 5:30 pm 2018
Monday
Apr 2
5:30 pm
Dashboard Confessional
Stone Pony, Asbury Park, NJ
SELECT * from toolvenuepagelink WHERE venueid = 3266
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Dashboard Confessional
House of Blues - Cleveland Cleveland Cleveland, OH
Apr 3, 6:30 pm 2018
Tuesday
Apr 3
6:30 pm
Dashboard Confessional
House of Blues - Cleveland, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 1857
SELECT * from toolcitypagelink WHERE cityname = 'Cincinnati'
Dashboard Confessional
Bogarts Cincinnati Cincinnati, OH
Apr 4, 5:30 pm 2018
Wednesday
Apr 4
5:30 pm
Dashboard Confessional
Bogarts, Cincinnati, OH
SELECT * from toolvenuepagelink WHERE venueid = 1371
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Dashboard Confessional
St. Andrews Hall Detroit Detroit, MI
Apr 5, 5:30 pm 2018
Thursday
Apr 5
5:30 pm
Dashboard Confessional
St. Andrews Hall, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 33426
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
Dashboard Confessional
20 Monroe Live Grand Rapids Grand Rapids, MI
Apr 6, 5:30 pm 2018
Friday
Apr 6
5:30 pm
Dashboard Confessional
20 Monroe Live, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 30531
SELECT * from toolcitypagelink WHERE cityname = 'Louisville'
Dashboard Confessional
Mercury Ballroom Louisville Louisville, KY
Apr 7, 6:30 pm 2018
Saturday
Apr 7
6:30 pm
Dashboard Confessional
Mercury Ballroom, Louisville, KY
SELECT * from toolvenuepagelink WHERE venueid = 592
SELECT * from toolcitypagelink WHERE cityname = 'Lawrence'
Dashboard Confessional
Granada - KS Lawrence Lawrence, KS
Apr 8, 8:00 pm 2018
Sunday
Apr 8
8:00 pm
Dashboard Confessional
Granada - KS, Lawrence, KS
SELECT * from toolvenuepagelink WHERE venueid = 7810
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Dashboard Confessional
Summit Music Hall Denver Denver, CO
Apr 9, 6:30 pm 2018
Monday
Apr 9
6:30 pm
Dashboard Confessional
Summit Music Hall, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 9539
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Dashboard Confessional
The Complex Salt Lake City Salt Lake City, UT
Apr 11, 5:30 pm 2018
Wednesday
Apr 11
5:30 pm
Dashboard Confessional
The Complex, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 2135
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Dashboard Confessional
Roseland Theater Portland Portland, OR
Apr 13, 6:30 pm 2018
Friday
Apr 13
6:30 pm
Dashboard Confessional
Roseland Theater, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Dashboard Confessional
The Showbox Seattle Seattle, WA
Apr 14, 6:30 pm 2018
Saturday
Apr 14
6:30 pm
Dashboard Confessional
The Showbox, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 9556
SELECT * from toolcitypagelink WHERE cityname = 'Sacramento'
Dashboard Confessional
Ace of Spades Sacramento Sacramento, CA
Apr 16, 6:30 pm 2018
Monday
Apr 16
6:30 pm
Dashboard Confessional
Ace of Spades, Sacramento, CA
SELECT * from toolvenuepagelink WHERE venueid = 492
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Dashboard Confessional
The Fillmore San Francisco San Francisco, CA
Apr 17, 6:30 pm 2018
Tuesday
Apr 17
6:30 pm
Dashboard Confessional
The Fillmore, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 3493
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Dashboard Confessional
House of Blues - San Diego San Diego San Diego, CA
Apr 18, 6:30 pm 2018
Wednesday
Apr 18
6:30 pm
Dashboard Confessional
House of Blues - San Diego, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 2074
SELECT * from toolcitypagelink WHERE cityname = 'Anaheim'
Dashboard Confessional
House of Blues - Anaheim Anaheim Anaheim, CA
Apr 20, 6:30 pm 2018
Friday
Apr 20
6:30 pm
Dashboard Confessional
House of Blues - Anaheim, Anaheim, CA
SELECT * from toolvenuepagelink WHERE venueid = 670
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Dashboard Confessional
Hollywood Palladium Los Angeles Los Angeles, CA
Apr 21, 6:30 pm 2018
Saturday
Apr 21
6:30 pm
Dashboard Confessional
Hollywood Palladium, Los Angeles, CA
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football
NOUVELLES - SPORT