Your SQL command was:
SELECT TOP 100 objId,z,zErr,absMagR
FROM Photoz
WHERE
z BETWEEN 0.4 and 0.5
and photoErrorClass=1
and nnCount>95
and zErr BETWEEN 0 and 0.03
Your query output (max 500,000 rows):
| objId | z | zErr | absMagR |
| 1237645941296726422 | 0.445112 | 0.02755 | -22.7976 |
| 1237645941296791969 | 0.405367 | 0.029364 | -22.7643 |
| 1237645941296792003 | 0.489535 | 0.024078 | -22.3782 |
| 1237645941296857666 | 0.45089 | 0.012513 | -23.7765 |
| 1237645941296923157 | 0.462941 | 0.022273 | -22.6565 |
| 1237645941296923178 | 0.453665 | 0.016571 | -23.278 |
| 1237645941296923189 | 0.421728 | 0.020012 | -23.2048 |
| 1237645941296923191 | 0.473874 | 0.026352 | -22.9606 |
| 1237645941297447290 | 0.424762 | 0.028821 | -22.4897 |
| 1237645941297512874 | 0.461962 | 0.029232 | -22.4112 |
| 1237645941297513046 | 0.455947 | 0.024251 | -22.3649 |
| 1237645941297578339 | 0.475412 | 0.022939 | -22.81 |
| 1237645941297578412 | 0.463604 | 0.021522 | -23.1558 |
| 1237645941297578715 | 0.471745 | 0.028561 | -22.1668 |
| 1237645941298430677 | 0.456562 | 0.025284 | -22.1323 |
| 1237645941298692771 | 0.404443 | 0.02928 | -22.5941 |
| 1237645941299020322 | 0.449323 | 0.025736 | -22.023 |
| 1237645941299020329 | 0.454207 | 0.023848 | -22.9293 |
| 1237645941299020375 | 0.404274 | 0.027492 | -22.1191 |
| 1237645941299020401 | 0.440327 | 0.028492 | -23.0799 |
| 1237645941299020451 | 0.418816 | 0.021674 | -23.165 |
| 1237645941299020479 | 0.450034 | 0.028448 | -22.0763 |
| 1237645941299020661 | 0.433355 | 0.026718 | -21.5873 |
| 1237645941299020734 | 0.442273 | 0.026355 | -21.5206 |
| 1237645941299085371 | 0.497972 | 0.028139 | -21.6447 |
| 1237645941299085862 | 0.43832 | 0.027591 | -23.0041 |
| 1237645941299085983 | 0.451339 | 0.02661 | -22.0494 |
| 1237645941299086035 | 0.429058 | 0.024091 | -22.1589 |
| 1237645941833269949 | 0.412602 | 0.025779 | -22.879 |
| 1237645941833400942 | 0.442873 | 0.021188 | -22.6567 |
| 1237645941833859523 | 0.460104 | 0.025637 | -23.0394 |
| 1237645941833924687 | 0.400256 | 0.029798 | -22.7213 |
| 1237645941834187328 | 0.427888 | 0.026218 | -22.9151 |
| 1237645941834252567 | 0.410631 | 0.025606 | -22.2308 |
| 1237645941834318130 | 0.456901 | 0.029419 | -21.6973 |
| 1237645941834383743 | 0.417845 | 0.028416 | -21.8842 |
| 1237645941834842854 | 0.45616 | 0.027156 | -22.052 |
| 1237645941834842960 | 0.453394 | 0.026875 | -21.7114 |
| 1237645941835170510 | 0.499357 | 0.029591 | -22.3746 |
| 1237645941835235916 | 0.483482 | 0.016183 | -23.2788 |
| 1237645941835301200 | 0.426186 | 0.018746 | -23.4639 |
| 1237645941835301407 | 0.451291 | 0.027926 | -21.8731 |
| 1237645941835301553 | 0.451009 | 0.026737 | -22.2288 |
| 1237645941835301613 | 0.494759 | 0.024641 | -22.517 |
| 1237645941835367111 | 0.494585 | 0.027651 | -22.5362 |
| 1237645941835563636 | 0.488223 | 0.029987 | -21.4673 |
| 1237645941835628618 | 0.45612 | 0.026878 | -22.3933 |
| 1237645941835759900 | 0.450489 | 0.029843 | -22.3497 |
| 1237645941835760032 | 0.431342 | 0.022778 | -23.3974 |
| 1237645941835760167 | 0.46165 | 0.020326 | -23.0922 |
| 1237645941835825848 | 0.450085 | 0.023568 | -22.4968 |
| 1237645941835826099 | 0.418934 | 0.024465 | -22.2694 |
| 1237645941835956352 | 0.400142 | 0.029457 | -22.4528 |
| 1237645941835956783 | 0.488182 | 0.020712 | -22.9897 |
| 1237645942370271726 | 0.425722 | 0.027667 | -23.0305 |
| 1237645942370337263 | 0.491708 | 0.029144 | -22.7888 |
| 1237645942370468551 | 0.454127 | 0.029289 | -22.1128 |
| 1237645942370730463 | 0.452413 | 0.019899 | -22.9343 |
| 1237645942370861525 | 0.430792 | 0.021821 | -22.6362 |
| 1237645942370926968 | 0.432056 | 0.01688 | -23.4534 |
| 1237645942370927238 | 0.452856 | 0.016751 | -23.0958 |
| 1237645942370927276 | 0.451987 | 0.028239 | -22.2933 |
| 1237645942370927393 | 0.424588 | 0.02609 | -22.2491 |
| 1237645942370992376 | 0.413781 | 0.027142 | -23.3356 |
| 1237645942370992518 | 0.411789 | 0.028185 | -22.61 |
| 1237645942370992707 | 0.44778 | 0.0259 | -22.6757 |
| 1237645942370992911 | 0.476844 | 0.019573 | -23.0692 |
| 1237645942371123295 | 0.470496 | 0.025394 | -22.68 |
| 1237645942371254672 | 0.427698 | 0.028649 | -22.6948 |
| 1237645942371254734 | 0.423657 | 0.023858 | -21.7099 |
| 1237645942371517092 | 0.456282 | 0.025014 | -22.6274 |
| 1237645942371582692 | 0.475133 | 0.029015 | -21.9205 |
| 1237645942371648110 | 0.467947 | 0.024825 | -22.7613 |
| 1237645942371713648 | 0.446084 | 0.019681 | -23.1042 |
| 1237645942371844762 | 0.488094 | 0.026367 | -22.6529 |
| 1237645942371910179 | 0.400708 | 0.026606 | -22.1498 |
| 1237645942372106810 | 0.463124 | 0.025248 | -22.3343 |
| 1237645942372107081 | 0.455254 | 0.022353 | -22.371 |
| 1237645942372107123 | 0.429627 | 0.029529 | -22.2952 |
| 1237645942372172318 | 0.451269 | 0.027464 | -22.4586 |
| 1237645942372172400 | 0.43974 | 0.025787 | -22.3539 |
| 1237645942372303600 | 0.405549 | 0.027425 | -22.2177 |
| 1237645942372369274 | 0.422407 | 0.024956 | -22.2629 |
| 1237645942372369323 | 0.457645 | 0.02399 | -22.6856 |
| 1237645942372499784 | 0.417559 | 0.02424 | -22.4035 |
| 1237645942372565346 | 0.497068 | 0.019186 | -23.2015 |
| 1237645942372565400 | 0.496536 | 0.02266 | -23.2612 |
| 1237645942372565675 | 0.493186 | 0.026641 | -21.9656 |
| 1237645942372631080 | 0.493359 | 0.026388 | -22.2813 |
| 1237645942372761692 | 0.465567 | 0.019799 | -23.0814 |
| 1237645942372762148 | 0.492265 | 0.024423 | -22.6302 |
| 1237645942372762237 | 0.441641 | 0.02742 | -22.0234 |
| 1237645942372762316 | 0.464525 | 0.029029 | -22.3812 |
| 1237645942372827724 | 0.475221 | 0.023114 | -22.6867 |
| 1237645942372828085 | 0.457302 | 0.02488 | -22.023 |
| 1237645942905111113 | 0.403725 | 0.029456 | -21.9584 |
| 1237645942905504557 | 0.449017 | 0.021844 | -22.5447 |
| 1237645942905635390 | 0.48398 | 0.022116 | -22.8407 |
| 1237645942905635444 | 0.475409 | 0.029698 | -22.6738 |
| 1237645942905701086 | 0.486929 | 0.019049 | -22.795 |