select
d.f1 as '支付日期' ,
d.f2 as '订单金额' ,
d.f4 as '交易号'
from
(
select
post_id,
case meta_key when '_paid_date' then meta_value else (select meta_value from wp_postmeta where meta_key='_paid_date' and post_id=w.post_id) end as f1,
case meta_key when '_order_total' then meta_value else (select meta_value from wp_postmeta where meta_key='_order_total' and post_id=w.post_id) end as f2 ,
case meta_key when 'trade_no' then meta_value else (select meta_value from wp_postmeta where meta_key='trade_no' and post_id=w.post_id) end as f4
from wp_postmeta w
group by post_id
) as d
where d.f1 > '2019-11-15'
