SELECT p.sku, p.mfgnum, p.name, p.vendor, p.vendornum, p.desc24mf, p.description, p.image_file, p.image_width, p.image_height, p.keywords, p.short_desc, p.weight, p.mult, p.uofm, p.oversize, p.addl_handling, m.*, pc.*, pp.*, pd.dept_id
	from (((product p INNER JOIN parent_child pc ON p.sku=pc.super_id) INNER JOIN product_price pp ON p.sku=pp.sku) LEFT OUTER JOIN product_meta m ON p.sku=m.sku) LEFT OUTER JOIN product_dept pd ON p.sku = pd.sku
	where p.sku = 343186
	ORDER BY p.mfgnum

		SELECT d.* from dept d, product_dept pd where pd.sku = 343186 AND pd.dept_id = d.dept_id
	

		SELECT * 
			FROM dept 
		 WHERE dept_id = 67069 

	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 *
						FROM dept
						WHERE dept_id = 76926 

						SELECT *
						FROM dept
						WHERE dept_id = 71005 

						SELECT *
						FROM navigation_gillroys
						WHERE dept_id = 71005 

						SELECT p.sku, p.name, p.mult, bs.rank, pp.*, pc.*, COUNT(pc.sku) AS skucount, d.*, pd.*
							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 product_bestseller bs ON p.sku=bs.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id
							WHERE d.dept_id = 67069
								AND pp.web = 'y'
								AND pc.super_id <> 343186
							GROUP BY pc.super_id
							ORDER by bs.rank
							LIMIT 6
						

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

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

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67069 

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 76926 

			SELECT *
				FROM navigation_gillroys
			 WHERE dept_id = 71005 

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

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

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67069 

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 76926 

			SELECT *
				FROM navigation_gillroys
			 WHERE dept_id = 71005 

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

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

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67069 

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 76926 

			SELECT *
				FROM navigation_gillroys
			 WHERE dept_id = 71005 

							SELECT p.desc24mf, p.mfgnum, p.mult, p.name, p.sku, p.vendor, p.weight, p.uofm, pp.*, pc.*
								FROM (product p INNER JOIN parent_child pc ON p.sku=pc.sku) INNER JOIN product_price pp ON p.sku=pp.sku
							 WHERE pc.super_id = 343186
							 	 AND pp.web = 'y'
						ORDER BY p.mfgnum
						

 
 	SELECT p.sku, p.name, p.description, p.vendor, p.desc24mf, p.image_file, p.image_width, p.image_height, p.mfg, pp.*, pc.*, d.*, pd.*
		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
	 WHERE p.sku=438049 

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

		SELECT pp.*, pc.*, COUNT(pc.super_id) AS skucount
			FROM product_price pp INNER JOIN parent_child pc ON pp.sku=pc.sku
		 WHERE pc.super_id = 438049 
	GROUP BY pc.super_id
	

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67879 

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 67139