SELECT DISTINCT p.idx, pt.tidx, pt.is_greate, pt.showing_topic, p.end_date FROM im_eco_program_topic_table pt LEFT JOIN im_eco_program_table p on p.idx=pt.pidx LEFT JOIN im_eco_topic_table t on t.idx=pt.tidx LEFT JOIN im_eco_program_expected_score_table es on es.pidx=p.idx LEFT JOIN im_coursemos_institution_table i on i.idx = p.iidx LEFT JOIN im_eco_program_essential_table pes on pes.pidx=p.idx LEFT JOIN im_essential_table e on e.idx=p.essential1 WHERE   p.use_ko = 'TRUE'  AND p.is_visible = 'TRUE'  AND pt.showing_topic != 'FALSE'  AND p.category1 = 1