select c.creat_time,c.order_number,b.product_number,b.product_money,a.user_id from options_product_bind a join options_platform_order_product b on a.item_id = b.product_id1 join options_platform_order c on b.order_number = c.order_number
join options_platform d on d.merchant_name = c.dpm
where d.type=1 and a.item_id != ''