requete localisation des photos de sysma dans qgis -> un nouvel objet sysma ?

`

SELECT a.*, c.sysma_object_type,'https://sevre-niortaise.sysma.io/upload/'|| photo_file ||'_thumbnail.jpg' as url_photo,
st_centroid(b.geom)::geometry(point,2154) as geom

FROM sysma.photo_object a

LEFT JOIN sysma.sysma_object b on a.sysma_object_id = b.sysma_object_id

LEFT JOIN sysma.sysma_object_type c on b.sysma_object_type_id = c.sysma_object_type_id

`