Search Event Frame by category

SELECT ef.name, ef.Starttime, ef.endTime
FROM eventframe.eventframe ef
INNER JOIN eventframe.eventframecategory efc
ON ef.id=efc.EventframeID
INNER JOIN asset.category ac
ON efc.CategoryID=ac.ID
WHERE ac.name='OSIBatch'and ef.starttime
BETWEEN '5-jun-2012' AND '8-jun-2012'
ORDER BY ef.ID

Returns all event frames of a specific category.