For Phone Orders, call toll-free 888-337-4684 (Monday - Friday 9 am - 6 pm E.S.T)
All other inquiries, please phone 718-339-6212
FAX 718-336-5570

Become a fan

SELECT man_to_category.man_to_category_id, man_to_category.man_to_category_id as Cat_sub_id, man_to_category.man_to_category_id as Cat_Category_id, man_to_category.Group_name as sub_name, man_to_category.Group_SUB_list, man_to_category.Order_by, man.man_id, man.man_name, man.Caption as man_caption,man.auth_dealer, man.man_title,man.group_cat,man.Keywords,man.Description,man.Caption_more, Cat_sub.hide_cat_page, Cat_Category.Category_name, Cat_department.Cat_department_id, Cat_department.Department_name ,(select HTML_page from man_store where fk_man_id=man.man_id and fk_store_id = 1 limit 1) as man_HTML_page ,Product_detail.fk_product_condition_id as product_condition_id ,BLOCK_CART ,MAN_WARRANTY ,Product_detail.SKU,STOCK_TYPE_ID ,STOCK_TYPE_COLOR ,STOCK_TYPE_NAME FROM product INNER JOIN man ON product.fk_man_id = man.man_id INNER JOIN Product_to_cat_sub ON product.product_id = Product_to_cat_sub.fk_product_id INNER JOIN Cat_sub ON Cat_sub.Cat_sub_id = Product_to_cat_sub.fk_Cat_sub_id INNER JOIN Cat_Category ON Cat_sub.fk_Cat_Category_id = Cat_Category.Cat_Category_id INNER JOIN Cat_department ON Cat_Category.fk_Cat_department_id = Cat_department.Cat_department_id INNER JOIN Product_detail ON product.product_id = Product_detail.fk_product_id LEFT OUTER JOIN Product_popular ON product.product_id = Product_popular.fk_product_id LEFT OUTER JOIN product_group_to_product_id ON product.product_id = product_group_to_product_id.fk_product_id LEFT OUTER JOIN Product_group ON Product_group.Product_group_id = product_group_to_product_id.fk_product_group_id LEFT OUTER JOIN page_rank ON product.product_id = page_rank.fk_product_id inner join man_to_category on man_to_category.fk_man_id = man.man_id inner join man_to_category_details on man_to_category_details.fk_man_to_category_id = man_to_category.man_to_category_id and man_to_category_details.fk_cat_sub_id = Cat_sub.Cat_sub_id INNER JOIN stock_type ON Product_detail.fk_stock_type_id = stock_type.stock_type_id WHERE (product.is_active = 1) AND product_detail.Block_cart <> 3 and man.man_id = 502 and Cat_sub.hide_cat_page = 0 group by Cat_sub.Cat_sub_id ORDER BY man_to_category.Order_by , man_to_category.Group_name, man_to_category.man_to_category_id limit 1000

SELECT product.product_id, product.product_name, product.Model_name,man.man_id, man.man_name, man.Caption as man_caption,man.auth_dealer, man.man_title,man.group_cat,man.Keywords,man.Description,man.Caption_more, Cat_sub.Cat_sub_id, Cat_sub.sub_name, Cat_sub.hide_cat_page, Cat_Category.Cat_Category_id, (select product_name from product p where product_id=Product_detail.Free_product) as Free_product_name, (select product_kit_name from product p where product_id=Product_detail.Free_product) as Free_product_kit_name, Product_detail.Free_product as Free_product_id, Cat_Category.Category_name, Cat_department.Cat_department_id, Cat_department.Department_name, Product_group.Product_group_id, Product_group.Group_name, product_store.Price, product_store.HTML_Page,Product_detail.qty_in_stock,Product_description.caption,Product_detail.sku ,Product_detail.Product_note, Product_detail.sale_price, Product_detail.Product_note_start, Product_detail.Product_note_end, (SELECT shipping_type.shipmentDesc FROM product_shipping INNER JOIN shipping_type ON product_shipping.fk_shipping_type = shipping_type.shipping_type_id WHERE (shipping_type.stateCode IS NOT NULL) AND (shipping_type.countryCode = 'US') AND (product_shipping.fk_product_id = product.product_id) ORDER BY shipping_type.shipping_type_id DESC limit 1 ) AS shipping,page_rank.rank ,(select HTML_page from man_store where fk_man_id=man.man_id and fk_store_id = 1 limit 1) as man_HTML_page ,Product_detail.fk_product_condition_id as product_condition_id ,BLOCK_CART,MAN_WARRANTY ,Product_detail.SKU,STOCK_TYPE_ID ,STOCK_TYPE_COLOR ,STOCK_TYPE_NAME FROM product INNER JOIN Product_description ON Product_description.fk_product_id = product.product_id INNER JOIN product_store ON product_store.fk_product_id = product.product_id INNER JOIN man ON product.fk_man_id = man.man_id INNER JOIN Product_to_cat_sub ON product.product_id = Product_to_cat_sub.fk_product_id INNER JOIN Cat_sub ON Cat_sub.Cat_sub_id = Product_to_cat_sub.fk_Cat_sub_id INNER JOIN Cat_Category ON Cat_sub.fk_Cat_Category_id = Cat_Category.Cat_Category_id INNER JOIN Cat_department ON Cat_Category.fk_Cat_department_id = Cat_department.Cat_department_id INNER JOIN Product_detail ON product.product_id = Product_detail.fk_product_id LEFT OUTER JOIN Product_popular ON product.product_id = Product_popular.fk_product_id LEFT OUTER JOIN product_group_to_product_id ON product.product_id = product_group_to_product_id.fk_product_id LEFT OUTER JOIN Product_group ON Product_group.Product_group_id = product_group_to_product_id.fk_product_group_id LEFT OUTER JOIN page_rank ON product.product_id = page_rank.fk_product_id INNER JOIN stock_type ON Product_detail.fk_stock_type_id = stock_type.stock_type_id WHERE (product.is_active = 1) AND (product_store.is_active = 1) and (product_store.fk_store_id = 1) and Product_detail.Block_Search = 0 and product_detail.Block_cart <> 3 and man.man_id = 502 and Cat_sub.hide_cat_page = 0 and product_store.price > 0 ORDER BY Cat_department.ORDER_BY ,Cat_department.Cat_department_id, Cat_Category.ORDER_BY,Cat_Category.Cat_Category_id, Cat_sub.ORDER_BY,Cat_sub.Cat_sub_id, Product_group.Group_name DESC, stock_type.order_by, page_rank.rank desc, product_store.Price , product.product_name limit 1000

SELECT product.product_id, product.product_name, man.man_id, man.man_name, Cat_sub.Cat_sub_id, Cat_sub.sub_name,Cat_sub.hide_cat_page, Cat_Category.Cat_Category_id, Cat_Category.Category_name, Cat_department.Cat_department_id, Cat_department.Department_name, Product_group.Product_group_id, Product_group.Group_name, product_store.Price, Product_detail.qty_in_stock,Product_description.caption,Product_detail.Product_note, Product_detail.sale_price, Product_detail.Product_note_start, Product_detail.Product_note_end FROM product INNER JOIN Product_description ON Product_description.fk_product_id = product.product_id INNER JOIN product_store ON product_store.fk_product_id = product.product_id INNER JOIN man ON product.fk_man_id = man.man_id INNER JOIN Product_to_cat_sub ON product.product_id = Product_to_cat_sub.fk_product_id INNER JOIN Cat_sub ON Cat_sub.Cat_sub_id = Product_to_cat_sub.fk_Cat_sub_id INNER JOIN Cat_Category ON Cat_sub.fk_Cat_Category_id = Cat_Category.Cat_Category_id INNER JOIN Cat_department ON Cat_Category.fk_Cat_department_id = Cat_department.Cat_department_id INNER JOIN Product_detail ON product.product_id = Product_detail.fk_product_id LEFT OUTER JOIN Product_popular ON product.product_id = Product_popular.fk_product_id LEFT OUTER JOIN product_group_to_product_id ON product.product_id = product_group_to_product_id.fk_product_id LEFT OUTER JOIN Product_group ON Product_group.Product_group_id = product_group_to_product_id.fk_product_group_id WHERE (product.is_active = 1) AND (product_store.is_active = 1) and (product_store.fk_store_id = 1) and product_detail.Block_cart = 0 and Cat_sub.sub_name = 'Accessories' and (Cat_sub.Cat_sub_id=133) and man.man_id = 502 ORDER BY Cat_department.ORDER_BY,Cat_Category.ORDER_BY,Cat_sub.ORDER_BY,Product_group.Group_name DESC,product_store.Price ,product.product_name limit 500

select * from store_1.qry_Product_search where 1 =1 and man_id <> 286 and (Cat_sub_id in(133,300) ) and man_id in(502) ORDER BY rank desc,RATING,product_name,product_id DESC limit 500

CGI Variables: AUTH_PASSWORD= AUTH_TYPE= AUTH_USER= CERT_COOKIE= CERT_FLAGS= CERT_ISSUER= CERT_KEYSIZE= CERT_SECRETKEYSIZE= CERT_SERIALNUMBER= CERT_SERVER_ISSUER= CERT_SERVER_SUBJECT= CERT_SUBJECT= CF_TEMPLATE_PATH=E:\inetpub\Websites\healthchecksystems.com\cat\man.cfm CONTENT_LENGTH=0 CONTENT_TYPE= CONTEXT_PATH= GATEWAY_INTERFACE=CGI/1.1 HTTPS=off HTTPS_KEYSIZE= HTTPS_SECRETKEYSIZE= HTTPS_SERVER_ISSUER= HTTPS_SERVER_SUBJECT= HTTP_ACCEPT=*/* HTTP_ACCEPT_ENCODING= HTTP_ACCEPT_LANGUAGE= HTTP_CONNECTION= HTTP_COOKIE= HTTP_HOST=www1.healthchecksystems.com HTTP_REFERER= HTTP_URL= HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) LOCAL_ADDR=www1.itinscales.com PATH_INFO= PATH_TRANSLATED=E:\inetpub\Websites\healthchecksystems.com\cat\man.cfm QUERY_STRING=man_id=502&CAT_SUB_ID=133,300 REMOTE_ADDR=10.189.254.4 REMOTE_HOST=10.189.254.4 REMOTE_USER= REQUEST_METHOD=GET SCRIPT_NAME=/cat/man.cfm SERVER_NAME=www1.healthchecksystems.com SERVER_PORT=80 SERVER_PORT_SECURE=0 SERVER_PROTOCOL=HTTP/1.1 SERVER_SOFTWARE=Microsoft-IIS/8.0 WEB_SERVER_API=

Client Variables: cfid=17754537 cftoken=8871c040e9fff0a1-E0311979-03BB-496E-22625E6E5194CC6F hitcount=2 lastvisit={ts '2024-04-25 14:01:22'} remote_addr=18.117.186.92 timecreated={ts '2024-04-25 14:01:22'} urltoken=CFID=17754537&CFTOKEN=8871c040e9fff0a1-E0311979-03BB-496E-22625E6E5194CC6F&jsessionid=646C8290FF25879C9F21D19FCCA8EE80.cfusion

Session Variables: sessionid=646C8290FF25879C9F21D19FCCA8EE80.cfusion urltoken=CFID=17754537&CFTOKEN=8871c040e9fff0a1-E0311979-03BB-496E-22625E6E5194CC6F&jsessionid=646C8290FF25879C9F21D19FCCA8EE80.cfusion

For Phone Orders, call toll-free 888-337-4684 (Monday - Friday 9 am - 6 pm E.S.T) All other inquiries, please phone 718-339-6212 FAX 718-336-5570

For Phone Orders, call toll-free 888-337-4684 (Monday - Friday 9 am - 6 pm E.S.T)
All other inquiries, please phone 718-339-6212
FAX 718-336-5570