(select a.product_flag,b.product_no from product_category as a join product as b on (a.product_category_no=b.product_type)) as c
where c.product_no=8
where product_property_name="年费" and (product_property_detail_content between 360 and 500)
(select bank.bank_name from bank where bank.bank_no=product.company_no)as company_no,product_desc
from product where product_type=12 and company_no= 2
(select product_property_detail_content from product_property_detail where product_no=8 and product_property_no=30) as dhsx,
product_function as jbgn,
((select c.product_flag from (select a.product_flag,b.product_no from product_category as a join product as b on (a.product_category_no=b.product_type)) as c where c.product_no=8 ) )as cplb
FROM product where product_no=8
where product_property_no=3 and (product_property_detail_content between 360 and 500)
union all
select product_no from product where product_type=12 and company_no= 2
order by product_no
as name,product_property_detail_content as jbgn
from product_property_detail where product_no=8 and
(product_property_no=1 or product_property_no=13 or product_property_no=14 or product_property_no=15 )
in
(select product_no from product where creditcard_rating="金卡")
where product_property_no=3 and (product_property_detail_content between 360 and 500) ) as a
inner join
(select product_no from product where product_type=12 and company_no= 2 ) as b
on a.product_no=b.product_no
where product_no in (
select max(product_no) from product_property_detail
where product_property_no = a.product_property_no
)
where not exists (
select 1 from product_property_detail
where product_property_no = a.product_property_no and
product_no > a.product_no
)