query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	FAMLIST	HASIMAGE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SOLD	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	UPC	URL	VENDOR_INTEGRATE_ID
1	[empty string]	LEM PRODUCTS INC	LEM PRODUCTS INC	CUTLERY	Cutlery>Fillet	[empty string]	1	79.99	0	79.99	98000-DEFAULT-l.jpg	79.99	98000-DEFAULT-m.jpg	MUNDIAL HUNTERS KIT	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	9	50-to-100	0.00	[empty string]	4 PIECE MUNDIAL HUNTER'S KIT	<p>The Hunters Kit includes all the knives you need for processing your own deer. A 3-1/4" paring knife, 5" curved boning knife, 8" steak knife and a 10" sharpening steel. The only thing you need to supply is the meat and the table.</p>	[empty string]	N	79.99	79.99	[empty string]	98000-DEFAULT-s.jpg	[empty string]	1000	099	38838	EMPTY	EMPTY	EMPTY	0	0	0	FILLET	[empty string]	lem-products-inc/4-piece-mundial-hunter-s-kit-38838	1
2	[empty string]	CAMP CHEF	Camp Chef	CUTLERY	Cutlery>Fillet	[empty string]	0	54.99	0	54.99	[empty string]	54.99	[empty string]	9 PIECE PRO KNIFE SET	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	11	50-to-100	0.00	[empty string]	9 Piece Professional Knife Set	Featuring kitchen shears, five different styles of knives, a carving fork, cutting board, and storage/carry case; this kit is a great cooking tool kit. Hardened stainless steel blades last and cut perfectly while ergonomically designed rubber handles will give you comfortable control while preparing your meal. The variety of knives and tools will have you ready whether cutting meat, veggies, bread, fruit...the list goes on.	[empty string]	N	54.99	54.99	[empty string]	[empty string]	[empty string]	1000	KSET9	153755	EMPTY	EMPTY	EMPTY	0	0	0	FILLET	[empty string]	camp-chef/9-piece-pro-knife-set-153755	1
3	[empty string]	LEM PRODUCTS INC	LEM PRODUCTS INC	CUTLERY	Cutlery>Fillet	[empty string]	1	19.99	0	19.99	98248-DEFAULT-l.jpg	19.99	98248-DEFAULT-m.jpg	MUNDIAL 6IN CURVED SEMI FLEX KNIFE	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	30	15-to-20	0.00	[empty string]	MUNDIAL 6" CURVED NARROW SEMI-STIFF KNIFE	<p>The Mundial 6" Curved Narrow Semi-Stiff Knife is perfect for separating beef, chicken, or fish from the bone.</p> <p> </p> <ul> <li>Thin, Stiff Blade: The thin, stiff blade on the boning knife allows for entry into small spaces. Stiff blades are preferred for beef and pork, while the flexible blade is ideal for chicken and fish.</li> <li>Non-Slip Grip Handle with Antimicrobial Protection: The Mundial handles are uniquely designed to minimize fatigue, muscle strain, and overall hand and arm stress during repetitive cutting or slicing tasks. The non-slip, ergonomic grip provides optimum control and performance and the antimicrobial protection guards against the growth of bacteria.</li> <li>Professional Quality: Mundial knives are sold primarily to the restaurant and meat packing industries. Their knives are made of high-carbon, stain-free steel. Due to Mundial's technology used in the manufacturing process, these knives hold an edge much longer than their competitors.</li> <li>Easier, Quicker, and Safer: A sharp, keen edge makes your cutting job easier, quicker, and safer. When it comes time to sharpen a Mundial, the job is easier because of the make-up of the steel. In no time, that razor sharp edge is back, ready to perform for you.</li> </ul>	[empty string]	N	19.99	19.99	[empty string]	98248-DEFAULT-s.jpg	[empty string]	1000	091	249743	EMPTY	EMPTY	EMPTY	0	0	0	FILLET	[empty string]	lem-products-inc/mundial-6-curved-narrow-semi-stiff-knife-249743	1
4	[empty string]	CAMP CHEF	Camp Chef	CUTLERY	Cutlery>Fillet	[empty string]	0	32.99	0	32.99	[empty string]	32.99	[empty string]	5 PIECE PRO KNIFE SET	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	5 Piece All Purpose Chef Set	Cooking in the outdoors is easier when you have the right tools. The 5 piece all-purpose chef`s set keeps the most commonly used utensils organized and ready to go all in a convenient carry case. Great for camp, RV, tailgating, and home.	[empty string]	N	32.99	32.99	[empty string]	[empty string]	[empty string]	1000	KSET5	268208	EMPTY	EMPTY	EMPTY	0	0	0	FILLET	[empty string]	camp-chef/5-piece-pro-knife-set-268208	1
5	[empty string]	LEM PRODUCTS INC	LEM PRODUCTS INC	CUTLERY	Cutlery>Fillet	[empty string]	1	79.99	0	79.99	94916-DEFAULT-l.jpg	79.99	94916-DEFAULT-m.jpg	SILVER SKIN REMOVER KNIFE SET	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	SILVERSKIN KNIFE KIT	<p>Effortlessly trim away silver skin for the best cuts! Silver skin is a thin membrane of tissue often found on venison and other game. It does not allow spices or marinades to permeate and unlike fat it will not melt away when cooked. if not removed, it may leave meat gristly and gamey. The LEM SilverSkin knife kit includes one safety glove, two blades, and purpose designed pliers to help you safely trim away silver skin so you can "eat better meat".</p> <p> </p> <ul> <li>Rugged and Precise Cutting:</li> <li>2 speeds give you complete control</li> <li>Serrated blades deliver clean, smooth cuts</li> <li>5" blades with functional blade tip gets into tight spaces or cuts large steaks with ease</li> <li>2 removable guide bars provide thickness control</li> <li>1mm guide for removing silverskin</li> <li>4mm guide for jerky cuts (bonus!)</li> </ul> <p> </p> <ul> <li>Safety:</li> <li>Blades lock into palce and release with push of button</li> <li>Soft grip over-mold design ensures a firm hold while reducing fatigue</li> <li>Pull trigger with safety lock</li> <li>6" UL rated electric cord</li> <li>Cut resistant glove</li> <li>Dishwasher Safe</li> </ul> <p> </p> <ul> <li>SilverSkin Knife:</li> <li>Kit Includes: Electric knife, 2 sets of ss blades, 2 guide bars (silverskin, jerky) pliers with hooks, cut resistant gloves and carrying case</li> <li>Dual speeds: high and low speeds for user control</li> <li>Knives and guides are dishwasher safe</li> <li>Ergonomic handle for no hand fatigue</li> <li>120 watts</li> <li>Cord length is 6', a minimum of 16 gauge is required when using an extension cord.</li> </ul> <p> </p> <ul> <li>SilverSkin Pliers:</li> <li>Ergonomic handle</li> <li>Non-slip rubber grip</li> <li>Open at rest</li> <li>Stainless Steel</li> <li>Dishwasher safe</li> </ul> <p> </p> <ul> <li>Cut Resistant Glove:</li> <li>Stainless steel fibers are woven into the glove</li> <li>Fits right or left hand</li> <li>Size Large</li> <li>Black</li> <li>Glove is cut resistant, but not poke resistant</li> <li>Machine washable</li> </ul>	[empty string]	N	79.99	79.99	[empty string]	94916-DEFAULT-s.jpg	[empty string]	1000	1475	316683	EMPTY	EMPTY	EMPTY	0	0	0	FILLET	[empty string]	lem-products-inc/silverskin-knife-kit-316683	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts442 ORDER BY sortposition asc

Cutlery

Sort By:

Items per page:

Filter