Indre?: Check the list and set localities public in NOW if applicable
Add an item
Activity
Show details
Write a comment…
Kari Lintulaakso Nov 20, 2023 4:00 PM
Made the new query
Reply • Delete
Kari Lintulaakso Apr 4, 2023 1:16 PM
SELECT l.lid, l.loc_name, l.country
FROM now_loc l
LEFT JOIN now_plr lp
ON lp.lid=l.lid
LEFT JOIN now_proj p
ON p.pid=lp.pid
WHERE lp.lid IS NULL AND l.loc_status<>0
ORDER BY l.country, l.loc_name
karilint
commented
2 weeks ago
Edit
Checklist Hide checked itemsDelete 50%
Make the list to Excel
Indre?: Check the list and set localities public in NOW if applicable Add an item Activity Show details Write a comment… Kari Lintulaakso Nov 20, 2023 4:00 PM Made the new query
Edit • Delete indre.zliobaite Nov 20, 2023 3:56 PM new query by KAri and then take it from there
Reply • Delete indre.zliobaite Nov 20, 2023 10:25 AM Asked Otto about Heppenloch
Reply • Delete Kari Lintulaakso Apr 4, 2023 1:16 PM SELECT l.lid, l.loc_name, l.country FROM now_loc l LEFT JOIN now_plr lp ON lp.lid=l.lid LEFT JOIN now_proj p ON p.pid=lp.pid WHERE lp.lid IS NULL AND l.loc_status<>0 ORDER BY l.country, l.loc_name