LISTE POUR : Joji

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

January

Joji
The Observatory Santa Ana Santa Ana, CA
Jan 29, 8:00 pm 2019
Tuesday
Jan 29
8:00 pm
Joji
The Observatory, Santa Ana, CA
SELECT * from toolvenuepagelink WHERE venueid = 442
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Joji
El Rey Theatre Los Angeles Los Angeles, CA
Jan 31, 9:00 pm 2019
Thursday
Jan 31
9:00 pm
Joji
El Rey Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 442
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'

February

Joji
El Rey Theatre Los Angeles Los Angeles, CA
Feb 1, 9:00 pm 2019
Friday
Feb 1
9:00 pm
Joji
El Rey Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 33004
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Joji
Velvet Underground - Toronto Toronto Toronto, ON
Feb 5, 7:00 pm 2019
Tuesday
Feb 5
7:00 pm
Joji
Velvet Underground - Toronto, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 33004
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Joji
Velvet Underground - Toronto Toronto Toronto, ON
Feb 6, 7:00 pm 2019
Wednesday
Feb 6
7:00 pm
Joji
Velvet Underground - Toronto, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 5471
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Joji
Bottom Lounge Chicago Chicago, IL
Feb 8, 7:30 pm 2019
Friday
Feb 8
7:30 pm
Joji
Bottom Lounge, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 1822
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Joji
Bowery Ballroom New York New York, NY
Feb 14, 8:00 pm 2019
Thursday
Feb 14
8:00 pm
Joji
Bowery Ballroom, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 1822
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Joji
Bowery Ballroom New York New York, NY
Feb 15, 8:00 pm 2019
Friday
Feb 15
8:00 pm
Joji
Bowery Ballroom, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 28942
SELECT * from toolcitypagelink WHERE cityname = 'Cambridge'
Joji
Middle East - Downstairs Cambridge Cambridge, MA
Feb 16, 7:00 pm 2019
Saturday
Feb 16
7:00 pm
Joji
Middle East - Downstairs, Cambridge, MA
SELECT * from toolvenuepagelink WHERE venueid = 1803
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Joji
Slim's San Francisco San Francisco, CA
Feb 19, 8:00 pm 2019
Tuesday
Feb 19
8:00 pm
Joji
Slim's, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 1803
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Joji
Slim's San Francisco San Francisco, CA
Feb 20, 8:00 pm 2019
Wednesday
Feb 20
8:00 pm
Joji
Slim's, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 27533
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Joji
Fortune Sound Club Vancouver Vancouver, Br
Feb 22, 7:00 pm 2019
Friday
Feb 22
7:00 pm
Joji
Fortune Sound Club, Vancouver, Br
SELECT * from toolvenuepagelink WHERE venueid = 3268
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Joji
Crocodile Cafe Seattle Seattle, WA
Feb 23, 7:00 pm 2019
Saturday
Feb 23
7:00 pm
Joji
Crocodile Cafe, 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