Most of the print and plaid ribbons on this page are Weather Resistant and can withstand normal outside weather conditions. Some are Weather Sensitive which means they can handle only minimal exposure to outside weather conditions and are really best for indoor use. Please check the product description before ordering if you intend to use these ribbons outdoors.


Qty 
Item #: R40DWIBRLN
Burlap Natural Color Wire Edge #40
2 5/8" wide 25 yard roll
In Stock
1 lbs.
$25.70

Qty 
Item #: RP40DWIST
Candy Cane Stripes
2 1/2" wide 50 yard roll
In Stock
1 lbs.
$21.00

Qty 
Item #: RP09DWIST
Candy Cane Stripes
1 1/2" wide 50 yard roll
In Stock
0.8 lbs.
$14.40

Qty 
Item #: R40DWIHB
Holly Natural Color Wire Edge #40
2 1/2" wide 25 yard roll
In Stock
1 lbs.
$25.70

Qty 
Item #: R40DWILIN
Natural Beige Linen Ribbon Wire Edge #40
2-5/8" wide 50 yard roll
In Stock
1 lbs.
$22.05

Qty 
Item #: R40DWIBT
Plaid Brushed Muslin Red/Emerald #40
2 5/8" wide 25 yard roll
In Stock
1 lbs.
$21.30

Qty 
Item #: R40PWPBGG
Plaid Burgandy/Green/Gold Wire Edge #40
2 1/2" wide 25 yard roll
In Stock
1 lbs.
$21.00

Qty 
Item #: R40TMB
Plaid Burgundy / Hunter Green #40
2 5/8" wide 25 yard roll
In Stock
0.4 lbs.
$15.95

Qty 
Item #: R09TMB
Plaid Burgundy / Hunter Green #9
1 1/2" wide 25 yard roll
In Stock
0.2 lbs.
$9.35

We're sorry, this item is sold out for this season.
Item #: R40DWIXM
Plaid Country Christmas Wire Edge #40
2 1/2" wide 25 yard roll
Out of stock
1 lbs.
$18.45

Qty 
Item #: R40WP25
Plaid Ivory/Red/Hunter Green Woolen #40
2 5/8" wide 25 yard roll
In Stock
0.4 lbs.
$22.30

Qty 
Item #: R40TMC
Plaid Multi Color Plaid #40
2 5/8" wide 25 yard roll
In Stock
0.4 lbs.
$15.95

Qty 
Item #: R09TMC
Plaid Multi Color Ribbon #9
1 1/2" wide 25 yard roll
In Stock
0.2 lbs.
$9.35

Qty 
Item #: RP40PMP
Plaid Red/Gold/Green Gold Edge #40
2 1/2" wide 50 yard roll
In Stock
1 lbs.
$17.35

Qty 
Item #: RP09PTP
Plaid Red/Gold/Green Gold Edge #9
1 1/2" wide 50 yard roll
In Stock
1 lbs.
$12.65

Qty 
Item #: RP09PMP
Plaid Red/Gold/Green Gold Edge #9
1 1/2" wide 50 yard roll
In Stock
1 lbs.
$12.65

Qty 
Item #: RP40PTP
Plaid Red/Gold/Green Gold Edge #9
2 1/2" wide 50 yard roll
In Stock
1 lbs.
$16.95

Qty 
Item #: R40TRG
Plaid Red/Green Metallic Ribbon #40
2 5/8" wide 25 yard roll
In Stock
0.4 lbs.
$15.95

Qty 
Item #: R09TRG
Plaid Red/Green Ribbon #9
1 1/2" wide 25 yard roll
In Stock
0.2 lbs.
$9.35

Qty 
Item #: R40MWSPR25
Plaid Red Scotch Muslin Ribbon #40
2-5/8" wide 25 yard roll
In Stock
0.4 lbs.
$22.30

Qty 
Item #: R40CLWS
Print Classic Holiday #40 Red/Gold/Sheer
2 1/2" wide 25 yard roll
In Stock
0.4 lbs.
$37.05

Qty 
Item #: R40DWICGB
Print Country Gingham Burgundy #40
2 5/8" wide 25 yard roll
In Stock
1 lbs.
$17.40

Qty 
Item #: R40DWICGR
Print Country Gingham Red #40
2 5/8" wide 25 yard roll
In Stock
1 lbs.
$17.40

Qty 
Item #: R40PWCC
Print Flashy Candy Cane Wire Edge #40
2 1/2" wide 25 yard roll
In Stock
1 lbs.
$21.10

Qty 
Item #: RP40MCB
Print McBurgundy Plaid #40
2 1/2" 50 yard roll
In Stock
1 lbs.
$17.10

Qty 
Item #: RP09MCB
Print McBurgundy Plaid #9
1 1/2" 50 yard roll
In Stock
1 lbs.
$12.00

Qty 
Item #: R40DWIBC25
Print Red/Black Check #40
2-5/8" wide 25 yard roll
In Stock
0.4 lbs.
$22.35

Qty 
Item #: R40TWGS25
Print Red Velvet Gold Stars Wire #40
2 5/8" wide 25 yard roll
In Stock
0.8 lbs.
$22.55

Qty 
Item #: R40MWRWC25
Print Red/White Checked Muslin #40
2-5/8" wide 25 yard roll
In Stock
0.4 lbs.
$21.30

Qty 
Item #: R40DWICC25
Print Red/White/Silver Candy Cane #40
2 5/8" wide 25 yard roll
In Stock
0.8 lbs.
$22.60

Qty 
Item #: R09DWICC25
Print Red/White/Silver Candy Cane #9
1 1/2" wide 25 yard roll
In Stock
0.6 lbs.
$11.20

Qty 
Item #: R40WSBW
Print Silver Pine Cones
2 5/8" wide 25 yard roll
In Stock
0.4 lbs.
$21.65

Qty 
Item #: R40SHSB25
Print Silver Snowflack Ribbon #40
2-5/8" wide 25 yard roll
In Stock
0.4 lbs.
$21.95

Qty 
Item #: R40DWISF
Print Silver Snowflake Wire Edge #40
2 1/2" wide 25 yard roll
In Stock
1 lbs.
$22.90

Qty 
Item #: R40PWSM
Print Sparkling Snowman Wire Edge #40
2 1/2" wide 25 yard roll
In Stock
1 lbs.
$21.10

Qty 
Item #: R40TWSS25
Velvet Blue w/Stars #40 Silver Edge
2 1/2" X 25 yard roll
In Stock
0.8 lbs.
$22.55

Qty 
Item #: R40TWBS25
Velvet White w/Stars #40 Wire Edge
2 1/2" X 25 yard roll
In Stock
0.8 lbs.
$22.55

Qty 
Item #: R40DWIBK
Wild Buck Ribbon #40
2 1/2" X 25 yard roll
In Stock
1 lbs.
$21.30


Debugging Information
Lucee (Velvet) Os 5.2.9.31 (CFML Version 2016,0,03,300357)
Template /searchresults.cfm (/var/www/html/kelcomaine/searchresults.cfm)
Time Stamp Sep 15, 2019 8:05 AM
Time Zone UTC
Locale English (us)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 127.0.0.1
Host Name kelcomaine.com
Architecture 64bit


Execution Time

Total Time Avg Time Count Template
263 ms 263 ms 1 /var/www/html/kelcomaine/searchresults.cfm
11.4 ms 11.4 ms 1 /var/www/html/kelcomaine/getitemsbyclass.cfm
35.5 ms 8.89 ms 4 /var/www/html/kelcomaine/makemenu.cfm
8.87 ms 8.87 ms 1 /var/www/html/kelcomaine/pagetopstatus.cfm
136 ms 3.68 ms 37 /var/www/html/kelcomaine/addtocartform.cfm
2.59 ms 1.29 ms 2 /var/www/html/kelcomaine/getitemwebbrowse.cfm
1.17 ms 1.17 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequestStart
0.919 ms 0.919 ms 1 /var/www/html/kelcomaine/getwebblock.cfm
0.319 ms 0.319 ms 1 /var/www/html/kelcomaine/pagetopandleft.cfm
0.161 ms 0.161 ms 1 /var/www/html/kelcomaine/Application.cfc
0.131 ms 0.131 ms 1 /var/www/html/kelcomaine/pagebottom.cfm
0.107 ms 0.107 ms 1 /var/www/html/kelcomaine/pagetop.cfm
0.086 ms 0.086 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc
0.028 ms 0.028 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$checkUserAgentPrefix
0.025 ms 0.025 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$wapDetection
0.021 ms 0.021 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$checkUserAgentContains
0.028 ms 0.014 ms 2 /var/www/html/kelcomaine/WEB-INF/lucee/context/Component.cfc
0.011 ms 0.011 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$isMobile
0.007 ms 0.007 ms 1 /var/www/html/kelcomaine/cssheader.cfm
0.006 ms 0.006 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$init
0.005 ms 0.005 ms 1 /var/www/html/kelcomaine/addtoprocess.cfm
0.004 ms 0.004 ms 1 /var/www/html/kelcomaine/wilsonlib.cfm
0.004 ms 0.004 ms 1 /var/www/html/kelcomaine/searchcheckparam.cfm
0.06 ms 0.001 ms 37 /var/www/html/kelcomaine/addtocartbutton.cfm
0.001 ms 0.001 ms 1 /var/www/html/kelcomaine/soldoutform.cfm
0 ms 0 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequest
0.831 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
442 ms  APPLICATION EXECUTION TIME
18.9 ms  QUERY EXECUTION TIME
462 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Implicit variable Access

Scope Template Line Var Count
variables /addtocartform.cfm 1 noanchor 36
variables /addtocartform.cfm 2 NOANCHOR 1
variables /addtocartform.cfm 5 NOANCHOR 37
query /addtocartform.cfm 6 ITEMN 37
variables /addtocartform.cfm 8 QUERY_STRING 37
query /addtocartform.cfm 8 ITEMN 37
query /addtocartform.cfm 12 ONHAND 37
query /addtocartform.cfm 12 RESERVED 37
query /addtocartform.cfm 28 BACKORDERMSG 37
query /addtocartform.cfm 29 ITEMN 37
query /addtocartform.cfm 30 ITEMN 37
variables /Application.cfc 34 MOBILEDETECTION 1
variables /Application.cfc 35 MOBILEDETECTION 1
variables /Application.cfc 88 cflock 1
variables /Application.cfc 108 CLIENT_IP 1
variables /Application.cfc 110 CLIENT_IP 1
variables /Application.cfc 112 RIP 1
variables /Application.cfc 112 CLIENT_IP 1
variables /Application.cfc 136 rip 1
variables /Application.cfc 137 RIP 1
variables /Application.cfc 143 CSEMAIL 1
variables /Application.cfc 145 SAFETAGS 1
variables /Application.cfc 147 ALWAYSINSTOCK 1
variables /getitemsbyclass.cfm 63 WEBORDER 1
variables /getitemsbyclass.cfm 67 cfquery 1
variables /getitemsbyclass.cfm 67 catsearch 1
variables /getitemwebbrowse.cfm 1 webclass 2
variables /getitemwebbrowse.cfm 9 WEBCLASS 2
variables /getitemwebbrowse.cfm 10 cfquery 2
variables /getitemwebbrowse.cfm 10 getitemwebbrowse 2
variables /getwebblock.cfm 2 BLOCK 1
variables /getwebblock.cfm 3 getwebblock 1
variables /getwebblock.cfm 3 cfquery 1
variables /makemenu.cfm 3 RETURN_VALUE 36
arguments /makemenu.cfm 3 TEMPLATE 36
arguments /makemenu.cfm 4 TEMPLATE 36
variables /makemenu.cfm 5 TAG_VALUE 3
variables /makemenu.cfm 6 RETURN_VALUE 6
variables /makemenu.cfm 6 TAG_VALUE 3
arguments /makemenu.cfm 8 TEMPLATE 36
variables /makemenu.cfm 9 RETURN_VALUE 6
variables /makemenu.cfm 11 RETURN_VALUE 36
variables /makemenu.cfm 21 MENUTABLE 4
variables /makemenu.cfm 24 getmenu 4
variables /makemenu.cfm 24 cfquery 4
variables /makemenu.cfm 26 menu_type 4
variables /makemenu.cfm 30 MENU_TYPE 4
variables /makemenu.cfm 33 SUBMENU 2
variables /makemenu.cfm 34 PREV_MENU_ORDER 2
variables /makemenu.cfm 35 FIRST 2
variables /makemenu.cfm 36 getmenu 2
variables /makemenu.cfm 37 PREV_MENU_ORDER 36
variables /makemenu.cfm 37 GETMENU 36
variables /makemenu.cfm 38 PREV_MENU_ORDER 8
variables /makemenu.cfm 38 GETMENU 8
variables /makemenu.cfm 39 SUBMENU 8
variables /makemenu.cfm 40 PREV_MENUTEXT 2
variables /makemenu.cfm 40 PREV_URL 2
variables /makemenu.cfm 43 FIRST 6
variables /makemenu.cfm 44 PREV_MENUTEXT 4
variables /makemenu.cfm 44 PREV_URL 4
variables /makemenu.cfm 47 SUBMENU 8
variables /makemenu.cfm 48 FIRST 8
variables /makemenu.cfm 49 GETMENU 8
variables /makemenu.cfm 49 PREV_URL 8
variables /makemenu.cfm 50 PREV_MENUTEXT 8
variables /makemenu.cfm 50 GETMENU 8
variables /makemenu.cfm 52 SUBMENU 28
variables /makemenu.cfm 53 PREV_MENUTEXT 25
variables /makemenu.cfm 53 PREV_URL 25
variables /makemenu.cfm 55 SUBMENU 28
variables /makemenu.cfm 56 PREV_MENUTEXT 3
variables /makemenu.cfm 56 PREV_URL 3
variables /makemenu.cfm 58 SUBMENU 3
variables /makemenu.cfm 60 PREV_URL 28
variables /makemenu.cfm 60 GETMENU 28
variables /makemenu.cfm 61 GETMENU 28
variables /makemenu.cfm 61 PREV_MENUTEXT 28
variables /makemenu.cfm 65 SUBMENU 2
variables /makemenu.cfm 67 PREV_MENUTEXT 1
variables /makemenu.cfm 67 PREV_URL 1
variables /makemenu.cfm 71 PREV_URL 1
variables /makemenu.cfm 71 PREV_MENUTEXT 1
variables /makemenu.cfm 74 SUBMENU 2
variables /makemenu.cfm 82 MENU_TYPE 4
variables /makemenu.cfm 83 FIRST 1
variables /makemenu.cfm 84 getmenu 1
variables /makemenu.cfm 85 FIRST 5
variables /makemenu.cfm 86 GETMENU 10
variables /makemenu.cfm 87 FIRST 5
variables /makemenu.cfm 91 MENU_TYPE 4
variables /makemenu.cfm 92 getmenu 1
variables /makemenu.cfm 93 GETMENU 10
variables /pagebottom.cfm 13 MENU_TYPE 1
variables /pagebottom.cfm 14 MENUTABLE 1
variables /pagetop.cfm 29 MENU_TYPE 1
variables /pagetop.cfm 30 MENUTABLE 1
variables /pagetopandleft.cfm 14 MENU_TYPE 1
variables /pagetopandleft.cfm 15 MENUTABLE 1
variables /pagetopandleft.cfm 17 MENU_TYPE 1
variables /pagetopandleft.cfm 18 MENUTABLE 1
variables /pagetopandleft.cfm 26 BLOCK 1
variables /pagetopandleft.cfm 28 GETWEBBLOCK 1
variables /pagetopstatus.cfm 1 BROWSELINKS 1
variables /pagetopstatus.cfm 3 BROWSEURL 1
variables /pagetopstatus.cfm 10 WEBCLASS 1
variables /pagetopstatus.cfm 12 GETITEMWEBBROWSE 2
variables /pagetopstatus.cfm 12 SAFETAGS 1
variables /pagetopstatus.cfm 12 BROWSELINKS 1
variables /pagetopstatus.cfm 13 GETITEMWEBBROWSE 1
variables /pagetopstatus.cfm 13 SAFETAGS 1
variables /pagetopstatus.cfm 13 BROWSELINKS 1
variables /searchresults.cfm 4 getwebclass 1
variables /searchresults.cfm 4 cfquery 1
variables /searchresults.cfm 12 GETWEBCLASS 1
variables /searchresults.cfm 12 TITLE 1
variables /searchresults.cfm 13 TITLE 1
variables /searchresults.cfm 14 TITLE 1
variables /searchresults.cfm 17 WEBCLASS 1
variables /searchresults.cfm 19 GETITEMWEBBROWSE 1
variables /searchresults.cfm 20 GETITEMWEBBROWSE 2
variables /searchresults.cfm 20 TITLE 1
variables /searchresults.cfm 26 TITLE 1
variables /searchresults.cfm 30 SHOWTHUMBS 1
variables /searchresults.cfm 35 QUERY_STRING 1
variables /searchresults.cfm 36 QUERY_STRING 2
variables /searchresults.cfm 37 QUERY_STRING 2
variables /searchresults.cfm 50 WEBORDER 1
variables /searchresults.cfm 71 CATSEARCH 1
variables /searchresults.cfm 73 BROWSELINKS 1
variables /searchresults.cfm 81 GETWEBCLASS 1
variables /searchresults.cfm 83 catsearch 1
query /searchresults.cfm 84 STYLECODE 38
query /searchresults.cfm 86 ITEMN 76
variables /searchresults.cfm 86 THUMBPATH 38
query /searchresults.cfm 87 PICFILE1 38
query /searchresults.cfm 89 PICFILE1 13
variables /searchresults.cfm 89 THUMBPATH 13
variables /searchresults.cfm 90 THUMBPATH 13
variables /searchresults.cfm 91 THUMBPATH 39
variables /searchresults.cfm 93 THUMBPATH 26
variables /searchresults.cfm 95 THUMBPATH 38
variables /searchresults.cfm 96 THUMBPATH 38
query /searchresults.cfm 99 ITEMN 76
variables /searchresults.cfm 99 THUMBPATH2 38
query /searchresults.cfm 100 PICFILE2 38
variables /searchresults.cfm 108 THUMBPATH2 38
variables /searchresults.cfm 109 THUMBPATH2 38
query /searchresults.cfm 119 OUTFORSEASON 38
query /searchresults.cfm 119 ACTIVE 38
query /searchresults.cfm 121 STYLECODE 37
query /searchresults.cfm 121 TYPE 37
query /searchresults.cfm 138 ORDERED 37
query /searchresults.cfm 173 ITEMN 38
query /searchresults.cfm 178 TYPE 38
query /searchresults.cfm 182 TYPE 38
query /searchresults.cfm 182 ITEMN 38
query /searchresults.cfm 184 WEBDESC 38
query /searchresults.cfm 189 TYPE 38
query /searchresults.cfm 192 ITEMN 38
query /searchresults.cfm 192 TYPE 38
query /searchresults.cfm 194 WEBSIZE 38
query /searchresults.cfm 209 TYPE 38
query /searchresults.cfm 212 TYPE 38
query /searchresults.cfm 212 ITEMN 38
query /searchresults.cfm 214 THUMB 38
query /searchresults.cfm 214 ITEMN 34
variables /searchresults.cfm 216 THUMBPATH 4
query /searchresults.cfm 221 TYPE 38
query /searchresults.cfm 224 TYPE 38
query /searchresults.cfm 224 ITEMN 38
variables /searchresults.cfm 226 THUMBPATH2 38
query /searchresults.cfm 230 TYPE 38
query /searchresults.cfm 230 STYLECODE 38
query /searchresults.cfm 231 RESERVED 38
query /searchresults.cfm 231 ONHAND 38
query /searchresults.cfm 231 KIT_AVAILABLE 1
query /searchresults.cfm 237 WEIGHT 38
query /searchresults.cfm 238 LARGEPACKAGE 38
query /searchresults.cfm 238 largepackage 38
query /searchresults.cfm 242 PRICE 38
query /searchresults.cfm 243 PRICE 38
arguments /wilsonlib.cfm 3 INPUTSTR 1
variables /wilsonlib.cfm 3 STR 1
variables /wilsonlib.cfm 5 STR 1
variables /wilsonlib.cfm 8 STR 1
variables /wilsonlib.cfm 11 STR 1
variables /wilsonlib.cfm 14 STR 1
variables /wilsonlib.cfm 17 STR 1
arguments /wilsonlib.cfm 25 STR 117
arguments /wilsonlib.cfm 33 STR 3498
arguments /wilsonlib.cfm 34 STR 3381
arguments /wilsonlib.cfm 41 STR 40
arguments /wilsonlib.cfm 42 STR 3
arguments /wilsonlib.cfm 43 STR 3
arguments /wilsonlib.cfm 57 STR 82
arguments /wilsonlib.cfm 58 STR 82
arguments /wilsonlib.cfm 62 STR 234
arguments /wilsonlib.cfm 63 STR 117


SQL Queries

getwebclass (Datasource=kelcodbpsql, Time=1.23 ms, Records=1) in /var/www/html/kelcomaine/searchresults.cfm
SELECT classpagetext, classtitle FROM web_class WHERE "webclass" = 'RPP';
getitemwebbrowse (Datasource=kelcodbpsql, Time=1.05 ms, Records=3) in /var/www/html/kelcomaine/getitemwebbrowse.cfm
the following colum(s) are never read within the request:url,picfile,thumb
SELECT
     webdescription,
     pagetitle,
     picfile,
     thumb,
     url
   FROM web_itempage LEFT OUTER JOIN item_webimages ON web_itempage.picfile = item_webimages.itemn, web_pagemaster WHERE webclass = 'RPP' and web_itempage.pageid = web_itempage.pageid and web_pagemaster.site='K';
getmenu (Datasource=kelcodbpsql, Time=0.721 ms, Records=5) in /var/www/html/kelcomaine/makemenu.cfm
the following colum(s) are never read within the request:orderseq,menu_order,pageid
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
getitemwebbrowse (Datasource=kelcodbpsql, Time=0.832 ms, Records=3) in /var/www/html/kelcomaine/getitemwebbrowse.cfm
the following colum(s) are never read within the request:picfile,thumb
SELECT
     webdescription,
     pagetitle,
     picfile,
     thumb,
     url
   FROM web_itempage LEFT OUTER JOIN item_webimages ON web_itempage.picfile = item_webimages.itemn, web_pagemaster WHERE webclass = 'RPP' and web_itempage.pageid = web_itempage.pageid and web_pagemaster.site='K';
getmenu (Datasource=kelcodbpsql, Time=1.43 ms, Records=31) in /var/www/html/kelcomaine/makemenu.cfm
the following colum(s) are never read within the request:orderseq,pageid
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
getmenu (Datasource=kelcodbpsql, Time=0.767 ms, Records=5) in /var/www/html/kelcomaine/makemenu.cfm
the following colum(s) are never read within the request:orderseq,pageid
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
getwebblock (Datasource=kelcodbpsql, Time=0.609 ms, Records=1) in /var/www/html/kelcomaine/getwebblock.cfm
select block_text from web_block where block_key='Kelco Store'
catsearch (Datasource=kelcodbpsql, Time=11.1 ms, Records=38) in /var/www/html/kelcomaine/getitemsbyclass.cfm
the following colum(s) are never read within the request:line,descbold,typeorder
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,
            ' ' AS backordermsg,
            'N' AS largepackage,
            0 AS line,
            0 AS ordered,
            'G' AS type,
            "web_stylegroup"."page_sequence" AS typeorder,
             0 AS kit_available
      FROM web_stylegroup
      WHERE "web_stylegroup"."web_class" = 'RPP'
      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,
            "item_web"."stylecode" 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_web"."backordermsg" AS backordermsg,
            "item"."largepackage" AS largepackage,
            "worderitem"."line" AS line,
            "worderitem"."ordered" AS ordered,
            "item"."type" AS type,
            '9999' AS typeorder,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available
      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" = 'RPP' AND "item"."discontinued" = 'N' AND "item"."not_for_website" = 'N'
      GROUP BY item_web.itemn, webdesc, descbold, websize, picfile1, picfile2, thumb, stylecode, price, weight, item.onhand, type, item.reserved, active, outforseason, largepackage, line, ordered, backordermsg
      ORDER BY typeorder,webdesc;
getmenu (Datasource=kelcodbpsql, Time=1.1 ms, Records=5) in /var/www/html/kelcomaine/makemenu.cfm
the following colum(s) are never read within the request:orderseq,menu_order,pageid
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


Scope Variables

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=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=&SearchClass=RPP
remote_addr=127.0.0.1
remote_host=127.0.0.1
remote_user=
request_method=GET
request_url=http://kelcomaine.com/searchresults.cfm?SearchText=&SearchClass=RPP
script_name=/searchresults.cfm
server_name=kelcomaine.com
server_port=80
server_port_secure=0
server_protocol=HTTP/1.1
server_software=
web_server_api=
Cookie Variables:
cfid=d84b8ba9-c1f4-4665-a1c0-45685ee4b84f
cftoken=0
HTTPREFERER=
initialized=1
REMOTEIP=35.173.57.202
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=d84b8ba9-c1f4-4665-a1c0-45685ee4b84f
cftoken=0
INITIALZOOM=1
lastvisit={ts '2019-09-15 08:05:23'}
MOBILEMODE=false
SCREENHEIGHT=768
SCREENWIDTH=1024
sessionid=_d84b8ba9-c1f4-4665-a1c0-45685ee4b84f_0
timecreated={ts '2019-09-15 08:05:23'}
urltoken=CFID=d84b8ba9-c1f4-4665-a1c0-45685ee4b84f&CFTOKEN=0
URL Variables:
SearchClass=RPP
SearchText=
Debug Rendering Time: 0 ms