SELECT sl.plate, sl.mjd, sl.fiber, sl.caIIKside, sl.caIIKerr, sl.caIIKmask, sp.fehadop, sp.fehadopunc,sp. fehadopn, sp.loggadopn,sp.loggadopunc,sp.loggadopn FROM sppLines AS sl JOIN sppParams AS sp ON sl.specobjid = sp.specobjid WHERE fehadop < -3.5 and fehadopunc between 0.01 and 0.5 AND fehadopn > 3
plate | mjd | fiber | caIIKside | caIIKerr | caIIKmask | fehadop | fehadopunc | fehadopn | loggadopn | loggadopunc | loggadopn1 |
2930 | 54589 | 335 | 0.1478793 | 0.2574305 | 0 | -3.832871 | 0.06838486 | 4 | 5 | 0.2423447 | 5 |
3265 | 54888 | 350 | 1.088 | 0.06333922 | 0 | -3.602165 | 0.03522713 | 5 | 6 | 0.2440181 | 6 |
2262 | 54623 | 334 | -9.999 | 0.230401 | 0 | -3.625541 | 0.08666927 | 4 | 5 | 0.2297168 | 5 |
3299 | 54908 | 450 | 4.640576 | 0.0649229 | 0 | -3.553842 | 0.03398461 | 5 | 4 | 0.02684962 | 4 |
3181 | 54860 | 630 | 0.7979765 | 0.06624398 | 0 | -3.631505 | 0.04079498 | 7 | 6 | 0.2281814 | 6 |
3122 | 54821 | 178 | 1.917892 | 0.05481836 | 0 | -3.556408 | 0.02727899 | 7 | 6 | 0.2657218 | 6 |
3254 | 54889 | 128 | 1.336215 | 0.07845661 | 0 | -3.593108 | 0.03757932 | 5 | 6 | 0.2541091 | 6 |
2321 | 53711 | 190 | -9.999 | 0.301508 | 0 | -3.750861 | 0.1632173 | 4 | 4 | 0.9459512 | 4 |
3442 | 54983 | 35 | 2.56373 | 0.2590337 | 0 | -3.711685 | 0.2039867 | 4 | 6 | 0.4577165 | 6 |
3264 | 54889 | 214 | 2.98131 | 0.1592093 | 0 | -3.581616 | 0.05977587 | 6 | 5 | 0.1758396 | 5 |
2459 | 54544 | 256 | 0.9350176 | 0.08154837 | 0 | -3.554706 | 0.07415039 | 4 | 7 | 0.1259029 | 7 |
3180 | 54864 | 372 | 1.231993 | 0.06736501 | 0 | -3.738537 | 0.04079748 | 5 | 6 | 0.1333738 | 6 |
2671 | 54141 | 550 | 1.019466 | 0.1070848 | 0 | -3.683392 | 0.1448392 | 4 | 5 | 0.3043036 | 5 |
3315 | 54942 | 237 | -9.999 | 0.1790333 | 0 | -3.569333 | 0.0300268 | 4 | 6 | 0.1723865 | 6 |
2067 | 53738 | 487 | 0.5340912 | 0.2289565 | 0 | -3.568617 | 0.06510814 | 4 | 6 | 0.2264389 | 6 |
2796 | 54629 | 130 | -9.999 | 0.1178063 | 0 | -3.583849 | 0.05460227 | 4 | 6 | 0.1160542 | 6 |
2909 | 54653 | 315 | -9.999 | 0.1674375 | 0 | -3.604384 | 0.06417073 | 4 | 7 | 0.3532765 | 7 |
2459 | 54544 | 183 | 1.87133 | 0.09404058 | 0 | -3.523347 | 0.02242343 | 5 | 6 | 0.2094551 | 6 |
2441 | 54065 | 455 | 0.5674407 | 0.144692 | 0 | -3.504206 | 0.05553429 | 6 | 6 | 0.3915117 | 6 |
2320 | 54653 | 164 | 5.999146 | 0.4678125 | 0 | -3.717512 | 0.09211646 | 5 | 4 | 0.8348178 | 4 |
3319 | 54915 | 230 | 3.3571 | 0.07257752 | 0 | -3.552255 | 0.04132742 | 5 | 5 | 0.256565 | 5 |
2079 | 53379 | 577 | 1.93194 | 0.1377528 | 0 | -3.512997 | 0.09054739 | 5 | 6 | 0.4072194 | 6 |