竞赛成果

select COUNT(*) as '竞赛成果数',
               (select COUNT(distinct crl.open_competition_id) from achievements a join competition_resource_library crl
                   on a.source_id = crl.id where source = '3' and a.is_expert_audit = 1 and a.status='1') as '参与评审竞赛数',
               (select count(1) from clickers c inner join achievements a ON  a.id = c.click_id where click_type = 'Achievements'  and a.source='3' and a.status='1') as '竞赛点击数',
               (select COUNT(distinct open_competition_id) from competition_resource_library crl inner join achievements a on a.source_id=crl.id where a.status='1') as  '开放竞赛数'
        from achievements
        where source = '3' and status='1';