SELECT
center, id, beg_date, end_date, last, first,
tier1_name, tier2_name, tier3_name
FROM master_customer mc
WHERE
center = :1 AND id IN (
SELECT id FROM master_customer mc2
WHERE
tier1_name = :2 AND center = :3 AND center = :1 AND id != 99 AND id != 98
AND beg_date = (
SELECT max(beg_date) FROM master_customer mc3
WHERE center = :1 AND mc2.id = mc3.id
)
)
ORDER BY id,beg_date