SELECT *
FROM Review AS t1
LEFT JOIN Account AS t2 ON t1.AccountId = t2.AccountId
WHERE (FirmId=428940 or FirmId=414286 or FirmId=431471 or FirmId=414552 or FirmId=431465 or FirmId=414520 or FirmId=380382 or FirmId=427877 or FirmId=414613 or FirmId=427803 or FirmId=431516 or FirmId=426856 or FirmId=431608 or FirmId=429967 or FirmId=428360 or FirmId=431177 or FirmId=430724 or FirmId=430921 or FirmId=430420 or FirmId=388656) AND t1.AreaId = 54 AND t1.ReviewStatus < 99
ORDER BY 1 DESC;
Big finds from small businesses | 2FINDLOCAL.COM