Your SQL command was:
SELECT TOP 10 objid,ra,dec,
flags,
flags & 0x00000000FFFFFFFF AS flags_lo,
(flags/power(cast(2 as bigint),32)) & 0x00000000FFFFFFFF AS flags_hi
FROM PhotoObj
Your query output (max 500,000 rows):
objid | ra | dec | flags | flags_lo | flags_hi |
1237651758284999323 | 269.998611639511 | 0.00196215120961481 | 72092847398060048 | 268566544 | 16785424 |
1237651758284999326 | 269.997628832911 | 0.000513699107726668 | 246359626220304 | 302121744 | 57360 |
1237651758284999348 | 270.00269749521 | -0.000544961535222983 | 105622137868560 | 302125328 | 24592 |
1237651758284999319 | 270.00047971351 | 0.00299723797180513 | 105622104313872 | 268570640 | 24592 |
1237651758284999325 | 270.00223779521 | 0.00303442912755565 | 105622137868304 | 302125072 | 24592 |
1237651758284999317 | 270.000683847452 | 0.00379184374335808 | 35253360136208 | 268570640 | 8208 |
1237651758284999318 | 269.999838605169 | 0.0038632223882232 | 246359592669200 | 268570640 | 57360 |
1237651758285000990 | 270.004056338972 | 0.00157517842728232 | 35253360136208 | 268570640 | 8208 |
1237651758285001724 | 269.995417357341 | -0.000116548601276815 | 35253360136464 | 268570896 | 8208 |
1237651758284996827 | 269.996605674249 | 0.00319832570589696 | 35253394210836 | 302645268 | 8208 |