| 1 | 4 | SELECT `HerbalMedicineWord`.`id`, `HerbalMedicineWord`.`word_category_id`, `HerbalMedicineWord`.`herbal_medicine_id`, `HerbalMedicineWord`.`herbal_medicine_kind_id`, `HerbalMedicineWord`.`name`, `HerbalMedicineWord`.`reading`, `HerbalMedicineWord`.`exists_same`, `HerbalMedicine`.`id` AS `HerbalMedicine__id`, `HerbalMedicine`.`name` AS `HerbalMedicine__name`, `HerbalMedicine`.`chinese_medicine_book_id` AS `HerbalMedicine__chinese_medicine_book_id`, `HerbalMedicineKind`.`id` AS `HerbalMedicineKind__id`, `HerbalMedicineKind`.`name` AS `HerbalMedicineKind__name`, `ChineseMedicineBook`.`id` AS `ChineseMedicineBook__id`, `ChineseMedicineBook`.`name` AS `ChineseMedicineBook__name`
FROM med__herbal_medicine_words AS HerbalMedicineWord
LEFT JOIN med__herbal_medicines AS HerbalMedicine ON HerbalMedicineWord.`herbal_medicine_id` = HerbalMedicine.`id`
LEFT JOIN med__herbal_medicine_kinds AS HerbalMedicineKind ON HerbalMedicineWord.`herbal_medicine_kind_id` = HerbalMedicineKind.`id`
LEFT JOIN med__chinese_medicine_books AS ChineseMedicineBook ON HerbalMedicine.`chinese_medicine_book_id` = ChineseMedicineBook.`id`
WHERE HerbalMedicineWord.`lexicode` LIKE "き%"
ORDER BY HerbalMedicineWord.`lexicode` ASC, HerbalMedicineWord.`reading` ASC, HerbalMedicineWord.`name`;
| HerbalMedicineWordsTable | 2024-12-22 01:18:11 |
