Select Potential Contact

Dari db.combined

select "timestamp", branch, phone, name, contact_owner, assigned_pic, interest, interest_remarks, source, sremarks
from public.combined where mql_date is null ORDER by "timestamp" DESC

Dari db.web

select timestamp, branch, phone, name, appt_date, trial_class, value, contact_owner, date_of_birth, path 
from public.web where appt_id is null ORDER by timestamp DESC

Dari db.appt

select 
appt_date,
branch,
visit_category,
appt_category,
name, phone, contact_owner, assigned_pic, created_by, class_category, trial_class, visit_notes, kyzn_account,
mql_date, missed_date
from public.appt where appt_date::date < '2025-02-17' AND "mqlPlus_date" is null order by appt_date DESC