| 1 | 4 | SELECT `CrudeDrugWord`.`id`, `CrudeDrugWord`.`name`, `CrudeDrugWord`.`reading`, `CrudeDrugWord`.`crude_drug_id`, `CrudeDrugWord`.`crude_drug_kind_id`, `CrudeDrugKind`.`name` AS `CrudeDrugKind__name` FROM `iatrism_glossary`.`med__crude_drug_words` AS `CrudeDrugWord` LEFT JOIN `iatrism_glossary`.`med__crude_drug_kinds` AS `CrudeDrugKind` ON `CrudeDrugWord`.`crude_drug_kind_id` = `CrudeDrugKind`.`id` WHERE `CrudeDrugWord`.`lexicode` LIKE "ろ%" ORDER BY `CrudeDrugWord`.`lexicode` ASC, `CrudeDrugWord`.`reading` ASC, `CrudeDrugWord`.`name` ASC; | CrudeDrugWordsTable | 2024-12-22 01:18:22 |
