SELECT j.title, ( SELECT sum( realoil_price ) FROM gczyc_wxcx_order WHERE confirm_date = UNIX_TIMESTAMP( CAST( SYSDATE( ) AS DATE ) - INTERVAL 30 DAY ) AND confirm_date now( ) AND is_type = 3 AND order_state = 2 AND site_id = j.id ) AS 近30天总加油....
发布时间:2020-04-30
浏览量: