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 (4352) 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 = 405191 
					GROUP BY pc.super_id
					

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67052 

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

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67052 

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66799 

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

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

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67530 

				SELECT *
					FROM navigation_gillroys
			 	 WHERE dept_id = 66796 

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

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67052 

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

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67052 

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

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67052 

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

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67052 

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

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67052 

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

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67052 

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

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67052 

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

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67052 

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

			SELECT dep