It was the Bitcointalk forum that inspired us to create Bitcointalksearch.org - Bitcointalk is an excellent site that should be the default page for anybody dealing in cryptocurrency, since it is a virtual gold-mine of data. However, our experience and user feedback led us create our site; Bitcointalk's search is slow, and difficult to get the results you need, because you need to log in first to find anything useful - furthermore, there are rate limiters for their search functionality.
The aim of our project is to create a faster website that yields more results and faster without having to create an account and eliminate the need to log in - your personal data, therefore, will never be in jeopardy since we are not asking for any of your data and you don't need to provide them to use our site with all of its capabilities.
We created this website with the sole purpose of users being able to search quickly and efficiently in the field of cryptocurrency so they will have access to the latest and most accurate information and thereby assisting the crypto-community at large.
is_stake_block undefined, is_stake_chain = True, b = {'chain_candidates': [{'chain':, 'in_longest': Decimal('1')}], 'chain_satoshi_seconds': 2517292340726300000000L, 'chain_satoshis': 3342705000000000, 'chain_work': 13618916087790469, 'fees': 57000, 'generated': 5000000000, 'hash': '00000000001930548377e3e15c927d8d79278cb8ba53b1d015468609e3085b13', 'hashMerkleRoot': '36f8065b8c6c95b37c426fbf95bb0bcf98dc04817de8257ffd624d8311cb2603', 'hashPrev': '000000000141a8721757560bb837c6d7be9aa85cf5333bfeaff2602c9d9a1d7a', 'height': Decimal('12441'), ...} : 'is_proof_of_stake'
args = ('is_proof_of_stake',)
message = 'is_proof_of_stake'
is_stake_block undefined, is_stake_chain = True, b = {'chain_candidates': [{'chain':, 'in_longest': Decimal('1')}], 'chain_satoshi_seconds': 2517292340726300000000L, 'chain_satoshis': 3342705000000000, 'chain_work': 13618916087790469, 'fees': 57000, 'generated': 5000000000, 'hash': '00000000001930548377e3e15c927d8d79278cb8ba53b1d015468609e3085b13', 'hashMerkleRoot': '36f8065b8c6c95b37c426fbf95bb0bcf98dc04817de8257ffd624d8311cb2603', 'hashPrev': '000000000141a8721757560bb837c6d7be9aa85cf5333bfeaff2602c9d9a1d7a', 'height': Decimal('12441'), ...} : 'is_proof_of_stake'
args = ('is_proof_of_stake',)
message = 'is_proof_of_stake'
ServerName mydomain.com
Alias /static/ /home/ultra/abe-utc/Abe/htdocs
Alias /robots.txt /home/ultra/abe-utc/Abe/htdocs/robots.txt
Alias /favicon.ico /home/ultra/abe-utc/Abe/htdocs/favicon.ico
Alias / /usr/lib/cgi-bin/abe.fcgi/
# FcgidIOTimeout 40
ServerName mydomain.com
Alias /static/ /home/ultra/abe-utc/Abe/htdocs
Alias /robots.txt /home/ultra/abe-utc/Abe/htdocs/robots.txt
Alias /favicon.ico /home/ultra/abe-utc/Abe/htdocs/favicon.ico
Alias / /usr/lib/cgi-bin/abe.fcgi/
# FcgidIOTimeout 40
sh-4.2$ python -m Abe.abe --config /home/ultra/abe-utc/abe.conf --static-path /static/
block_tx 322139 763931
commit
block_tx 322140 763932
commit
block_tx 322141 763933
commit
block_tx 322142 763934
commit
block_tx 322143 763935
commit
block_tx 322144 763936
block_tx 322144 763930
commit
Abe initialized.
Traceback (most recent call last):
File "/usr/lib/python2.7/runpy.py", line 162, in _run_module_as_main
"__main__", fname, loader, pkg_name)
File "/usr/lib/python2.7/runpy.py", line 72, in _run_code
exec code in run_globals
File "/usr/local/lib/python2.7/dist-packages/Abe/abe.py", line 2279, in
sys.exit(main(sys.argv[1:]))
File "/usr/local/lib/python2.7/dist-packages/Abe/abe.py", line 2275, in main
serve(store)
File "/usr/local/lib/python2.7/dist-packages/Abe/abe.py", line 2151, in serve
httpd = make_server(args.host, port, abe)
File "/usr/lib/python2.7/wsgiref/simple_server.py", line 144, in make_server
server = server_class((host, port), handler_class)
File "/usr/lib/python2.7/SocketServer.py", line 419, in __init__
self.server_bind()
File "/usr/lib/python2.7/wsgiref/simple_server.py", line 48, in server_bind
HTTPServer.server_bind(self)
File "/usr/lib/python2.7/BaseHTTPServer.py", line 108, in server_bind
SocketServer.TCPServer.server_bind(self)
File "/usr/lib/python2.7/SocketServer.py", line 430, in server_bind
self.socket.bind(self.server_address)
File "/usr/lib/python2.7/socket.py", line 224, in meth
return getattr(self._sock,name)(*args)
socket.error: [Errno 13] Permission denied
sh-4.2$
[Sun May 18 01:34:03 2014] [warn] [client ***.***.***.***] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server
[Sun May 18 01:34:03 2014] [error] [client ***.***.***.***] Premature end of script headers: abe.fcgi
dbtype MySQLdb
connect-args {"user":"abe","db":"abe","passwd":"mypass"}
datadir += [{
"dirname": "/root/.ultracoin",
"chain": "Ultracoin",
"code3": "UTC"}]
ServerName mydomain.com
Alias /static/ /home/ultra/abe-utc/Abe/htdocs
Alias /robots.txt /home/ultra/abe-utc/Abe/htdocs/robots.txt
Alias /favicon.ico /home/ultra/abe-utc/Abe/htdocs/favicon.ico
Alias / /usr/lib/cgi-bin/abe.fcgi/
# FcgidIOTimeout 40
#! /usr/bin/python
import subprocess, sys, os
command=["sudo", "-u", "ultra", "/home/ultra/mydomain.com/cgi-bin/abe", str(os.getpid())]
subprocess.Popen(command, stdin=sys.stdin).wait()
#! /bin/sh
PYTHONUNBUFFERED=1 exec python -m Abe.abe \
--config /home/ultra/abe-utc/abe.conf --static-path static/ --watch-pid="$1"
root@***:~/.ultracoin# python -m Abe.abe --config /home/ultra/abe-utc/abe.conf
Abe initialized.
Traceback (most recent call last):
File "/usr/lib/python2.7/runpy.py", line 162, in _run_module_as_main
"__main__", fname, loader, pkg_name)
File "/usr/lib/python2.7/runpy.py", line 72, in _run_code
exec code in run_globals
File "/usr/local/lib/python2.7/dist-packages/Abe/abe.py", line 2279, in
sys.exit(main(sys.argv[1:]))
File "/usr/local/lib/python2.7/dist-packages/Abe/abe.py", line 2275, in main
serve(store)
File "/usr/local/lib/python2.7/dist-packages/Abe/abe.py", line 2151, in serve
httpd = make_server(args.host, port, abe)
File "/usr/lib/python2.7/wsgiref/simple_server.py", line 144, in make_server
server = server_class((host, port), handler_class)
File "/usr/lib/python2.7/SocketServer.py", line 419, in __init__
self.server_bind()
File "/usr/lib/python2.7/wsgiref/simple_server.py", line 48, in server_bind
HTTPServer.server_bind(self)
File "/usr/lib/python2.7/BaseHTTPServer.py", line 108, in server_bind
SocketServer.TCPServer.server_bind(self)
File "/usr/lib/python2.7/SocketServer.py", line 430, in server_bind
self.socket.bind(self.server_address)
File "/usr/lib/python2.7/socket.py", line 224, in meth
return getattr(self._sock,name)(*args)
socket.error: [Errno 99] Cannot assign requested address
DataTables warning (table id = 'chain'): DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.
Python 2.7.6: /usr/bin/python
Sat May 17 14:03:00 2014
A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.
/usr/lib/python2.7/dist-packages/flup/server/fcgi_base.py in run(self=)
556 """Runs the handler, flushes the streams, and ends the request."""
557 try:
=> 558 protocolStatus, appStatus = self.server.handler(self)
559 except:
560 traceback.print_exc(file=self.stderr)
protocolStatus undefined, appStatus undefined, self =, self.server = , self.server.handler = >
/usr/lib/python2.7/dist-packages/flup/server/fcgi_base.py in handler(self=, req= )
1116 try:
1117 try:
=> 1118 result = self.application(environ, start_response)
1119 try:
1120 for data in result:
result = None, self =, self.application = <__main__.Abe instance>, environ = {'CONTENT_LENGTH': '0', 'CONTEXT_DOCUMENT_ROOT': '/usr/lib/cgi-bin/abe.fcgi/', 'CONTEXT_PREFIX': '/', 'DOCUMENT_ROOT': '/var/www', 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8', 'HTTP_ACCEPT_ENCODING': 'gzip,deflate,sdch', 'HTTP_ACCEPT_LANGUAGE': 'zh-CN,zh;q=0.8,en;q=0.6,zh-TW;q=0.4', 'HTTP_CONNECTION': 'close', 'HTTP_HOST': '192.168.1.110', ...}, start_response =
/usr/local/lib/python2.7/dist-packages/Abe/abe.py in __call__(abe=<__main__.Abe instance>, env={'CONTENT_LENGTH': '0', 'CONTEXT_DOCUMENT_ROOT': '/usr/lib/cgi-bin/abe.fcgi/', 'CONTEXT_PREFIX': '/', 'DOCUMENT_ROOT': '/var/www', 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8', 'HTTP_ACCEPT_ENCODING': 'gzip,deflate,sdch', 'HTTP_ACCEPT_LANGUAGE': 'zh-CN,zh;q=0.8,en;q=0.6,zh-TW;q=0.4', 'HTTP_CONNECTION': 'close', 'HTTP_HOST': '192.168.1.110', ...}, start_response=)
291 abe.store.catch_up()
292
=> 293 handler(page)
294 except PageNotFound:
295 status = '404 Not Found'
handler =>, page = {'body': [], 'chain': None, 'content_type': 'application/json', 'dotdot': '../', 'env': {'CONTENT_LENGTH': '0', 'CONTEXT_DOCUMENT_ROOT': '/usr/lib/cgi-bin/abe.fcgi/', 'CONTEXT_PREFIX': '/', 'DOCUMENT_ROOT': '/var/www', 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8', 'HTTP_ACCEPT_ENCODING': 'gzip,deflate,sdch', 'HTTP_ACCEPT_LANGUAGE': 'zh-CN,zh;q=0.8,en;q=0.6,zh-TW;q=0.4', 'HTTP_CONNECTION': 'close', 'HTTP_HOST': '192.168.1.110', ...}, 'params': {}, 'start_response': , 'template': '%(body)s', 'template_vars': {'ABE_URL': 'https://github.com/bitcoin-abe/bitcoin-abe', 'APPNAME': 'Abe', 'CONTENT_TYPE': 'text/html; charset=utf-8', 'COPYRIGHT': 'Abe developers', 'COPYRIGHT_URL': 'https://github.com/bitcoin-abe', 'COPYRIGHT_YEARS': '2011', 'DONATIONS_BTC': '1PWC7PNHL1SgvZaN7xEtygenKjWobWsCuf', 'DONATIONS_NMC': 'NJ3MSELK1cWnqUa6xhF2wUYAnz3RSrWXcK', 'HOMEPAGE': 'chains', 'STATIC_PATH': 'static/', ...}, 'title': ['Abe', ' ', '0.8pre']}
/usr/local/lib/python2.7/dist-packages/Abe/abe.py in handle_q(abe=<__main__.Abe instance>, page={'body': [], 'chain': None, 'content_type': 'application/json', 'dotdot': '../', 'env': {'CONTENT_LENGTH': '0', 'CONTEXT_DOCUMENT_ROOT': '/usr/lib/cgi-bin/abe.fcgi/', 'CONTEXT_PREFIX': '/', 'DOCUMENT_ROOT': '/var/www', 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8', 'HTTP_ACCEPT_ENCODING': 'gzip,deflate,sdch', 'HTTP_ACCEPT_LANGUAGE': 'zh-CN,zh;q=0.8,en;q=0.6,zh-TW;q=0.4', 'HTTP_CONNECTION': 'close', 'HTTP_HOST': '192.168.1.110', ...}, 'params': {}, 'start_response':, 'template': '%(body)s', 'template_vars': {'ABE_URL': 'https://github.com/bitcoin-abe/bitcoin-abe', 'APPNAME': 'Abe', 'CONTENT_TYPE': 'text/html; charset=utf-8', 'COPYRIGHT': 'Abe developers', 'COPYRIGHT_URL': 'https://github.com/bitcoin-abe', 'COPYRIGHT_YEARS': '2011', 'DONATIONS_BTC': '1PWC7PNHL1SgvZaN7xEtygenKjWobWsCuf', 'DONATIONS_NMC': 'NJ3MSELK1cWnqUa6xhF2wUYAnz3RSrWXcK', 'HOMEPAGE': 'chains', 'STATIC_PATH': 'static/', ...}, 'title': ['Abe', ' ', '0.8pre']})
1348 raise PageNotFound()
1349
=> 1350 abe.do_raw(page, func)
1351
1352 if page['content_type'] == 'text/plain':
abe = <__main__.Abe instance>, abe.do_raw =>, page = {'body': [], 'chain': None, 'content_type': 'application/json', 'dotdot': '../', 'env': {'CONTENT_LENGTH': '0', 'CONTEXT_DOCUMENT_ROOT': '/usr/lib/cgi-bin/abe.fcgi/', 'CONTEXT_PREFIX': '/', 'DOCUMENT_ROOT': '/var/www', 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8', 'HTTP_ACCEPT_ENCODING': 'gzip,deflate,sdch', 'HTTP_ACCEPT_LANGUAGE': 'zh-CN,zh;q=0.8,en;q=0.6,zh-TW;q=0.4', 'HTTP_CONNECTION': 'close', 'HTTP_HOST': '192.168.1.110', ...}, 'params': {}, 'start_response': , 'template': '%(body)s', 'template_vars': {'ABE_URL': 'https://github.com/bitcoin-abe/bitcoin-abe', 'APPNAME': 'Abe', 'CONTENT_TYPE': 'text/html; charset=utf-8', 'COPYRIGHT': 'Abe developers', 'COPYRIGHT_URL': 'https://github.com/bitcoin-abe', 'COPYRIGHT_YEARS': '2011', 'DONATIONS_BTC': '1PWC7PNHL1SgvZaN7xEtygenKjWobWsCuf', 'DONATIONS_NMC': 'NJ3MSELK1cWnqUa6xhF2wUYAnz3RSrWXcK', 'HOMEPAGE': 'chains', 'STATIC_PATH': 'static/', ...}, 'title': ['Abe', ' ', '0.8pre']}, func = >
/usr/local/lib/python2.7/dist-packages/Abe/abe.py in do_raw(abe=<__main__.Abe instance>, page={'body': [], 'chain': None, 'content_type': 'application/json', 'dotdot': '../', 'env': {'CONTENT_LENGTH': '0', 'CONTEXT_DOCUMENT_ROOT': '/usr/lib/cgi-bin/abe.fcgi/', 'CONTEXT_PREFIX': '/', 'DOCUMENT_ROOT': '/var/www', 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8', 'HTTP_ACCEPT_ENCODING': 'gzip,deflate,sdch', 'HTTP_ACCEPT_LANGUAGE': 'zh-CN,zh;q=0.8,en;q=0.6,zh-TW;q=0.4', 'HTTP_CONNECTION': 'close', 'HTTP_HOST': '192.168.1.110', ...}, 'params': {}, 'start_response':, 'template': '%(body)s', 'template_vars': {'ABE_URL': 'https://github.com/bitcoin-abe/bitcoin-abe', 'APPNAME': 'Abe', 'CONTENT_TYPE': 'text/html; charset=utf-8', 'COPYRIGHT': 'Abe developers', 'COPYRIGHT_URL': 'https://github.com/bitcoin-abe', 'COPYRIGHT_YEARS': '2011', 'DONATIONS_BTC': '1PWC7PNHL1SgvZaN7xEtygenKjWobWsCuf', 'DONATIONS_NMC': 'NJ3MSELK1cWnqUa6xhF2wUYAnz3RSrWXcK', 'HOMEPAGE': 'chains', 'STATIC_PATH': 'static/', ...}, 'title': ['Abe', ' ', '0.8pre']}, func= >)
1337 page['content_type'] = 'text/plain'
1338 page['template'] = '%(body)s'
=> 1339 page['body'] = func(page, page['chain'])
1340
1341 def handle_q(abe, page):
page = {'body': [], 'chain': None, 'content_type': 'application/json', 'dotdot': '../', 'env': {'CONTENT_LENGTH': '0', 'CONTEXT_DOCUMENT_ROOT': '/usr/lib/cgi-bin/abe.fcgi/', 'CONTEXT_PREFIX': '/', 'DOCUMENT_ROOT': '/var/www', 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8', 'HTTP_ACCEPT_ENCODING': 'gzip,deflate,sdch', 'HTTP_ACCEPT_LANGUAGE': 'zh-CN,zh;q=0.8,en;q=0.6,zh-TW;q=0.4', 'HTTP_CONNECTION': 'close', 'HTTP_HOST': '192.168.1.110', ...}, 'params': {}, 'start_response':, 'template': '%(body)s', 'template_vars': {'ABE_URL': 'https://github.com/bitcoin-abe/bitcoin-abe', 'APPNAME': 'Abe', 'CONTENT_TYPE': 'text/html; charset=utf-8', 'COPYRIGHT': 'Abe developers', 'COPYRIGHT_URL': 'https://github.com/bitcoin-abe', 'COPYRIGHT_YEARS': '2011', 'DONATIONS_BTC': '1PWC7PNHL1SgvZaN7xEtygenKjWobWsCuf', 'DONATIONS_NMC': 'NJ3MSELK1cWnqUa6xhF2wUYAnz3RSrWXcK', 'HOMEPAGE': 'chains', 'STATIC_PATH': 'static/', ...}, 'title': ['Abe', ' ', '0.8pre']}, func = >
/usr/local/lib/python2.7/dist-packages/Abe/abe.py in q_get_blocks_data(abe=<__main__.Abe instance>, page={'body': [], 'chain': None, 'content_type': 'application/json', 'dotdot': '../', 'env': {'CONTENT_LENGTH': '0', 'CONTEXT_DOCUMENT_ROOT': '/usr/lib/cgi-bin/abe.fcgi/', 'CONTEXT_PREFIX': '/', 'DOCUMENT_ROOT': '/var/www', 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8', 'HTTP_ACCEPT_ENCODING': 'gzip,deflate,sdch', 'HTTP_ACCEPT_LANGUAGE': 'zh-CN,zh;q=0.8,en;q=0.6,zh-TW;q=0.4', 'HTTP_CONNECTION': 'close', 'HTTP_HOST': '192.168.1.110', ...}, 'params': {}, 'start_response':, 'template': '%(body)s', 'template_vars': {'ABE_URL': 'https://github.com/bitcoin-abe/bitcoin-abe', 'APPNAME': 'Abe', 'CONTENT_TYPE': 'text/html; charset=utf-8', 'COPYRIGHT': 'Abe developers', 'COPYRIGHT_URL': 'https://github.com/bitcoin-abe', 'COPYRIGHT_YEARS': '2011', 'DONATIONS_BTC': '1PWC7PNHL1SgvZaN7xEtygenKjWobWsCuf', 'DONATIONS_NMC': 'NJ3MSELK1cWnqUa6xhF2wUYAnz3RSrWXcK', 'HOMEPAGE': 'chains', 'STATIC_PATH': 'static/', ...}, 'title': ['Abe', ' ', '0.8pre']}, chain=None)
1392 page['content_type'] = 'application/json'
1393 latest_blocks = []
=> 1394 total_number_of_blocks = abe.get_max_block_height(chain)
1395 post_data = get_post_data(page)
1396 if chain is None:
total_number_of_blocks undefined, abe = <__main__.Abe instance>, abe.get_max_block_height =>, chain = None
/usr/local/lib/python2.7/dist-packages/Abe/abe.py in get_max_block_height(abe=<__main__.Abe instance>, chain=None)
1379 # "getblockcount" traditionally returns max(block_height),
1380 # which is one less than the actual block count.
=> 1381 return abe.store.get_block_number(chain.id)
1382
1383 def q_getblockcount(abe, page, chain):
abe = <__main__.Abe instance>, abe.store =, abe.store.get_block_number = >, chain = None, chain.id undefined : 'NoneType' object has no attribute 'id'
args = ("'NoneType' object has no attribute 'id'",)
message = "'NoneType' object has no attribute 'id'"
import-tx += 01000000010000000000000000000000000000000000000000000000000000000000000000ffffffff350002e7033068747470733a2f2f626974636f696e74616c6b2e6f72672f696e6465782e7068703f746f7069633d3332353733352e30ffffffff0100e1f50500000000000000000000
datadir += [{
"dirname": "/usr/src/dev/bitcoin/blockchain/datacoin/",
"chain": "Datacoin",
"code3": "DTC",
"address_version": "\u001e",
"loader": "rpc",
"conf": "/usr/src/dev/bitcoin/blockchain/datacoin/datacoin.conf"
}]
python -m Abe.abe --config abe.conf
Falling back to default (Bitcoin) policy.
RPC failed: ('http protocol error', 0, 'got a bad status line', None)
Failed to catch up {'blkfile_offset': 0, 'blkfile_number': 1, 'chain_id': 11, 'loader': u'rpc', 'conf': u'/usr/src/dev/bitcoin/blockchain/datacoin/datacoin.conf', 'dirname': u'/usr/src/dev/bitcoin/blockchain/datacoin/', 'id': 18L}
Traceback (most recent call last):
File "Abe/DataStore.py", line 2511, in catch_up
raise Exception("RPC load failed")
Exception: RPC load failed
POST http://127.0.0.1:11777 HTTP/1.0
Content-Type: application/x-www-form-urlencoded
Content-Length: 70
Authorization: Basic [...]
Host: 127.0.0.1:11777
User-Agent: Python-urllib/1.17
{"params": [0], "jsonrpc": "2.0", "method": "getblockhash", "id": "x"}
is_stake_block undefined, is_stake_chain = True, b = {'chain_candidates': [{'chain':, 'in_longest': Decimal('1')}], 'chain_satoshi_seconds': 2517292340726300000000L, 'chain_satoshis': 3342705000000000, 'chain_work': 13618916087790469, 'fees': 57000, 'generated': 5000000000, 'hash': '00000000001930548377e3e15c927d8d79278cb8ba53b1d015468609e3085b13', 'hashMerkleRoot': '36f8065b8c6c95b37c426fbf95bb0bcf98dc04817de8257ffd624d8311cb2603', 'hashPrev': '000000000141a8721757560bb837c6d7be9aa85cf5333bfeaff2602c9d9a1d7a', 'height': Decimal('12441'), ...} : 'is_proof_of_stake'
args = ('is_proof_of_stake',)
message = 'is_proof_of_stake'
mysql> select * from block where block_id=5634;
+----------+----------------------------------+---------------+----------------------------------+-------------+-------------+--------------+--------------+---------------+-----------------+----------------------------------------+----------------+-----------------+----------------------+---------------------+-----------------------+----------------------+--------------+--------------------+
| block_id | block_hash | block_version | block_hashMerkleRoot | block_nTime | block_nBits | block_nNonce | block_height | prev_block_id | search_block_id | block_chain_work | block_value_in | block_value_out | block_total_satoshis | block_total_seconds | block_satoshi_seconds | block_total_ss | block_num_tx | block_ss_destroyed |
+----------+----------------------------------+---------------+----------------------------------+-------------+-------------+--------------+--------------+---------------+-----------------+----------------------------------------+----------------+-----------------+----------------------+---------------------+-----------------------+----------------------+--------------+--------------------+
| 5634 | =ô÷!€Åˆ·€�aí3ϲ
ApÀ½+----------+----------------------------------+---------------+----------------------------------+-------------+-------------+--------------+--------------+---------------+-----------------+----------------------------------------+----------------+-----------------+----------------------+---------------------+-----------------------+----------------------+--------------+--------------------+
1 row in set (0.00 sec)
AND cc.in_longest = 1
SELECT b.block_hash, b.block_height, b.block_nTime, b.block_num_tx,
b.block_nBits, b.block_value_out,
b.block_total_seconds, b.block_satoshi_seconds,
b.block_total_satoshis, b.block_ss_destroyed,
b.block_total_ss
FROM block b
JOIN chain_candidate cc ON (b.block_id = cc.block_id)
WHERE cc.chain_id = 1
AND cc.block_height BETWEEN 100 AND 200
AND cc.in_longest = 1
ORDER BY cc.block_height DESC LIMIT 50
AND cc.in_longest = 0