SELECT `diagnosis`.* FROM `diagnosis` WHERE (profile_id = 6530) AND (surgery_id != 0)