Database Query Error (dbQuery2)

Error: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'UID'.

Query: SELECT TOP UID, Uname, DisplayLevelID, LevelID, Logo, Company, Option1, Option2, Option3, Option4, Option5, Option6, Option7, Option8, Option9, Option10, WebPage, cEmail, cPhone FROM qUsersAndCat WHERE (SiteID='9') AND (Active=1) AND (UID NOT IN (SELECT TOP UID FROM qUsersAndCat WHERE SiteID='9' AND (Active=1) GROUP BY UID, DisplayLevelID, LevelID, Company ORDER BY DisplayLevelID DESC, Company)) GROUP BY UID, DisplayLevelID, LevelID, Uname, Logo, Company, Option1, Option2, Option3, Option4,

File: /search.php

Called from:

• exhibitorregistration.php line 2560
• search.php line 222