select top 1 fi.subscriber, * from tblNewWestern nw, tblFreeAccessUsers1 fi where fi.surveyDownPmt != '0' and fi.surveyDownPmt is not null and fi.nwDecision='yes' and fi.subscriber is null and fi.email_id = nw.email and fi.market_area = 'HHI' and newWesternList = 1 and timeStamp < '10/24/2025 3:18:14 PM' and timeStamp > '2025-07-28 13:24:41.000' and (market_area is not null or len(newWesternArea) > 7 or len(market_area) > 3) and sentLead is null order by timestamp desc;
Trent
resp:
qry: