select  	ct_barcrawl_venue.id as ct_barcrawl_venue_id,
	ct_barcrawl_venue.is_registration_point,
	venue.id as venue_id,
	venue.name as venue_name,
	venue.address1,
	venue.city,
	venue.state,
	venue.zip,
	venue.latitude,
	venue.longitude,
	venue.geoprecision
from ct_barcrawl_venue
 LEFT JOIN venue on ct_barcrawl_venue.venue_id = venue.id AND venue.active = 1 
 
where ct_barcrawl_venue.active = 1  and ct_barcrawl_id = 
						 order by iorder
						
ERROR:  syntax error at or near "order"
LINE 16:        order by iorder
                ^