[Haimz]

WHERE (POST.view >= 4 AND POST.view <= 8)

עוד דרך אם תרצה..