← Back to Queries
Points by Project
Basic Query
Get points associated with a specific project
SQL Query
SELECT wp.*
FROM webmap_gdms_points wp
JOIN projects_project_points ppp ON wp.id = ppp.gdms_points_id
JOIN projects_project pp ON ppp.project_id = pp.id
WHERE pp.project_number = '{project_number}'
Run Query
Please provide values for the query parameters: