Unknown column 'cvn_berths' in 'order clause'
SELECT manufacturers.manu_desc, forsale_images.img_id, opt_counties.county_desc, forsale.cvn_county, forsale.ad_id, forsale.ad_price, opt_cvnType.opt_desc, forsale.ad_used, forsale.ad_summary, forsale.model, forsale.manufacturer FROM forsale, opt_counties, opt_cvnType LEFT JOIN forsale_images ON forsale_images.img_default =1 AND forsale_images.img_ad = forsale.ad_id LEFT JOIN manufacturers ON forsale.cvn_make = manufacturers.manu_id WHERE forsale.ad_status = 3 AND opt_counties.county_id = forsale.cvn_county AND opt_cvnType.opt_id = forsale.ad_boattype AND forsale.cvn_make = 1 ORDER BY cvn_berths