Search child Event Frames

SELECT c.Name as ChildEventFrameName,c.Description, c.StartTime,c.EndTime
FROM (Eventframe.EventFrame c
INNER JOIN EventFrame.EventFrameReference efr
ON efr.ChildEventFrameID=c.ID)
INNER JOIN Eventframe.EventFrame p
ON efr.ParentEventFrameID=p.ID
WHERE p.name='2700'
AND c.StartTime BETWEEN '25-may-2012' AND '30-may-2012';

Returns all child event frames having a parent with a specific name.