SELECT *
            FROM vw_get_unit_with_joins
            LIMIT 1000
            ;

SELECT * FROM sourceQuery WHERE is_active = 1 AND is_deleted = 0

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=www.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=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=*/*
http_accept_encoding=gzip, br, zstd, deflate
http_accept_language=
http_connection=close
http_cookie=
http_host=www.thecentralbuilding.com
http_referer=
http_user_agent=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
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&
remote_addr=127.0.0.1
remote_host=127.0.0.1
remote_user=
request_method=GET
request_url=http://www.thecentralbuilding.com/index.cfm?query_string=/unit&
script_name=/index.cfm
server_name=www.thecentralbuilding.com
server_port=80
server_port_secure=0
server_protocol=HTTP/1.0
server_software=
web_server_api=

Cookie Variables:
cfid=cdfc1a7d-3260-47df-8f54-3e4d267c4e2f
cftoken=0

Request Variables:
access=
action=index
alert=
alertaction=
alerttype=primary
apikey=
model=unit
modeljsscript=/opt/myapps/central_building/js/unit/script.cfm
params=
urlargs=Array (1)

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=cdfc1a7d-3260-47df-8f54-3e4d267c4e2f
cftoken=0
lastvisit={ts '2025-08-22 21:29:19'}
sessionid=www.thecentralbuilding.com_cdfc1a7d-3260-47df-8f54-3e4d267c4e2f_0
timecreated={ts '2025-08-22 21:29:19'}
urltoken=CFID=cdfc1a7d-3260-47df-8f54-3e4d267c4e2f&CFTOKEN=0

URL Variables:
query_string=/unit