SELECT aerodrome_id
    FROM
      geo_aerodromecustom_view,
      (SELECT ST_Buffer(
          ST_Transform(
              (SELECT ST_MakeLine(geom)
              FROM
                  (SELECT geom
                  FROM geo_aerodromecustom_view
                  WHERE aerodrome_id IN ('CYOW','CYVR')
                  ORDER BY CASE aerodrome_id WHEN 'CYOW' THEN 1 WHEN 'CYVR' THEN 2 ELSE 5 END
                  ) sites
              ),
              900913
          ),
          50000) as geo
      ) as line
    WHERE ST_Intersects(ST_Transform(geom, 900913), line.geo)
    ORDER BY ST_Line_Locate_Point(
      ST_Transform(
          (SELECT ST_MakeLine(geom)
           FROM
              (SELECT geom
               FROM geo_aerodromecustom_view
               WHERE aerodrome_id IN ('CYOW','CYVR')
               ORDER BY CASE aerodrome_id WHEN 'CYOW' THEN 1 WHEN 'CYVR' THEN 2 ELSE 5 END
              ) sites
          ),
          900913
      ),
      ST_Transform(geom, 900913)
    )

Select    points.pointID
from      points,
          rountes
where     rountes.routeID = :routeid
  and     ST_Intersects(points.pointShape, ST_Buffer(route.rounteShape, 50000))
order by  ST_LineLocatePoint(route.rounteShape, points.pointShape);