select order_id

FROM

    yzj_store_order t

WHERE

    (t.user_id,t.order_status) IN ( SELECT user_id,order_status FROM yzj_store_order where order_status=0 AND DATE_FORMAT( create_date, '%Y-%m-%d' ) = DATE_FORMAT( CURDATE( ) - 0, '%Y-%m-%d' )  GROUP BY user_id,order_status HAVING count( * ) > 1 )

    AND DATE_FORMAT( create_date, '%Y-%m-%d' ) = DATE_FORMAT( CURDATE( ) - 0, '%Y-%m-%d' )

    AND id NOT IN (

SELECT

    min( id )

FROM

    yzj_store_order

WHERE

    DATE_FORMAT( create_date, '%Y-%m-%d' ) = DATE_FORMAT( CURDATE( ) - 0, '%Y-%m-%d' )

    and order_status=0

GROUP BY

    user_id,order_status

HAVING

    count( * ) > 1

    ) ORDER BY user_id desc

    select order_id

FROM

    yzj_store_order t

WHERE

    (t.user_id,t.order_status) IN ( SELECT user_id,order_status FROM yzj_store_order where order_status=1 AND DATE_FORMAT( create_date, '%Y-%m-%d' ) = DATE_FORMAT( CURDATE( ) - 0, '%Y-%m-%d' )  GROUP BY user_id,order_status HAVING count( * ) > 1 )

    AND DATE_FORMAT( create_date, '%Y-%m-%d' ) = DATE_FORMAT( CURDATE( ) - 0, '%Y-%m-%d' )

    AND id NOT IN (

SELECT

    min( id )

FROM

    yzj_store_order

WHERE

    DATE_FORMAT( create_date, '%Y-%m-%d' ) = DATE_FORMAT( CURDATE( ) - 0, '%Y-%m-%d' )

    and order_status=1

GROUP BY

    user_id,order_status

HAVING

    count( * ) > 1

    ) ORDER BY user_id desc