select s.id,
s.songname,
s.coverurl,
s.band as band_id,
b.bandname
from songs as s,
bands as b,
gb_finalists as f
where b.id = s.band and
s.id = f.song_id [nativecode=1146 ** Table 'mikseri2_DB.gb_finalists' doesn't exist]