Move SEARCH clause before LIMIT/OFFSET

Makes more sense there.  Otherwise it implies you get yourself a window,
then search it.  Which might be easier to implement, but is substantially
less useful.