SELECT *
FROM Review AS t1
LEFT JOIN Account AS t2 ON t1.AccountId = t2.AccountId
WHERE (FirmId=4263692 or FirmId=4157469 or FirmId=4248531 or FirmId=4248555) AND t1.AreaId = 55 AND t1.ReviewStatus < 99
ORDER BY 1 DESC;
Big finds from small businesses | 2FINDLOCAL.COM