KNN GIST query

gistfile1.sql

select 
  parcel_id,
  address,
  st_distance(geom,'SRID=3005;POINT(1011102 450541)') as distance 
from 
  parcels
where 
  geom && (
           select 
             st_extent(geom) 
           from 
             parcels 
           order by geom <#> 'SRID=3005;POINT(1011102 450541)' 
           limit 10
           )
order by  st_distance(geom,'SRID=3005;POINT(1011102 450541)') limit 10