这样的问题如何解决？

select * from product where userid in
(
--取出产品名称包含“aaa”的产品  并且----
    select userid from product where pname like '%aaa%' and
   (pid in
      (--如果一个用户有多个产品的话只取 pid为 min(pid)  即pid为最小值的 产品
       select min(pid) from product group by userid having count(pid)>1
      )
    or pid in
      (--如果一个用户只有一个产品  则直接取
       select pid from product group by userid having count(pid)=1
      )
   )
)
order by updatetime