...
view:
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT CAST(x.objectID AS VARCHAR) objectID, s.MTB_PlaceTermID1 fieldCollectionPlace, COALESCE(x.subsite1, '') + (CASE WHEN x.subsite1 IS NOT NULL AND x.subsite2 IS NOT NULL THEN ', ' ELSE '' END) + COALESCE(x.subsite2, '') + (CASE WHEN x.subsite3 IS NOT NULL THEN ', ' + x.subsite3 ELSE '' END) fieldLocVerbatim FROM SiteObjXrefs x JOIN Objects o ON x.objectID = o.objectID JOIN Sites s ON x.siteID = s.siteID WHERE o.IsVirtual = 0 AND o.IsTemplate = 0 ; |
...