mysql 建立中间表，提供查询更新多条数据

UPDATE `表1` set status=1  WHERE `id`  IN (SELECT temp.id FROM (SELECT o.id
FROM `表1` o  
LEFT JOIN `表2` d on d.`order_id` =o.`id` 
WHERE o.`store_id`  =1  and d.id IS NULL          
GROUP BY o.`id` 
ORDER BY o.`id`  DESC )temp )