SELECT *
FROM Review AS t1
LEFT JOIN Account AS t2 ON t1.AccountId = t2.AccountId
WHERE (FirmId=915667 or FirmId=916541 or FirmId=916119 or FirmId=915826 or FirmId=915140 or FirmId=916739 or FirmId=914395 or FirmId=914259 or FirmId=915022 or FirmId=914176 or FirmId=915203 or FirmId=914073 or FirmId=915061 or FirmId=916296 or FirmId=914069 or FirmId=914793 or FirmId=915596 or FirmId=915849 or FirmId=913310 or FirmId=915962) AND t1.AreaId = 42 AND t1.ReviewStatus < 99
ORDER BY 1 DESC;
Big finds from small businesses | 2FINDLOCAL.COM