SELECT `TBL_PRODUCTS`.*, `MTR_MAKER`.`MAKER_VCHR`, (SELECT `TOTAL_NUM_INT` FROM `TBL_STOCKS` AS `TS` WHERE `TS`.`PRODUCT_ID_INT` = `TBL_PRODUCTS`.`ID_INT` ORDER BY `TS`.`ID_INT` DESC LIMIT 1 ) AS `TOTAL_NUM_INT` FROM `TBL_PRODUCTS` LEFT JOIN `MTR_MAKER` ON `TBL_PRODUCTS`.`MAKER_ID_INT` = `MTR_MAKER`.`ID_INT` WHERE `TBL_PRODUCTS`.`ID_INT` = 218 FIAMM A0009829608｜【公式】E-DIRECT イーダイレクト ー国産車・欧州車・北米車のバッテリー販売ー 株式会社イーグルライン
