『漢方薬』を知ろう!

「る」から始まる漢方薬

#categorylogpublishertime
14SELECT `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`; HerbalMedicineWordsTable2024-12-22 07:13:40

医療・健康コンテンツ