select exp_name, exp_id, filter, warp_id, skycell_id, warpSkyfile.data_state, warpRun.state from rawExp join chipRun using (exp_id) join camRun using (chip_id) join fakeRun using (cam_id) join warpRun using (fake_id) join warpSkyfile using (warp_id) where skycell_id = 'skycell.2528.062' and warpRun.state = 'full' limit 10;

select count(exp_name), exp_id, filter, warp_id, skycell_id, warpSkyfile.data_state, warpRun.state from rawExp join chipRun using (exp_id) join camRun using (chip_id) join fakeRun using (cam_id) join warpRun using (fake_id) join warpSkyfile using (warp_id) where skycell_id = 'skycell.2528.062' and warpRun.state = 'full' group by filter limit 10

