| | 430 | * CCL: Some warp_id have "update" state on ippmonitor, however they have been processed to be "full" state by checking their data_state in the warpSkyfile table. Their data quality is not equal to 0 which may affect updating the "state". |
| | 431 | {{{ |
| | 432 | select skycell_id,data_state,warp_id,quality,fault from warpSkyfile where warp_id in (1153778,1153779,1339669,1153780,1153781,1154735,1154736,1154793,1210215) group by quality; |
| | 433 | +------------------+------------+---------+---------+-------+ |
| | 434 | | skycell_id | data_state | warp_id | quality | fault | |
| | 435 | +------------------+------------+---------+---------+-------+ |
| | 436 | | skycell.1415.004 | full | 1210215 | 257 | 0 | |
| | 437 | | skycell.1325.094 | full | 1210215 | 3006 | 0 | |
| | 438 | | skycell.2448.080 | full | 1153778 | 8007 | 0 | |
| | 439 | +------------------+------------+---------+---------+-------+ |
| | 440 | 3 rows in set (0.00 sec) |
| | 441 | }}} |
| | 442 | |