select *, (select genre from jorzine_Genre where autoid = (select genre from jorzine_bands where bandname = jorzine_releases.bandname)) as theGenre from jorzine_releases where type = 2 and flag = 1 and coverFront <> '' order by newid()
JorZine Jordanian MetaL WebZine ,Jordaninan Bands ,Metal Concerts ,Jordan
Metal Scene, Discussion Forums, Jordanian Metal E-Zine