Deprecated: Creation of dynamic property HerbalMedicineWordsTable::$alias is deprecated in
/var/www/vhosts/asada-shinkyu.jp/www.asada-shinkyu.jp/public_html/wp-content/plugins/iatrism-database-connection/classes/Tables/Table.php on line
32
Deprecated: Creation of dynamic property HerbalMedicinesTable::$alias is deprecated in
/var/www/vhosts/asada-shinkyu.jp/www.asada-shinkyu.jp/public_html/wp-content/plugins/iatrism-database-connection/classes/Tables/Table.php on line
32
Deprecated: Creation of dynamic property HerbalMedicineKindsTable::$alias is deprecated in
/var/www/vhosts/asada-shinkyu.jp/www.asada-shinkyu.jp/public_html/wp-content/plugins/iatrism-database-connection/classes/Tables/Table.php on line
32
Deprecated: Creation of dynamic property ChineseMedicineBooksTable::$alias is deprecated in
/var/www/vhosts/asada-shinkyu.jp/www.asada-shinkyu.jp/public_html/wp-content/plugins/iatrism-database-connection/classes/Tables/Table.php on line
32
「わ」から始まる漢方薬
| # | category | log | publisher | time |
|---|
| 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 | 2025-10-19 23:48:08 |
