-- pixel path
SELECT X, Y, RoiId, * from device_person_pixel_data
where CameraSerial in('ac234750485cb074') ORDER BY LocalDateTime ASC;
 
 
 
select * from spermbankraw_data_original sdo where CameraSerial = 'ac234750485cb074'
order by `LocalTime`desc;
 
 
SELECT dppd.*
FROM rccp.dbo.FFCameras c
JOIN rccp.dbo.SiteFloorplanDetails sfd
    ON sfd.BranchId = c.BranchId
JOIN device_person_pixel_data dppd
    ON dppd.FloorPlanId = sfd.Id
WHERE c.Serial = 'ac234750485cb074'
ORDER BY dppd.LocalDateTime DESC;
 
select * from rccp.dbo.DevicePlots where FloorPlanId = 1783;
 
 
SELECT * FROM device_person_pixel_data dppd
WHERE CameraSerial = 'ac234750485cb074' ORDER BY LocalDateTime DESC;