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 = 885
						 order by iorder
						
ERROR: column reference "iorder" is ambiguous LINE 16: order by iorder ^

/home/joonbugc/codebases/jb-inc/lib/class/class.reseller.php
Line: 408