1 | 4 | SELECT DISTINCT
Examination.id, Examination.name, Examination.reading,
ExamType.category AS ExamType__category
FROM
ex__examinations AS Examination
LEFT JOIN
ex__exam_diseases_examinations AS ExamDiseasesExaminations
ON Examination.id = ExamDiseasesExaminations.examination_id
LEFT JOIN
ex__examinations_types AS ExaminationsType
ON Examination.id = ExaminationsType.examination_id
LEFT JOIN
ex__exam_diseases AS ED
ON ED.id = ExamDiseasesExaminations.exam_disease_id
LEFT JOIN
ex__exam_types AS ExamType
ON ExamType.id = ExaminationsType.type_id
WHERE
ED.name = "クラミジア肺炎"
ORDER BY
Examination.lexicode ASC, Examination.name ASC
| ExaminationsTable | 2024-12-27 00:22:59 |