The Men's Lab :: Manufacturers

INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, v_pricing.price as v_price FROM xcart_products, xcart_pricing , xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND (xcart_pricing.variantid = 0 OR (xcart_variants.variantid = xcart_pricing.variantid)) AND xcart_products.manufacturerid IN ('4') AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_products.forsale='Y' GROUP BY xcart_products.productid

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mens/public_html/include/func.php on line 102
The Men's Lab :: Manufacturers :: Jack Black

Jack Black is a line of high performance shaving, skin care, sun protection and grooming products designed exclusively for men. The unique combination of authentic ingredients and original technology offer men real solutions that go beyond soap and water. Nothing complicated, nothing cosmetic. Just superior products designed with guys in mind.

Each Jack Black product contains only the finest natural ingredients - highly efficacious, benefit oriented extracts and botanicals - discovered during our search for the finest ingredients that could be used in the "best of the best" men's products.

You'll find Jack Black in the locker room of some of America's best sports teams, plus in the hands of many professional athletes and thousands of regular guys who want to look their best.

Jack Black

There are no available products under this manufacturer.