Soup Stock Tokyo

(default) 1 query took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `MItem`.`item_cd`, `MItem`.`item_name`, `MItem`.`item_detail`, `MItem`.`calorie_s`, `MItem`.`calorie_r`, `MItem`.`calorie_l`, `MItem`.`nutrient_composition_1`, `MItem`.`nutrient_composition_2`, `MItem`.`nutrient_composition_3`, `MItem`.`all_raw_materials`, `MItem`.`store_freezing_division`, `MItem`.`item_division`, `MItem`.`yahoo_url`, `MItem`.`rakuten_url`, `MItem`.`remarks`, `MItem`.`sort`, `MItem`.`delete_flg`, `MItem`.`price`, `MItem`.`updated` FROM `sst_003_db`.`m_item` AS `MItem` INNER JOIN `sst_003_db`.`t_store_freezing` AS `TStoreFreezing` ON (`TStoreFreezing`.`item_cd` = `MItem`.`item_cd`) WHERE `MItem`.`item_division` = '02' AND `MItem`.`store_freezing_division` = '02' ORDER BY `MItem`.`sort` asc332