"lead_pkey" PRIMARY KEY, btree (terminal_lead_id)
"lead_alloted_to_idx" btree (alloted_to)
"lead_city_code_idx" btree (city_code)
"lead_company_code_idx" btree (company_code)
"lead_creation_dtm_idx" btree (creation_dtm)
"lead_crm_ecode_idx" btree (crm_ecode)
"lead_crm_loc_code_idx" btree (location_code)
"lead_division_code_idx" btree (division_code)
"lead_fos_id_idx" btree (fos_id)
"lead_gs_up_dtm_idx" btree (gs_up_dtm)
"lead_lead_datetime_idx" btree (lead_datetime)
"lead_lead_type_idx" btree (lead_type)
"lead_lg_no_idx" btree (lg_no)
"lead_line_of_business_idx" btree (line_of_business)
"lead_loan_sub_type_idx" btree (loan_sub_type)
"lead_lost_reason_idx" btree (lost_reason)
"lead_rescheduled_reason_idx" btree (rescheduled_reason)
"lead_source_code_idx" btree (source_code)
"lead_stage_idx" btree (stage)
"lead_sub_outcome_idx" btree (sub_outcome)
"lead_userid_idx" btree (userid)

"enquiry_trans_pkey" PRIMARY KEY, btree (terminal_enquiry_id)
"enquiry_comp_code_idx" btree (company_code)
"enquiry_crm_ecode_idx" btree (crm_ecode)
"enquiry_customer_category_code_idx" btree (customer_category_code)
"enquiry_customer_profile_idx" btree (customer_profile)
"enquiry_customer_type_idx" btree (customer_type)
"enquiry_division_code_idx" btree (division_code)
"enquiry_enquiry_date_idx" btree (enquiry_date)
"enquiry_enquiry_entry_date_idx" btree (enquiry_entry_date)
"enquiry_enquiry_mls_idx" btree (mls)
"enquiry_enquiry_no_idx" btree (enquiry_no)
"enquiry_enquiry_trans_id_idx" btree (enquiry_trans_id)
"enquiry_failure_count_idx" btree (failure_count)
"enquiry_fos_id_idx" btree (fos_id)
"enquiry_gs_up_dtm_idx" btree (gs_up_dtm)
"enquiry_is_exported_idx" btree (is_exported)
"enquiry_lg_no_idx" btree (lg_no)
"enquiry_loc_code_idx" btree (location_code)
"enquiry_mls_party_sl_no_idx" btree (mls_party_sl_no)
"enquiry_source_agent_code_idx" btree (source_agent_code)
"enquiry_source_code_idx" btree (source_code)
"enquiry_sub_div_code_idx" btree (sub_div_code)

SELECT e.company_code,e.enquiry_no FROM
(
    SELECT DISTINCT ON (lg_no)lg_no,creation_dtm,sales_promo_activity FROM lead WHERE
    lg_no LIKE 'LC%' OR lg_no LIKE 'LW/%'
    ORDER BY lg_no,creation_dtm
) ld
LEFT JOIN enquiry e ON ld.lg_no = e.lg_no
WHERE e.division_code IN ('000002','000024','000004','000025','000015','000005','000010')
AND ld.sales_promo_activity IN ('003253','003258')
AND e.terminal_enquiry_id = '78759a9f5476a19c_1558509584114_0000';