← 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: