No visit to United States, North America is complete without Hot Air Balloon Flights.
Top Footer

Look for in  Go
Service ID # Go
Search site Go
  Browse Adventures
  Post your Service
  Tell A Friend
Featured Adventure

Friday Harbor, WA Friday Harbor, WA
  Also Featuring
  Ymir Yurts - Backcountry Resort,
British Columbia, CA
  Taveuni's Finest Diving,
Taveuni, FJ


SELECT DISTINCT tblvirtuallocation.virtloc_id,tblvirtuallocation.virtloc_desc,'r-'||tblvirtuallocation.virtloc_key,COUNT(DISTINCT list_id) AS item_count FROM tblvirtuallocation LEFT OUTER JOIN tblregion_totals ON tblregion_totals.virtloc_id=tblvirtuallocation.virtloc_id LEFT OUTER JOIN tbllisting_totals ON tbllisting_totals.city_id=tblregion_totals.city_id ,tblregion_totals rt LEFT OUTER JOIN tblcity ON tblcity.city_id=tbllisting_totals.city_id LEFT OUTER JOIN tblprovince ON tblprovince.prov_id=tblcity.prov_id WHERE tblvirtuallocation.virtloc_id IS NOT NULL AND tblvirtuallocation.virtloc_type=1 AND tbllisting_totals.type_id=53 AND rt.virtloc_id=163 AND rt.city_id=tbllisting_totals.city_id AND tblvirtuallocation.virtloc_type NOT IN (0) AND tblprovince.country_id=371 GROUP BY tblvirtuallocation.virtloc_id,virtloc_desc,tblvirtuallocation.virtloc_key HAVING item_count>0 ORDER BY tblvirtuallocation.virtloc_desc
Unknown column 'tbllisting_totals.city_id' in 'on clause'