/** * メーカー商品数数の登録を行う. * * @param Query $objQuery Query インスタンス * @return void */ public function countMaker($objQuery) { //テーブル内容の削除 $objQuery->query('DELETE FROM dtb_maker_count'); //各メーカーの商品数を数えて格納 $sql = ' INSERT INTO dtb_maker_count(maker_id, product_count, create_date) '; $sql .= ' SELECT T1.maker_id, count(T2.maker_id), CURRENT_TIMESTAMP '; $sql .= ' FROM dtb_maker AS T1 LEFT JOIN dtb_products AS T2'; $sql .= ' ON T1.maker_id = T2.maker_id '; $sql .= ' WHERE T2.del_flg = 0 AND T2.status = 1 '; $sql .= ' GROUP BY T1.maker_id, T2.maker_id '; $objQuery->query($sql); }