SELECT classpagetext, classtitle FROM web_class WHERE "webclass" = 'any';

SELECT
	 "pageid",
         REPLACE("menutext",' & ',' & ') as menutext,
         REPLACE("url",' & ',' %26 ') AS url,
         "menu_order",
         "orderseq"
         FROM web_navmenu
         WHERE site='K' 
         ORDER BY menu_order, orderseq

SELECT
	 "pageid",
         REPLACE("menutext",' & ',' & ') as menutext,
         REPLACE("url",' & ',' %26 ') AS url,
         "menu_order",
         "orderseq"
         FROM web_menuview
         WHERE site='K' 
         ORDER BY menu_order, orderseq

SELECT
	 "pageid",
         REPLACE("menutext",' & ',' & ') as menutext,
         REPLACE("url",' & ',' %26 ') AS url,
         "menu_order",
         "orderseq"
         FROM web_navmenu
         WHERE site='K' 
         ORDER BY menu_order, orderseq

select block_text from web_block where block_key='Kelco Store'

SELECT
            "web_stylegroup"."stylecode" AS itemn,
            "web_stylegroup"."styledesc" AS webdesc,
            "web_stylegroup"."styledescbold" AS descbold,
            "web_stylegroup"."stylesize" AS websize,
            ' ' AS picfile1,
            ' ' AS picfile2,
            ' ' AS thumb,
            ' ' AS stylecode,
            0.00 AS price,
            0.00 AS weight,
            0 AS onhand,
            0 AS reserved,
            'Y' AS active,
            "web_stylegroup"."feature1" AS outforseason,
            'N' AS largepackage,
            0 AS line,
            0 AS ordered,
            ' ' AS backordermsg,
            'G' AS type,
            0 AS typeorder,
             0 AS kit_available,
            1 AS rank
      FROM web_stylegroup
      WHERE "web_stylegroup"."stylecode" = upper('Gilmourbrand')
      GROUP BY itemn, webdesc, descbold, websize, picfile1, picfile2, outforseason
           UNION
 	SELECT
            "item_web"."itemn" AS itemn,
            "item_web"."webdesc" AS webdesc,
            ' ' AS descbold,
            "item_web"."websize" AS websize,
            "item_web"."picfile1" AS picfile1,
            "item_web"."picfile2" AS picfile2,
            COALESCE("item_webimages"."thumb",(SELECT thumb FROM item_webimages AS iwi WHERE iwi.itemn = (SELECT sameasitemn FROM item_webimages AS tiwi WHERE tiwi.itemn = item_web.itemn))) AS thumb,
            ' ' AS stylecode,
            "item"."base_price" AS price,
            "item"."weight" AS weight,
            "item"."onhand" AS onhand,
            "item"."reserved" AS reserved,
            "item"."active" AS active,
            "item"."outforseason" AS outforseason,
            "item"."largepackage" AS largepackage,
            "worderitem"."line" AS line,
            "worderitem"."ordered" AS ordered,
            "item_web"."backordermsg" AS backordermsg,
            "item"."type" AS type,
            '1' AS typeorder,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available,
	ts_rank(textsearchable_index_col, to_tsquery('english', 'Gilmourbrand'),1) as rank
      FROM "item" left OUTER JOIN
        ( select parentitemn, compqty, onhand, reserved from item_component join
 item ON childitemn = item.itemn )
        AS item_kit ( parentitemn, compqty, onhand, reserved )
        ON (item_kit.parentitemn = item.itemn),
          "item_web" left OUTER JOIN "worderitem"
        ON "item_web"."itemn" = "worderitem"."itemn" and "worderitem"."weborder" = 0 LEFT OUTER JOIN "item_webimages" ON "item_webimages"."itemn" = "item_web"."itemn"
      WHERE "item"."itemn" = "item_web"."itemn" and "item_web"."sitecode" = 'K' and "item_web"."web_class" <> 'ZZZ' and "item"."discontinued" = 'N' AND "item"."not_for_website" = 'N' AND
(textsearchable_index_col @@ to_tsquery('english','Gilmourbrand') OR "item"."itemn" ILIKE 'Gilmourbrand%')
     GROUP BY item_web.itemn, webdesc, descbold,  websize, picfile1, picfile2, thumb, stylecode, price, 
	weight, item.onhand, type, item.reserved, active, outforseason, 
	largepackage, backordermsg, line, ordered,textsearchable_index_col

     ORDER BY typeorder,webdesc ASC;

SELECT
	 "pageid",
         REPLACE("menutext",' & ',' & ') as menutext,
         REPLACE("url",' & ',' %26 ') AS url,
         "menu_order",
         "orderseq"
         FROM web_navmenu
         WHERE site='K' 
         ORDER BY menu_order, orderseq

Application Variables:
applicationname=
INITIALIZED=1

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=/var/www/html/kelcomaine/searchresults.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=gzip
http_accept_language=en-US,en;q=0.5
http_connection=close
http_cookie=
http_host=www.kelcomaine.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=127.0.0.1
local_host=ec2trixie.kelcomaine.com
path_info=
path_translated=/var/www/html/kelcomaine/searchresults.cfm
query_string=SearchText=Gilmourbrand&SearchClass=any&Go=Go
remote_addr=127.0.0.1
remote_host=127.0.0.1
remote_user=
request_method=GET
request_url=http://www.kelcomaine.com/searchresults.cfm?SearchText=Gilmourbrand&SearchClass=any&Go=Go
script_name=/searchresults.cfm
server_name=www.kelcomaine.com
server_port=80
server_port_secure=0
server_protocol=HTTP/1.1
server_software=
web_server_api=

Cookie Variables:
cfid=42070c65-f6c2-4d6f-9b9f-4f007243cd77
cftoken=0
HTTPREFERER=
initialized=1
REMOTEIP=34.238.189.171

Request Variables:
cart_items=0

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:
cfid=42070c65-f6c2-4d6f-9b9f-4f007243cd77
cftoken=0
INITIALZOOM=1
lastvisit={ts '2019-08-19 12:41:17'}
MOBILEMODE=false
SCREENHEIGHT=768
SCREENWIDTH=1024
sessionid=_42070c65-f6c2-4d6f-9b9f-4f007243cd77_0
timecreated={ts '2019-08-19 12:41:17'}
urltoken=CFID=42070c65-f6c2-4d6f-9b9f-4f007243cd77&CFTOKEN=0

URL Variables:
Go=Go
SearchClass=any
SearchText=Gilmourbrand