 |
Browse Adventures |
 |
Post your Service |
 |
Tell A Friend |
 |
Newsletter |
 |
Featured Adventure
Friday Harbor, WA
|
 |
Also Featuring |
 |
 |
|
Fishing on Lake Michigan for salmon and tro...,
Illinois, US |
 |
 |
 |
|
Scuba Diving,
French Polynesia, PF |
 |
 |
 |
|
Salmon fishing on Lake Michigan on a 39' bo...,
Illinois, US |
 |
 |
 |
|
Flyfishing for Northern Pike,
Alaska, US |
 |
 |
 |
|
Bus and coach charter in Europe,
Overijssel, NL |
 |
 |
|
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 rt.virtloc_id=37 AND rt.city_id=tbllisting_totals.city_id
AND tblvirtuallocation.virtloc_type NOT IN (1)
AND tblprovince.country_id=223
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' | |