SELECT id,on_year,on_month,on_day,country,city,venue,has_reviews,has_setlist,has_images,has_audio,has_video,title,band FROM gig g
WHERE g.visible = "Y" AND g.country like "%France%" AND CONCAT(on_year, LPAD(on_month,2,"0"), LPAD(on_day,2,"0")) >= "19950101" AND CONCAT(on_year, LPAD(on_month,2,"0"), LPAD(on_day,2,"0")) <= "19951231" AND ((band like '%b%')
)
ORDER BY country ASC, on_year DESC, on_month DESC, on_day DESC
Gigography
The tour gigography includes a wealth of information and images on every tour date known. The gigography will remain a work in progress. Our research is never ending and fellow fans are asked to provide us with scans of their ticket stubs and other tour related items.
|
|
|
|
|