A Database Error Occurred
Error Number: 1146
Table 'rebirth.song_availability' doesn't exist
SELECT s.id, s.musicnotes_song_id, s.title, s.seo_abbrev as song_seo, s.performer_id, s.privilege_id, s.availability, s.status_id, s.last_updated, CASE WHEN p.entity_name IS NULL then '' ELSE p.entity_name END AS performer, p.seo_abbrev as performer_seo, SUM(CASE WHEN t.tab_type_id = 0 THEN 1 ELSE 0 END) as unknown_count, SUM(CASE WHEN t.tab_type_id = 302 THEN 1 ELSE 0 END) as guitar_count, SUM(CASE WHEN t.tab_type_id = 303 THEN 1 ELSE 0 END) as bass_count, SUM(CASE WHEN t.tab_type_id = 304 THEN 1 ELSE 0 END) as drums_count, COUNT(t.id) as tab_count, (CASE WHEN sa.availability_id IS NOT NULL THEN sa.availability_id ELSE 0 END) as song_availability FROM ((song s)) LEFT JOIN tab t ON t.song_id = s.id JOIN song_availability sa ON sa.song_id = s.id LEFT OUTER JOIN entity p ON p.id = s.performer_id WHERE `s`.`status_id` = 101 AND `s`.`id` = '85349' GROUP BY s.id HAVING tab_count > '0'