SELECT t1.pt_id,t1.pt_category,t1.pt_sub_category,t1.pt_type1,t1.pt_type2,t1.pt_name,t1.pt_price,t1.pt_sub_photo0, t3.mb_trade_name FROM shop_parts AS t1,m_branch AS t3,m_client AS t4 WHERE t1.pt_flg=2 AND t1.pt_shop_cd=t3.branch_id AND t3.client_cd=t4.client_cd AND t3.mb_pubflg=1 AND t4.mc_review_indicator=1 AND t3.mb_parts_division=1 AND t3.mb_parts_from<=20240727 AND t3.mb_parts_to>=20240727 ORDER BY t1.pt_last_update DESC LIMIT 2