wwx111111

SET STATISTICS io ON
        SET STATISTICS time ON
        Go
SELECT up.project_id, up.lab_id, up.user_id, up.title, up.key_word, up.project_abstract, up.model_name, up.case_num, up.create_time, up.project_type, ul.lab_name, uu.userName, isnull(ut.trade_vol,0) as trade_vol FROM ui_project_info AS up LEFT OUTER JOIN                ui_user AS uu ON up.user_id = uu.userId LEFT OUTER JOIN ui_lab_info AS ul ON up.lab_id = ul.lab_id                                     LEFT OUTER JOIN (SELECT COUNT(*) AS trade_vol, seller_project_id FROM  ui_case_trade_log                                       GROUP BY seller_project_id) AS ut ON ut.seller_project_id = up.project_id where 1 = 1 and user_id =20 and up.lab_id =1   
         
        go
        SET STATISTICS profile OFF
        SET STATISTICS io OFF
        SET STATISTICS time OFF



USE [sed]
GO