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

PlanetCharters.com
Top Footer

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

Friday Harbor, WA Friday Harbor, WA
  Also Featuring
  Private Island with Dive Resort,
Papua New Guinea, PG
  ATLANTIC CANADA SAFARIS. Hike, Walk, Scenic...,
Nova Scotia, CA
  Fishing Charters,
Florida, US
  Van & Coach Charter of Atlantic Canada,
Nova Scotia, CA
---

 

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'