<< back   
No Database Selected
SELECT a.video_url, a.show_id, b.name, c.show_date, c.show_venue, c.show_band FROM videos a LEFT JOIN lyrics b ON a.song_id=b.song_id LEFT JOIN shows c ON a.show_id=c.show_id WHERE a.video_id = 49