 |
| Browse Adventures |
 |
| Post your Service |
|
| Tell A Friend |
|
| Newsletter |
|
Featured Adventure
Friday Harbor, WA
|
|
| Also Featuring |
|
|
| |
Complete guided flyfishing packages,
British Columbia, CA |
|
|
|
| |
Bus and coach charter in Europe,
Overijssel, NL |
|
|
|
| |
Charter and broker,
Trieste, IT |
|
|
|
| |
Captained sailing charters on the Sea of th...,
Abaco, BS |
|
|
|
| |
A very nice day diving in the Atlantic,
Vizcaya, ES |
|
|
|
| |
4D/4N Similan-Surin Liveaboard trip,
Phuket, TH |
|
 |
|
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
LEFT OUTER JOIN tbltype ON tbltype.type_id=tbllisting_totals.type_id
,tblregion_totals rt
LEFT OUTER JOIN tblcity ON tblcity.city_id=tbllisting_totals.city_id
WHERE tblvirtuallocation.virtloc_id IS NOT NULL
AND tblvirtuallocation.virtloc_type=2
AND tbltype.group_id=2
AND rt.virtloc_id=42 AND rt.city_id=tbllisting_totals.city_id
AND tblvirtuallocation.virtloc_type NOT IN (2)
AND tblcity.prov_id=199
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'
| |
