select * from (SELECT `CorpName`, `CorpID`,PolicyNumber FROM (`policies`) WHERE MATCH(policies.CorpPath) AGAINST('16207') ORDER BY ID desc )as temp GROUP BY CorpID
select * from (SELECT `CorpName`, `CorpID`,PolicyNumber FROM (`policies`) WHERE MATCH(policies.CorpPath) AGAINST('16207') ORDER BY ID desc )as temp GROUP BY CorpID