SELECT initcap(gu.first_name)||' '||initcap(gu.last_name), op.country, TRIM(BOTH ' ' FROM op.street||' '||op.street_nr||' '||op.location||' '||op.post_code||' '||op.country),
opc.name "Category Name", w.ref_number, w.name "WBS Name"
FROM oc_poi op, gui_users gu, oc_poi_category opc, wbs w
WHERE UPPER(op.country) LIKE 'BE'
AND opc.oc_poi_category_id=op.oc_poi_category_id
AND op.poi_id=gu.poi_id
AND op.poi_id=w.poi_id(+);