-- SNS「表示する」にセット(カテゴリを除く) select * from page_reserve_item a where customer_id=1020 and reserve_item_id=7 and page_no in (select page_no from page_info where customer_id=a.customer_id and page_no not in (select index_page_no from category where customer_id=a.customer_id)); update page_reserve_item set reserve_item_value='1:2:表示する' where customer_id=1020 and reserve_item_id=7 and page_no in (select page_no from page_info where customer_id=1020 and page_no not in (select index_page_no from category where customer_id=1020));