创客成果

-- 首页task统计indexTaskStatistic
 select (select count(distinct trl.task_id) from achievements a join task_resource_library trl on a.source_id = trl.id where a.source='2') as '创客任务数',
               (select count(1) from clickers c inner join achievements a ON  a.id = c.click_id where click_type = 'Achievements'  and a.source='2') as  '创客点击数',
               COUNT(*) as '创客成果数'
        from achievements
        where source = '2';

-- 首页创客任务的金额
  select IFNULL(SUM(bounty), 0) as '任务金额（元）'
        from (select distinct t.id, t.bounty
              from tasks t
                       join (select task_id from papers where status = 2) p on t.id = p.task_id
                       join task_resource_library on t.id = task_resource_library.task_id
                       join achievements a on a.source_id = task_resource_library.id and a.source='2' and a.status= '1'
              where is_transferred_to_results_library = 1) tmp;