[Bug] Express, List Block, Sort by Address Type, Throws SQL error

Permalink 17 16 Browser Info Environment
When I have a List Block listing Entries in an Express Entity, and it has a column that is of Attribute Type Address, sorting that column (address) throws a nasty error.

"
An exception occurred while executing 'SELECT e.exEntryID FROM ExpressEntityEntries e LEFT JOIN REDACTEDSearchIndexAttributes ea ON e.exEntryID = ea.exEntryID WHERE (ak_REDACTED like ?) AND (ak_REDACTED like ?) AND (ak_REDACTED like ?) AND (e.exEntryEntityID = ?) ORDER BY ak_REDACTED_address asc' with params ["%%", "%%", "%%", "0f08edb0-02d5-11e7-ba7c-feb6b307f11e"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_REDACTED_address' in 'order clause'
"


Status: New

concrete5 Environment Information

# concrete5 Version
Core Version - 8.1.0
Version Installed - 8.1.0
Database Version - 20170123000000

# concrete5 Packages
ExchangeCore reCAPTCHA (1.1.1), Fundamental (4.0.1), Styled Maps (1.2.3), toesslab - Express Entry List (1.0)

# concrete5 Overrides
blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/view.css, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/icon.png, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/add.php, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/view.js, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/controller.php, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/db.xml, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/view.php, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/edit.php, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/auto.js, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list, blocks/toess_lab_express_entry_list_block/templates, blocks/toess_lab_express_entry_list_block, blocks/express_entry_list/templates/apply_to_work_records_list/view.css, blocks/express_entry_list/templates/apply_to_work_records_list/icon.png, blocks/express_entry_list/templates/apply_to_work_records_list/add.php, blocks/express_entry_list/templates/apply_to_work_records_list/view.js, blocks/express_entry_list/templates/apply_to_work_records_list/controller.php, blocks/express_entry_list/templates/apply_to_work_records_list/db.xml, blocks/express_entry_list/templates/apply_to_work_records_list/view.php, blocks/express_entry_list/templates/apply_to_work_records_list/edit.php, blocks/express_entry_list/templates/apply_to_work_records_list/auto.js, blocks/express_entry_list/templates/apply_to_work_records_list, blocks/express_entry_list/templates, blocks/express_entry_list, blocks/express_entry_detail/templates/apply_to_work_records_details/view.css, blocks/express_entry_detail/templates/apply_to_work_records_details/view.php, blocks/express_entry_detail/templates/apply_to_work_records_details, blocks/express_entry_detail/templates/get_info_records_details/view.css, blocks/express_entry_detail/templates/get_info_records_details/view.php, blocks/express_entry_detail/templates/get_info_records_details, blocks/express_entry_detail/templates, blocks/express_entry_detail, blocks/express_form/templates/client_feedback_form/view.css, blocks/express_form/templates/client_feedback_form/view.php, blocks/express_form/templates/client_feedback_form, blocks/express_form/templates/get_info_form/view.css, blocks/express_form/templates/get_info_form/view.php, blocks/express_form/templates/get_info_form, blocks/express_form/templates/apply_to_work_form/view.css, blocks/express_form/templates/apply_to_work_form/view.php, blocks/express_form/templates/apply_to_work_form, blocks/express_form/templates, blocks/express_form, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/es_PY/LC_MESSAGES/messages.mo, languages/es_PY/LC_MESSAGES, languages/es_PY, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/cs_CZ/LC_MESSAGES/messages.mo, languages/cs_CZ/LC_MESSAGES, languages/cs_CZ, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/en_GB/LC_MESSAGES/messages.mo, languages/en_GB/LC_MESSAGES, languages/en_GB, mail/block_express_form_submission.php, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/view.css, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/icon.png, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/add.php, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/view.js, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/controller.php, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/db.xml, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/view.php, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/edit.php, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list/auto.js, blocks/toess_lab_express_entry_list_block/templates/apply_to_work_records_list, blocks/toess_lab_express_entry_list_block/templates, blocks/toess_lab_express_entry_list_block, blocks/express_entry_list/templates/apply_to_work_records_list/view.css, blocks/express_entry_list/templates/apply_to_work_records_list/icon.png, blocks/express_entry_list/templates/apply_to_work_records_list/add.php, blocks/express_entry_list/templates/apply_to_work_records_list/view.js, blocks/express_entry_list/templates/apply_to_work_records_list/controller.php, blocks/express_entry_list/templates/apply_to_work_records_list/db.xml, blocks/express_entry_list/templates/apply_to_work_records_list/view.php, blocks/express_entry_list/templates/apply_to_work_records_list/edit.php, blocks/express_entry_list/templates/apply_to_work_records_list/auto.js, blocks/express_entry_list/templates/apply_to_work_records_list, blocks/express_entry_list/templates, blocks/express_entry_list, blocks/express_entry_detail/templates/apply_to_work_records_details/view.css, blocks/express_entry_detail/templates/apply_to_work_records_details/view.php, blocks/express_entry_detail/templates/apply_to_work_records_details, blocks/express_entry_detail/templates/get_info_records_details/view.css, blocks/express_entry_detail/templates/get_info_records_details/view.php, blocks/express_entry_detail/templates/get_info_records_details, blocks/express_entry_detail/templates, blocks/express_entry_detail, blocks/express_form/templates/client_feedback_form/view.css, blocks/express_form/templates/client_feedback_form/view.php, blocks/express_form/templates/client_feedback_form, blocks/express_form/templates/get_info_form/view.css, blocks/express_form/templates/get_info_form/view.php, blocks/express_form/templates/get_info_form, blocks/express_form/templates/apply_to_work_form/view.css, blocks/express_form/templates/apply_to_work_form/view.php, blocks/express_form/templates/apply_to_work_form, blocks/express_form/templates, blocks/express_form, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/es_PY/LC_MESSAGES/messages.mo, languages/es_PY/LC_MESSAGES, languages/es_PY, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/cs_CZ/LC_MESSAGES/messages.mo, languages/cs_CZ/LC_MESSAGES, languages/cs_CZ, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/en_GB/LC_MESSAGES/messages.mo, languages/en_GB/LC_MESSAGES, languages/en_GB, mail/block_express_form_submission.php

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - On - If blocks on the particular page allow it.
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache/2.4.18 (Ubuntu)

# Server API
apache2handler

# PHP Version
7.0.15-0ubuntu0.16.04.4

# PHP Extensions
apache2handler, calendar, Core, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imagick, json, libxml, mbstring, mcrypt, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, Phar, posix, readline, Reflection, session, shmop, SimpleXML, sockets, SPL, standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, Zend OPcache, zip, zlib

# PHP Settings
max_execution_time - 60
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 20M
sql.safe_mode - Off
upload_max_filesize - 20M
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
opcache.max_accelerated_files - 2000
opcache.max_file_size - 0
opcache.max_wasted_percentage - 5

Browser User-Agent String

Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/56.0.2924.76 Chrome/56.0.2924.76 Safari/537.36