Broan-Nutone Products in Gillroys.com Broan-Nutone Online Store - Buy Broan-Nutone Products in our Broan-Nutone Online Shop

Broan-Nutone Products in Gillroys.com Broan-Nutone Online Store

Click here for 131 Items ON SALE

Browse What We Got!

Brands That We Got!

Shop by Brand


Search What We Got!

Enter a keyword to search

How To Do It!

Faucet: Leaks Water

More DIY Projects...

Gillroys Newsletter Signup

home > shop by brand > Broan-Nutone Products

Broan-Nutone Products Online Store

Page 1 of 1 | Pages: 1

Products made by: Broan-Nutone

There are 12 Broan-Nutone Products

DUCTFREE MICROTEK FILTER

Broan-Nutone
No. 41F
DUCTFREE MICROTEK FILTER

DUCTFREE MICROTEK FILTER: Broan-Nutone Products in Gillroys.com Broan-Nutone Online Store - Buy Broan-Nutone Products in our Broan-Nutone Online Shop

List Price:
$13.49

VIEW DETAILS

SKU 264635

Item 1

BLACK ROOF CAP

Broan-Nutone
No. 634
BLACK ROOF CAP

BLACK ROOF CAP: Broan-Nutone Products in Gillroys.com Broan-Nutone Online Store - Buy Broan-Nutone Products in our Broan-Nutone Online Shop

List Price:
$33.49

VIEW DETAILS

SKU 265162

Item 2

BLACK ROOF VENT CAP

Broan-Nutone
No. 636
BLACK ROOF VENT CAP

BLACK ROOF VENT CAP: Broan-Nutone Products in Gillroys.com Broan-Nutone Online Store - Buy Broan-Nutone Products in our Broan-Nutone Online Shop

List Price:
$16.49

VIEW DETAILS

SKU 261567

Item 3

BLACK WALL CAP

Broan-Nutone
No. 639
BLACK WALL CAP

BLACK WALL CAP: Broan-Nutone Products in Gillroys.com Broan-Nutone Online Store - Buy Broan-Nutone Products in our Broan-Nutone Online Shop

List Price:
$21.49

VIEW DETAILS

SKU 265135

Item 4

NY & NV ALUMINUM FILTER

Broan-Nutone
No. BP29
NY & NV ALUMINUM FILTER

NY & NV ALUMINUM FILTER: Broan-Nutone Products in Gillroys.com Broan-Nutone Online Store - Buy Broan-Nutone Products in our Broan-Nutone Online Shop

List Price:
$7.29

VIEW DETAILS

SKU 266447

Item 5

QT DUCTED FILTER

Broan-Nutone

List Price:
$9.79

Sizes & Variations

Item 6

ALLURE DUCTED FILTER

Broan-Nutone

List Price:
$28.99

Sizes & Variations

Item 7

30 IN WHITE CONVERTIBLE RANGE HOOD

Broan-Nutone

List Price:
$64.99

Sizes & Variations

Item 8

RANGE HOOD FILTER

Broan-Nutone
No. FKM65MP
RANGE HOOD FILTER

RANGE HOOD FILTER: Broan-Nutone Products in Gillroys.com Broan-Nutone Online Store - Buy Broan-Nutone Products in our Broan-Nutone Online Shop

List Price:
$7.29

VIEW DETAILS

SKU 276391

Item 9

30 IN WHITE RANGE HOOD

Broan-Nutone

List Price:
$57.99

Sizes & Variations

Item 10

30 IN DUCT FREE WHITE RANGE HOOD

Broan-Nutone

List Price:
$41.99

Sizes & Variations

Item 11

30 IN WHITE QUIET RANGE HOOD

Broan-Nutone

List Price:
$134.99

Sizes & Variations

Item 12

Page 1 of 1 | Pages: 1

Email this page to a friend


	Home	Customer Care	Newsletter	About Us	UPS Order Tracking	Shopping Cart

Broan-Nutone Products in Gillroys.com Broan-Nutone Online Store - Buy Broan-Nutone Products in our Broan-Nutone Online Shop

Building Materials

Ceiling Tile & Grids : Dowel Rods : Driveway Coatings & Concrete Sealants : Insulation & House Wrap : Kids Build it Yourself Kits : Mortar & Cement : Plastic Sheeting & Vapor Barriers : More...

Electrical

Antenna Wire & Fittings : Connectors : Doorbells & Push Buttons : Electrical Boxes & Connectors : Electrical Conduit : Electrical Tape : Electrical Tools : Extension Cord Holders : Extension Cords : Ground Rods : More...

Hand Tools

Axes & hatchets : Bolt taps and dies : Buffing wheels and compound : Carpet stretchers and linoleum rollers : Chisels : Drywall tools : Files and rasps : Gear puller : Hand Drills : Jointers & Rakers : More...

Hardware

Cabinet hardware : Door Hardware : Door Springs : Hinges : Metal Sheets : More...

Housewares

Curtain Rods and accessories : Vacuums & Accessories : More...

Lawn and Garden

Fencing & Gates : Flags & Flag Pole Accessories : Lawn Ornaments : More...

Paint and Supplies

Adhesives & Caulk : Patching & Drywall Compound : Stencils - Letters & Numbers : Wood Filler & Putty : More...

Plumbing

Boiler Drains : Copper Fittings : Drain Fittings : Garbage Disposers : Septic Tank Product : Washing Machine Outlet Boxes : Washing Machine Valves : Water Heaters : Water Meters : Water Softener & Filters : More...

Power Tools

Air Compressors & Air Tools : Battery Packs & Chargers : Bench Grinders : Cordless Tool Combos : Cords : Drill Presses : Generators : Grinders & Sanders : Grinding Wheels & Stones : Propane Torches & Accessories : More...

Website hosted and developed by

Debugging Information

ColdFusion Server Standard	7,0,2,142559
Template	/products/brandsearch.cfm
Time Stamp	05-Dec-08 01:10 AM
Locale	English (US)
User Agent	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP	38.103.63.55
Host Name	38.103.63.55

Execution Time

Total Time	Avg Time	Count	Template
1318 ms	1318 ms	1	/home/gilluser/public_html/products/brandsearch.cfm
875 ms	875 ms	1	/home/gilluser/public_html/common/masterfooter.cfm
865 ms	96 ms	9	/home/gilluser/public_html/inc_subsubdept_list.cfm
777 ms	13 ms	61	/home/gilluser/public_html/products/dept_url.cfm
206 ms	17 ms	12	/home/gilluser/public_html/products/prod_url.cfm
49 ms	49 ms	1	/home/gilluser/public_html/common/masterheader.cfm
47 ms	47 ms	1	/home/gilluser/public_html/common/sidenav.cfm
3 ms	3 ms	1	/home/gilluser/public_html/products/Application.cfm
2 ms	2 ms	1	/home/gilluser/public_html/Application.cfm
0 ms	0 ms	1	/home/gilluser/public_html/common/copyright.cfm
0 ms	0 ms	1	/home/gilluser/public_html/common/language_english.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1321 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

getprods (Datasource=gillroys, Time=32ms, Records=12) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

 
			SELECT p2.vendor, p.desc24mf, p2.vendornum, p2.sku, p2.name, p.image_file, p.image_height, p.image_width, p.mfg, p.mult, p.uofm, p.short_desc, p.description, p.mfgnum, pp.*, pc.*, COUNT(pc.sku) AS skucount, d.*, pd.*
				FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.super_id=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
				WHERE p.vendornum IN (5543) AND pp.web='y'
				
				GROUP BY pc.super_id
				ORDER BY p2.vendor, p.mfgnum

getsaleitems_sn (Datasource=gillroys, Time=1ms, Records=131, Cached Query) in /home/gilluser/public_html/common/sidenav.cfm @ 01:10:19.019

	SELECT p.sku, p.name, p.description, p.vendor, p.desc24mf, p.image_file, p.image_width, p.image_height, p.mfg, p.mult, p.uofm, pp.*, pc.* 
		FROM ((((product p INNER JOIN product_price pp ON p.sku=pp.sku) INNER JOIN parent_child pc ON p.sku=pc.sku) INNER JOIN product_dept pd ON p.sku=pd.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id
	 WHERE pp.web="y" AND now()>=pp.sale_start AND now()<=pp.sale_end 
	  AND pp.sale_price < pp.list_price 
GROUP BY pc.super_id
ORDER BY pp.sale_price

dept (Datasource=gillroys, Time=8ms, Records=26) in /home/gilluser/public_html/common/sidenav.cfm @ 01:10:19.019

	SELECT *
		FROM navigation_gillroys
	 WHERE subdept = 0 OR dept_id =5
	ORDER BY deptname

bsbrands (Datasource=gillroys, Time=0ms, Records=20, Cached Query) in /home/gilluser/public_html/common/sidenav.cfm @ 01:10:19.019

	SELECT bs.*, p.mfg, p.vendornum, p.vendor, p.mfgnum 
		FROM product p inner join product_bestseller bs on p.sku=bs.sku 
ORDER BY bs.rank 
	 LIMIT 20

get_howto (Datasource=gillroys, Time=35ms, Records=1) in /home/gilluser/public_html/common/sidenav.cfm @ 01:10:19.019

		SELECT b.*, i.*, c.* 
			FROM (howto_body b INNER JOIN howto_cat_index i ON b.id=i.id) INNER JOIN howto_cat c ON i.cat=c.id  
		 WHERE (b.id=102 AND i.cat=100)
		 		OR (b.id=202 AND i.cat=200) 
				OR (b.id=302 AND i.cat=300) 
				OR (b.id=402 AND i.cat=400)
				OR (b.id=502 AND i.cat=500) 
				OR (b.id=602 AND i.cat=600) 
				OR (b.id=702 AND i.cat=700) 
				OR (b.id=802 AND i.cat=800)

subdept (Datasource=gillroys, Time=5ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT d.* from dept d where d.dept_id = 66795

countskus (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT pp.*, pc.*, COUNT(pc.super_id) AS skucount
							FROM product_price pp INNER JOIN parent_child pc ON pp.sku=pc.sku
						 WHERE pp.web="y" AND pc.super_id = 264635 
					GROUP BY pc.super_id

getsubdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67245

get_nav (Datasource=gillroys, Time=8ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66795

subdept (Datasource=gillroys, Time=5ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT d.* from dept d where d.dept_id = 66799

countskus (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT pp.*, pc.*, COUNT(pc.super_id) AS skucount
							FROM product_price pp INNER JOIN parent_child pc ON pp.sku=pc.sku
						 WHERE pp.web="y" AND pc.super_id = 265162 
					GROUP BY pc.super_id

getsubdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 70929

get_nav (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66799

subdept (Datasource=gillroys, Time=5ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT d.* from dept d where d.dept_id = 66799

countskus (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT pp.*, pc.*, COUNT(pc.super_id) AS skucount
							FROM product_price pp INNER JOIN parent_child pc ON pp.sku=pc.sku
						 WHERE pp.web="y" AND pc.super_id = 261567 
					GROUP BY pc.super_id

getsubdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 70929

get_nav (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66799

subdept (Datasource=gillroys, Time=5ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT d.* from dept d where d.dept_id = 66799

countskus (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT pp.*, pc.*, COUNT(pc.super_id) AS skucount
							FROM product_price pp INNER JOIN parent_child pc ON pp.sku=pc.sku
						 WHERE pp.web="y" AND pc.super_id = 265135 
					GROUP BY pc.super_id

getsubdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 70929

get_nav (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66799

subdept (Datasource=gillroys, Time=5ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT d.* from dept d where d.dept_id = 66795

countskus (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT pp.*, pc.*, COUNT(pc.super_id) AS skucount
							FROM product_price pp INNER JOIN parent_child pc ON pp.sku=pc.sku
						 WHERE pp.web="y" AND pc.super_id = 266447 
					GROUP BY pc.super_id

getsubdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67245

get_nav (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66795

subdept (Datasource=gillroys, Time=5ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT d.* from dept d where d.dept_id = 66795

countskus (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT pp.*, pc.*, COUNT(pc.super_id) AS skucount
							FROM product_price pp INNER JOIN parent_child pc ON pp.sku=pc.sku
						 WHERE pp.web="y" AND pc.super_id = 285633 
					GROUP BY pc.super_id

getsubdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67245

get_nav (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66795

subdept (Datasource=gillroys, Time=5ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT d.* from dept d where d.dept_id = 66795

countskus (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT pp.*, pc.*, COUNT(pc.super_id) AS skucount
							FROM product_price pp INNER JOIN parent_child pc ON pp.sku=pc.sku
						 WHERE pp.web="y" AND pc.super_id = 285668 
					GROUP BY pc.super_id

getsubdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67245

get_nav (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66795

subdept (Datasource=gillroys, Time=5ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT d.* from dept d where d.dept_id = 66795

countskus (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT pp.*, pc.*, COUNT(pc.super_id) AS skucount
							FROM product_price pp INNER JOIN parent_child pc ON pp.sku=pc.sku
						 WHERE pp.web="y" AND pc.super_id = 281190 
					GROUP BY pc.super_id

getsubdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67245

get_nav (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66795

subdept (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT d.* from dept d where d.dept_id = 66795

countskus (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT pp.*, pc.*, COUNT(pc.super_id) AS skucount
							FROM product_price pp INNER JOIN parent_child pc ON pp.sku=pc.sku
						 WHERE pp.web="y" AND pc.super_id = 276391 
					GROUP BY pc.super_id

getsubdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67245

get_nav (Datasource=gillroys, Time=7ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66795

subdept (Datasource=gillroys, Time=11ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT d.* from dept d where d.dept_id = 66795

countskus (Datasource=gillroys, Time=12ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT pp.*, pc.*, COUNT(pc.super_id) AS skucount
							FROM product_price pp INNER JOIN parent_child pc ON pp.sku=pc.sku
						 WHERE pp.web="y" AND pc.super_id = 265019 
					GROUP BY pc.super_id

getsubdept (Datasource=gillroys, Time=22ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67245

get_nav (Datasource=gillroys, Time=70ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66795

subdept (Datasource=gillroys, Time=13ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT d.* from dept d where d.dept_id = 66795

countskus (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT pp.*, pc.*, COUNT(pc.super_id) AS skucount
							FROM product_price pp INNER JOIN parent_child pc ON pp.sku=pc.sku
						 WHERE pp.web="y" AND pc.super_id = 261068 
					GROUP BY pc.super_id

getsubdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67245

get_nav (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66795

subdept (Datasource=gillroys, Time=8ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT d.* from dept d where d.dept_id = 66795

countskus (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/brandsearch.cfm @ 01:10:19.019

						SELECT pp.*, pc.*, COUNT(pc.super_id) AS skucount
							FROM product_price pp INNER JOIN parent_child pc ON pp.sku=pc.sku
						 WHERE pp.web="y" AND pc.super_id = 285587 
					GROUP BY pc.super_id

getsubdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67245

get_nav (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/prod_url.cfm @ 01:10:19.019

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66795

get_nav (Datasource=gillroys, Time=0ms, Records=9, Cached Query) in /home/gilluser/public_html/common/masterfooter.cfm @ 01:10:19.019

				SELECT *
				FROM navigation_gillroys
				WHERE home_subdept = 1
				ORDER BY deptname

get_sub_dept (Datasource=gillroys, Time=2ms, Records=22) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 01:10:19.019

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66787
		 AND dept_display = 1
ORDER BY dept_name

GetDepts (Datasource=gillroys, Time=0ms, Records=7, Cached Query) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 01:10:19.019

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (66863,66867,66852,66851,66856,70964,66866,66850,66849,73735,66857,66864,74763,66854,66853,66855,66865,66859,77847,66861,66860,70972)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787

geturl (Datasource=gillroys, Time=7ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787

geturl (Datasource=gillroys, Time=7ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787

get_sub_dept (Datasource=gillroys, Time=1ms, Records=17) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 01:10:19.019

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66784
		 AND dept_display = 1
ORDER BY dept_name

GetDepts (Datasource=gillroys, Time=1ms, Records=10, Cached Query) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 01:10:19.019

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (66821,66810,66814,66816,66813,66818,66826,66815,66812,66825,77838,77139,66817,66819,66823,66824,66820)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=7ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=7ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 01:10:19.019