| | 126 | |
| | 127 | {{{ |
| | 128 | mysql> select filter, skycell_id, count(*), min(fwhm_major), max(fwhm_major) from warpRun join warpSkyfile using (warp_id) join fakeRun using (fake_id) join camRun using (cam_id) join camProcessedExp using (cam_id) join chipRun using (chip_id) join rawExp using (exp_id) where camRun.label = 'SAS.v0' and sigma_ra < 1 and n_astrom > 0 and fwhm_major < 5 and warpSkyfile.quality = 0 group by filter, skycell_id; |
| | 129 | +--------+--------------+----------+-----------------+-----------------+ |
| | 130 | | filter | skycell_id | count(*) | min(fwhm_major) | max(fwhm_major) | |
| | 131 | +--------+--------------+----------+-----------------+-----------------+ |
| | 132 | | g | skycell.1314 | 1 | 3.59727 | 3.59727 | |
| | 133 | | g | skycell.1315 | 2 | 3.6018 | 3.6311 | |
| | 134 | | g | skycell.1316 | 2 | 3.6018 | 3.6311 | |
| | 135 | | g | skycell.1404 | 2 | 3.59727 | 3.60911 | |
| | 136 | | g | skycell.1405 | 4 | 3.59727 | 3.6311 | |
| | 137 | | g | skycell.1406 | 3 | 3.6018 | 3.6382 | |
| | 138 | | g | skycell.1407 | 1 | 3.6382 | 3.6382 | |
| | 139 | | g | skycell.1494 | 1 | 3.60911 | 3.60911 | |
| | 140 | | g | skycell.1495 | 1 | 3.6382 | 3.6382 | |
| | 141 | | g | skycell.1496 | 1 | 3.6382 | 3.6382 | |
| | 142 | | i | skycell.1314 | 2 | 1.63937 | 1.66888 | |
| | 143 | | i | skycell.1315 | 1 | 1.66888 | 1.66888 | |
| | 144 | | i | skycell.1404 | 4 | 1.63937 | 2.42179 | |
| | 145 | | i | skycell.1405 | 4 | 1.63937 | 1.67396 | |
| | 146 | | i | skycell.1406 | 3 | 1.64807 | 1.67396 | |
| | 147 | | i | skycell.1407 | 1 | 1.64807 | 1.64807 | |
| | 148 | | i | skycell.1493 | 4 | 1.76622 | 2.42179 | |
| | 149 | | i | skycell.1494 | 4 | 1.67151 | 2.42179 | |
| | 150 | | i | skycell.1495 | 3 | 1.64807 | 1.67396 | |
| | 151 | | i | skycell.1582 | 1 | 1.81341 | 1.81341 | |
| | 152 | | r | skycell.1314 | 2 | 1.80198 | 1.94848 | |
| | 153 | | r | skycell.1315 | 1 | 1.94848 | 1.94848 | |
| | 154 | | r | skycell.1404 | 4 | 1.80198 | 3.14089 | |
| | 155 | | r | skycell.1405 | 4 | 1.80198 | 3.14089 | |
| | 156 | | r | skycell.1406 | 3 | 1.91914 | 1.98396 | |
| | 157 | | r | skycell.1407 | 1 | 1.91914 | 1.91914 | |
| | 158 | | r | skycell.1493 | 4 | 1.85289 | 3.14089 | |
| | 159 | | r | skycell.1494 | 4 | 1.85289 | 3.14089 | |
| | 160 | | r | skycell.1495 | 3 | 1.91914 | 1.98396 | |
| | 161 | | r | skycell.1496 | 2 | 1.91914 | 1.98396 | |
| | 162 | | z | skycell.1493 | 1 | 1.6754 | 1.6754 | |
| | 163 | +--------+--------------+----------+-----------------+-----------------+ |
| | 164 | 31 rows in set (0.00 sec) |
| | 165 | |
| | 166 | }}} |
| | 167 | |
| | 168 | of course, it helps if we've processed more than a handful of stuff.... ugh... need to wait now... |