SELECT * 
FROM (
	SELECT 	*,			
			GeomFromText(CONCAT('Point(', e.geo_latitude,' ',e.geo_longitude,')')) as _point			
	FROM events e
	WHERE e.eventdate 	>= NOW()
	AND e.city 			= 'vancouver'
    AND e.seasonal 		= 'halloween-parties'
) as points
WHERE MBRContains(GeomFromText( 'LINESTRING(49.28090714399665 -123.04745683323608,49.28930518918205 -123.02033433567749)' ), points._point)