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 (6141) AND pp.web='y'
				
				GROUP BY pc.super_id
				ORDER BY p2.vendor, p.mfgnum 

	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

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

	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 

		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)
		

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

						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 = 400756 
					GROUP BY pc.super_id
					

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67050 

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66799 

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

						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 = 400943 
					GROUP BY pc.super_id
					

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67050 

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66799 

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

						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 = 401014 
					GROUP BY pc.super_id
					

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67050 

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66799 

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

						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 = 400499 
					GROUP BY pc.super_id
					

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67050 

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66799 

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

						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 = 401201 
					GROUP BY pc.super_id
					

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67038 

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 74459 

			SELECT *
				FROM navigation_gillroys
			 WHERE dept_id = 66799 

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

						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 = 401185 
					GROUP BY pc.super_id
					

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67050 

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66799 

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

						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 = 412486 
					GROUP BY pc.super_id
					

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67050 

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66799 

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

						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 = 443565 
					GROUP BY pc.super_id
					

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67947 

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67196 

			SELECT *
				FROM navigation_gillroys
			 WHERE dept_id = 66807 

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

						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 = 443559 
					GROUP BY pc.super_id
					

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67055 

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 74459 

			SELECT *
				FROM navigation_gillroys
			 WHERE dept_id = 66799 

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

						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 = 443577 
					GROUP BY pc.super_id
					

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67055 

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 74459 

			SELECT *
				FROM navigation_gillroys
			 WHERE dept_id = 66799 

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

						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 = 413047 
					GROUP BY pc.super_id
					

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67050 

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66799 

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

						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 = 401130 
					GROUP BY pc.super_id
					

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67050 

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66799 

				SELECT *
				FROM navigation_gillroys
				WHERE home_subdept = 1
				ORDER BY deptname			
			

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

	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

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787