SELECT *
FROM Review AS t1
LEFT JOIN Account AS t2 ON t1.AccountId = t2.AccountId
WHERE (FirmId=4212879 or FirmId=4210829 or FirmId=4212716 or FirmId=4212556 or FirmId=4212948 or FirmId=4212155 or FirmId=4212154 or FirmId=4211368 or FirmId=4212824 or FirmId=4211672 or FirmId=4211473 or FirmId=4213219 or FirmId=4212199 or FirmId=4213315 or FirmId=4210954 or FirmId=4212729 or FirmId=4212817 or FirmId=4212976 or FirmId=4212071 or FirmId=4211207) AND t1.AreaId = 55 AND t1.ReviewStatus < 99
ORDER BY 1 DESC;
Big finds from small businesses | 2FINDLOCAL.COM