Show all abnormal lab results with patient and visit details. Return the test_name, result_value, unit, patient first_name and last_name, visit_date, and diagnosis for abnormal results (is_abnormal = 1).