A Database Error Occurred
Error Number: 1327
Undeclared variable: amp
SELECT music_id, position as c_position, cc_position, organ_image, chart_position, comment_position, fk_user_id, fk_organ_id, music_description, music_file_name, music_title, IF(fk_composer_id = 999, composer_other, composer_name) AS composer_name, IF(fk_genre_id = 999, genre_other, genre_name) AS genre_name, IF(fk_organ_id = 999, organ_other, organ_name) AS organ_name, user_name, fk_composer_id, organ_id, organ_url, organ_other, music_created, music_stereo, music_live, music_youtube_id, comment_count, view_count, recommendations, so_title FROM music LEFT JOIN fa_user_profile on fa_user_profile.id = music.fk_user_id LEFT JOIN monthly_chart c ON chart_music_id = music_id LEFT JOIN monthly_comment_chart ON cc_music_id = music_id LEFT JOIN composers ON fk_composer_id = composer_id LEFT JOIN organs ON fk_organ_id = organ_id LEFT JOIN genres ON fk_genre_id = genre_id LEFT JOIN fa_user ON fk_user_id = fa_user.id LEFT JOIN software ON fk_software_id = so_id WHERE music_valid = 1 AND upload_to = 'public' AND (music_title LIKE '%cavaille-coll%' OR composer_name LIKE '%cavaille-coll%' OR user_name LIKE '%cavaille-coll%' OR organ_name LIKE '%cavaille-coll%' OR genre_name LIKE '%cavaille-coll%' OR organ_other LIKE '%cavaille-coll%' OR genre_other LIKE '%cavaille-coll%' OR composer_other LIKE '%cavaille-coll%') ORDER BY user_name asc LIMIT amp, 20