SELECT categoryname, c.categoryid, categorydescription, c.parentid, childlevel, isNull(plist.cntofchildren, 0) 'countofchildren', showanonymous, isNull(cnt, 0) AS countofproducts FROM (select * from tblprodcategories where isNull(fk_storeid, 0) in(0, 150)) c LEFT JOIN (SELECT categoryid, count(*) AS cnt FROM tblcategoryproductbridge WHERE productid in(SELECT productid FROM tblproducts WHERE discontinued = 0) group by categoryid ) cn ON c.categoryid = cn.categoryid LEFT JOIN (SELECT parentid , count(*) cntofchildren FROM (select * from tblprodcategories where isNull(fk_storeid, 0) in(0, 150)) ccount group by parentid) plist ON c.categoryid = plist.parentid WHERE c.CategoryID IN( SELECT CategoryID FROM ut_GroupCategoryPermissions WHERE GroupID IN( SELECT GroupID FROM ut_UserGroupMemberShip WHERE UserID=0 ) UNION SELECT CategoryID FROM tblCategorySecurity WHERE UserID= 0 ) OR (0 = 0 AND showanonymous = 1) order by childlevel asc, isNull(sortorder, 100000), categoryname
Copyright © 2011 Headhunter Spearfishing
At Headhunter Spearfishing, we want every customer to be 100% satisfied with their purchase.
We understand that when purchasing a new product, it may not be what you expected. Our return policy is as follows:
Headhunter Spearfishing respect and are committed to protecting your privacy. We may collect personally identifiable information when you visit our site. We also automatically receive and record information on our server logs from your browser including your IP address, cookie information and the page(s) you visited. We will not sell your personally identifiable information to anyone.
Your payment and personal information is always safe. Our Secure Sockets Layer (SSL) software is the industry standard and among the best software available today for secure commerce transactions. It encrypts all of your personal information, including credit card number, name, and address, so that it cannot be read over the internet.
All orders placed and received by 3:30pm EST will ship that same day. All orders ship via UPS Ground service. Delivery can be up to 7 -10 business days. Customers will be notified if any items are out of stock. If you have any questions regarding the shipping status of your order, please contact our customer service team; Headhunter Spearfishing c/o JM Field Marketing at 877-277-9840. Please have your order number, order date and full billing/shipping address information on hand to assist our agents in helping you.
The network of the Headhunter Spearfishing or its affiliates or subsidiaries, is comprised of various Web sites and Web pages. The Headhunter Spearfishing Web sites are offered to you conditioned on your acceptance without modification of the terms, conditions, and notices contained herein. Your use of the Headhunter Spearfishing Web Site constitutes your agreement to all such terms, conditions, and notices. Your use of a particular Headhunter Spearfishing website included within the Headhunter Spearfishing Web Sites network may also be subject to additional terms outlined elsewhere on that website (the "Additional Terms"). Additionally, the Headhunter Spearfishing Web Site may themselves contain additional terms that govern particular features or offers. In the event that any of the terms, conditions, and notices contained herein conflict with the Additional Terms or other terms and guidelines contained within any particular Headhunter Spearfishing website, then these terms shall control.
Headhunter Spearfishing reserves the right to change the terms, conditions, and notices under which the Headhunter Spearfishing Web Sites are offered, including but not limited to the charges associated with the use of the Headhunter Spearfishing Web Sites. You are responsible for regularly reviewing these terms and conditions.
Unless otherwise specified; the Headhunter Spearfishing Web Sites are for your personal and noncommercial use. You may not modify, copy, distribute, transmit, display, perform, reproduce, publish, license, create derivative works from, transfer, or sell any information, software, products or services obtained from the Headhunter Spearfishing Web Sites. You may display and, subject to any expressly stated restrictions or limitations relating to specific material, electronically copy, download and print hard copy portions of the material from the different areas of the Site solely for your own noncommercial use, or to place an order with the Headhunter Spearfishing or to purchase Headhunter Spearfishing products. Any other use of materials on this Site, including but not limited to the modification, reproduction, distribution, republication, display or transmission of the content of this Site, without prior written permission of the Headhunter Spearfishing is strictly prohibited. Harassment in any manner or form on the Site or any of the Headhunter Spearfishing Websites, including via email and chat or by obscene or abusive language is strictly forbidden. Impersonation of others, including a Headhunter Spearfishing employee, host, or representative or other members or visitors on the Site is prohibited. You may not upload to, distribute, or otherwise publish through the Site any content which is libelous, defamatory, obscene, threatening, invasive of privacy or publicity rights, abusive, illegal, or otherwise objectionable, or which may constitute or encourage a criminal offense, violate the rights of any party or otherwise give rise to liability or violate any law. You may not upload commercial content on the Site or outside of the Headhunter Spearfishing, or used for reasons beyond those contemplated in this statement. From time to time, we may engage third parties to process your information on our behalf; however, none of use the Site to solicit others to join or become members of any other commercial online service or other organization.
The entire content included in this Site, including but not limited to text, design, graphics, interfaces, or code and the selection and arrangements thereof is copyrighted as a collective work under the United States and other copyright laws, and is the property of Headhunter Spearfishing. The collective work includes works that are licensed to the Headhunter Spearfishing. Copyright (2010-2011). ALL RIGHTS RESERVED. All trademarks, service marks, and trade names (collectively the "Marks") are trademarks or registered trademarks of and are proprietary to the Headhunter Spearfishing, or other respective owners that have granted the Headhunter Spearfishing the right and license to use such Marks.
If you have a general question about any of the products seen here please contact Headhunter Spearfishing at email@example.com