SELECT *
            FROM vw_get_unit_with_joins
            LIMIT 1000
            ;

SELECT * FROM sourceQuery WHERE uuid = '95098bcd-3d44-11ef-8d96-000d3a382364'

SELECT *
            FROM vw_get_property_with_fks
            LIMIT 1000
            ;

SELECT *
            FROM vw_get_property_file_with_fks
            LIMIT 1000
            ;

SELECT *
            FROM vw_get_unit_with_fks
            LIMIT 1000
            ;

SELECT *
            FROM vw_get_unit_file_with_fks
            LIMIT 1000
            ;

Application Variables:
ACCEPTEDFILEUPLOADMIMETYPES=image/jpg,image/jpeg,image/tiff,image/gif,image/png,application/pdf
ACCEPTEDFILEUPLOADTYPES=jpg,jpeg,tiff,gif,png,pdf
ADMINDOMAIN=workshop.thecentralbuilding.com
ADMINPAGES=crud,tableData
alert=
alertAction=
alertType=info
APIDOMAIN=api.thecentralbuilding.com
applicationname=thecentralbuilding.com
AUTHAPI=Component (_model.api.auth)
AUTHDAO=Component (_model.dao.auth)
AUTHMODEL=Component (_model.auth)
BASEDOMAIN=thecentralbuilding.com
CDNSERVER=/opt/myapps/central_building/uploads
DATASOURCE=centralbuilding
DEVENV=false
HOMEAPI=Component (_model.api.home)
HOMEDAO=Component (_model.dao.home)
HOMEDIR=/opt/myapps/central_building
HOMEMODEL=Component (_model.home)
LOCAL_ADDR=CGI.local_addr
NAVLINKS=
NAVTABLESEXCLUDED=0
SHOWDEBUG=false
SITE_TITLE=The Central Building
TABLEDATAAPI=Component (_model.api.tableData)
TABLEDATADAO=Component (_model.dao.tableData)
TABLEDATAMODEL=Component (_model.tableData)
UTILSAPI=Component (_model.api.utils)
UTILSDAO=Component (_model.dao.utils)
UTILSMODEL=Component (_model.utils)

CGI Variables:
auth_password=
auth_type=
auth_user=
cert_cookie=
cert_flags=
cert_issuer=
cert_keysize=
cert_secretkeysize=
cert_serialnumber=
cert_server_issuer=
cert_server_subject=
cert_subject=
cf_template_path=/opt/myapps/central_building/index.cfm
content_length=
content_type=
context_path=
gateway_interface=
http_accept=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
http_accept_encoding=br,gzip
http_accept_language=en-US,en;q=0.5
http_connection=close
http_cookie=
http_host=thecentralbuilding.com
http_referer=
http_user_agent=CCBot/2.0 (https://commoncrawl.org/faq/)
https=off
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=10.0.4.179
local_host=ip-10-0-4-179.ec2.internal
path_info=
path_translated=/opt/myapps/central_building/index.cfm
query_string=query_string=/unit/unit_details/l/0/id:95098bcd-3d44-11ef-8d96-000d3a382364&
remote_addr=127.0.0.1
remote_host=127.0.0.1
remote_user=
request_method=GET
request_url=http://thecentralbuilding.com/index.cfm?query_string=/unit/unit_details/l/0/id:95098bcd-3d44-11ef-8d96-000d3a382364&
script_name=/index.cfm
server_name=thecentralbuilding.com
server_port=80
server_port_secure=0
server_protocol=HTTP/1.0
server_software=
web_server_api=

Cookie Variables:
cfid=4dd71fdc-d1e9-4dd2-a4fa-4ab0ee9ce780
cftoken=0

Request Variables:
access=l
action=unit_details
alert=
alertaction=
alerttype=primary
apikey=0
model=unit
modeljsscript=/opt/myapps/central_building/js/unit/script.cfm
params=id:95098bcd-3d44-11ef-8d96-000d3a382364
url=Struct (1)
urlargs=Array (5)

Server Variables:
coldfusion=Struct (9)
java=Struct (8)
lucee=Struct (8)
os=Struct (8)
separator=Struct (3)
servlet=Struct (1)
system=Struct (2)

Session Variables:
alert=
alertAction=
alertType=warning
auth=Struct (1)
cfid=4dd71fdc-d1e9-4dd2-a4fa-4ab0ee9ce780
cftoken=0
lastvisit={ts '2025-12-05 21:22:28'}
sessionid=thecentralbuilding.com_4dd71fdc-d1e9-4dd2-a4fa-4ab0ee9ce780_0
timecreated={ts '2025-12-05 21:22:28'}
urltoken=CFID=4dd71fdc-d1e9-4dd2-a4fa-4ab0ee9ce780&CFTOKEN=0

URL Variables:
query_string=/unit/unit_details/l/0/id:95098bcd-3d44-11ef-8d96-000d3a382364