select link_text , site_name , contents_folder , old_afc_number , action.regist_target_number , (count) as count , program_click_limit from (SELECT link_text , site_name , contents_folder , trn_advertiser_program.old_afc_number , regist_target_number ,
		sum(COALESCE(count,0)) as count , attestation_program_id , program_click_limit , program_click_total
		FROM mst_program_medium_relation left outer join trn_advertiser_program ON
		 mst_program_medium_relation.attestation_id_program = trn_advertiser_program.attestation_id left outer join
		 mst_advertiser ON trn_advertiser_program.advertiser_id = mst_advertiser.advertiser_id left outer join
		  (select count(*) as count , medium , attestation_program_id from trn_click_log
		   group by medium , attestation_program_id )
		  trn_click_log ON trn_advertiser_program.attestation_id = trn_click_log.attestation_program_id
		  1 and view_flag = '1'  group by link_text , site_name , contents_folder , trn_advertiser_program.old_afc_number , regist_target_number  , attestation_program_id , program_click_limit , program_click_total
		  ) action LEFT OUTER JOIN mst_program_medium_relation ON mst_program_medium_relation.attestation_id_program = action.attestation_program_id
		  WHERE case when action.regist_target_number <> 0 then action.regist_target_number > count + old_click_count else program_click_limit > count + program_click_total end
		  group by link_text , site_name , contents_folder , old_afc_number , action.regist_target_number , count , program_click_limit
		  order by random() 

select link_text , site_name , contents_folder , old_afc_number , action.regist_target_number , (count) as count , program_click_limit from (SELECT link_text , site_name , contents_folder , trn_advertiser_program.old_afc_number , regist_target_number ,
		sum(COALESCE(count,0)) as count , attestation_program_id , program_click_limit , program_click_total
		FROM mst_program_medium_relation left outer join trn_advertiser_program ON
		 mst_program_medium_relation.attestation_id_program = trn_advertiser_program.attestation_id left outer join
		 mst_advertiser ON trn_advertiser_program.advertiser_id = mst_advertiser.advertiser_id left outer join
		  (select count(*) as count , medium , attestation_program_id from trn_click_log
		   group by medium , attestation_program_id )
		  trn_click_log ON trn_advertiser_program.attestation_id = trn_click_log.attestation_program_id
		  2 and view_flag = '1'  group by link_text , site_name , contents_folder , trn_advertiser_program.old_afc_number , regist_target_number  , attestation_program_id , program_click_limit , program_click_total
		  ) action LEFT OUTER JOIN mst_program_medium_relation ON mst_program_medium_relation.attestation_id_program = action.attestation_program_id
		  WHERE case when action.regist_target_number <> 0 then action.regist_target_number > count + old_click_count else program_click_limit > count + program_click_total end
		  group by link_text , site_name , contents_folder , old_afc_number , action.regist_target_number , count , program_click_limit
		  order by random() 

select link_text , site_name , contents_folder , old_afc_number , action.regist_target_number , (count) as count , program_click_limit from (SELECT link_text , site_name , contents_folder , trn_advertiser_program.old_afc_number , regist_target_number ,
		sum(COALESCE(count,0)) as count , attestation_program_id , program_click_limit , program_click_total
		FROM mst_program_medium_relation left outer join trn_advertiser_program ON
		 mst_program_medium_relation.attestation_id_program = trn_advertiser_program.attestation_id left outer join
		 mst_advertiser ON trn_advertiser_program.advertiser_id = mst_advertiser.advertiser_id left outer join
		  (select count(*) as count , medium , attestation_program_id from trn_click_log
		   group by medium , attestation_program_id )
		  trn_click_log ON trn_advertiser_program.attestation_id = trn_click_log.attestation_program_id
		  3 and view_flag = '1'  group by link_text , site_name , contents_folder , trn_advertiser_program.old_afc_number , regist_target_number  , attestation_program_id , program_click_limit , program_click_total
		  ) action LEFT OUTER JOIN mst_program_medium_relation ON mst_program_medium_relation.attestation_id_program = action.attestation_program_id
		  WHERE case when action.regist_target_number <> 0 then action.regist_target_number > count + old_click_count else program_click_limit > count + program_click_total end
		  group by link_text , site_name , contents_folder , old_afc_number , action.regist_target_number , count , program_click_limit
		  order by random() 

select link_text , site_name , contents_folder , old_afc_number , action.regist_target_number , (count) as count , program_click_limit from (SELECT link_text , site_name , contents_folder , trn_advertiser_program.old_afc_number , regist_target_number ,
		sum(COALESCE(count,0)) as count , attestation_program_id , program_click_limit , program_click_total
		FROM mst_program_medium_relation left outer join trn_advertiser_program ON
		 mst_program_medium_relation.attestation_id_program = trn_advertiser_program.attestation_id left outer join
		 mst_advertiser ON trn_advertiser_program.advertiser_id = mst_advertiser.advertiser_id left outer join
		  (select count(*) as count , medium , attestation_program_id from trn_click_log
		   group by medium , attestation_program_id )
		  trn_click_log ON trn_advertiser_program.attestation_id = trn_click_log.attestation_program_id
		  4 and view_flag = '1'  group by link_text , site_name , contents_folder , trn_advertiser_program.old_afc_number , regist_target_number  , attestation_program_id , program_click_limit , program_click_total
		  ) action LEFT OUTER JOIN mst_program_medium_relation ON mst_program_medium_relation.attestation_id_program = action.attestation_program_id
		  WHERE case when action.regist_target_number <> 0 then action.regist_target_number > count + old_click_count else program_click_limit > count + program_click_total end
		  group by link_text , site_name , contents_folder , old_afc_number , action.regist_target_number , count , program_click_limit
		  order by random() 

select link_text , site_name , contents_folder , old_afc_number , action.regist_target_number , (count) as count , program_click_limit from (SELECT link_text , site_name , contents_folder , trn_advertiser_program.old_afc_number , regist_target_number ,
		sum(COALESCE(count,0)) as count , attestation_program_id , program_click_limit , program_click_total
		FROM mst_program_medium_relation left outer join trn_advertiser_program ON
		 mst_program_medium_relation.attestation_id_program = trn_advertiser_program.attestation_id left outer join
		 mst_advertiser ON trn_advertiser_program.advertiser_id = mst_advertiser.advertiser_id left outer join
		  (select count(*) as count , medium , attestation_program_id from trn_click_log
		   group by medium , attestation_program_id )
		  trn_click_log ON trn_advertiser_program.attestation_id = trn_click_log.attestation_program_id
		  5 and view_flag = '1'  group by link_text , site_name , contents_folder , trn_advertiser_program.old_afc_number , regist_target_number  , attestation_program_id , program_click_limit , program_click_total
		  ) action LEFT OUTER JOIN mst_program_medium_relation ON mst_program_medium_relation.attestation_id_program = action.attestation_program_id
		  WHERE case when action.regist_target_number <> 0 then action.regist_target_number > count + old_click_count else program_click_limit > count + program_click_total end
		  group by link_text , site_name , contents_folder , old_afc_number , action.regist_target_number , count , program_click_limit
		  order by random() 

QueryError