All pastes #676793 Raw Edit

Anonymous

public sql v1 · immutable
#676793 ·published 2007-08-31 12:26 UTC
rendered paste body
SELECT   	((laboratory &       0x3f)      ) +			((laboratory &      0xfc0) >>  6) +			((laboratory &    0x3f000) >> 12) +			((laboratory &   0xfc0000) >> 18) +			((laboratory & 0x3f000000) >> 24) +						((storehouse &       0x3f)      ) +			((storehouse &      0xfc0) >>  6) +			((storehouse &    0x3f000) >> 12) +			((storehouse &   0xfc0000) >> 18) +			((storehouse & 0x3f000000) >> 24) +						((spaceship_yard &       0x3f)      ) +			((spaceship_yard &      0xfc0) >>  6) +			((spaceship_yard &    0x3f000) >> 12) +			((spaceship_yard &   0xfc0000) >> 18) +			((spaceship_yard & 0x3f000000) >> 24) +						((defensive_deck &       0x3f)      ) +			((defensive_deck &      0xfc0) >>  6) +			((defensive_deck &    0x3f000) >> 12) +			((defensive_deck &   0xfc0000) >> 18) +			((defensive_deck & 0x3f000000) >> 24) +						((exploitation0 &       0x3f)      ) +			((exploitation0 &      0xfc0) >>  6) +			((exploitation0 &    0x3f000) >> 12) +			((exploitation0 &   0xfc0000) >> 18) +			((exploitation0 & 0x3f000000) >> 24) +						((exploitation1 &       0x3f)      ) +			((exploitation1 &      0xfc0) >>  6) +			((exploitation1 &    0x3f000) >> 12) +			((exploitation1 &   0xfc0000) >> 18) +			((exploitation1 & 0x3f000000) >> 24) +						((exploitation2 &       0x3f)      ) +			((exploitation2 &      0xfc0) >>  6) +			((exploitation2 &    0x3f000) >> 12) +			((exploitation2 &   0xfc0000) >> 18) +			((exploitation2 & 0x3f000000) >> 24) +						((exploitation3 &       0x3f)      ) +			((exploitation3 &      0xfc0) >>  6) +			((exploitation3 &    0x3f000) >> 12) +			((exploitation3 &   0xfc0000) >> 18) +			((exploitation3 & 0x3f000000) >> 24) +						((exploitation4 &       0x3f)      ) +			((exploitation4 &      0xfc0) >>  6) +			((exploitation4 &    0x3f000) >> 12) +			((exploitation4 &   0xfc0000) >> 18) +			((exploitation4 & 0x3f000000) >> 24) +						((exploitation5 &       0x3f)      ) +			((exploitation5 &      0xfc0) >>  6) +			((exploitation5 &    0x3f000) >> 12) +			((exploitation5 &   0xfc0000) >> 18) +			((exploitation5 & 0x3f000000) >> 24) +						((exploitation6 &       0x3f)      ) +			((exploitation6 &      0xfc0) >>  6) +			((exploitation6 &    0x3f000) >> 12) +			((exploitation6 &   0xfc0000) >> 18) +			((exploitation6 & 0x3f000000) >> 24) +						((exploitation7 &       0x3f)      ) +			((exploitation7 &      0xfc0) >>  6) +			((exploitation7 &    0x3f000) >> 12) +			((exploitation7 &   0xfc0000) >> 18) +			((exploitation7 & 0x3f000000) >> 24) +						((research_center &       0x3f)      ) +			((research_center &      0xfc0) >>  6) +			((research_center &    0x3f000) >> 12) +			((research_center &   0xfc0000) >> 18) +			((research_center & 0x3f000000) >> 24) +						((factory &       0x3f)      ) +			((factory &      0xfc0) >>  6) +			((factory &    0x3f000) >> 12) +			((factory &   0xfc0000) >> 18) +			((factory & 0x3f000000) >> 24) +						((refinery &       0x3f)      ) +			((refinery &      0xfc0) >>  6) +			((refinery &    0x3f000) >> 12) +			((refinery &   0xfc0000) >> 18) +			((refinery & 0x3f000000) >> 24) AS calc_built, builtFROM fg_systemHAVING calc_built != built;