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]	BOUNTY HUNTER	Bounty Hunter	CAMPING	Camping>Prospecting	[empty string]	1	39.99	0	39.99	41098-DEFAULT-l.jpg	39.99	41098-DEFAULT-m.jpg	NYLON CARRY BAG	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]	3	25-to-50	0.00	[empty string]	Padded Nylon Carry Bag	<p>The Padded Nylon Carry Bag will protect your metal detector from the elements, whether in storage or in transit.</p>	[empty string]	N	39.99	39.99	[empty string]	41098-DEFAULT-s.jpg	[empty string]	1000	CBAG-W	9050	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	bounty-hunter/nylon-carry-bag-9050	1
2	[empty string]	BOUNTY HUNTER	Bounty Hunter	CAMPING	Camping>Prospecting	[empty string]	1	39.99	0	39.99	54792-DEFAULT-l.jpg	39.99	54792-DEFAULT-m.jpg	STEREO HEADPHONES	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]	4	25-to-50	0.00	[empty string]	Headphones	<p>The Bounty Hunter Headphones are lightweight and adjustable with true stereo sound, adjustable volume.</p>	[empty string]	N	39.99	39.99	[empty string]	54792-DEFAULT-s.jpg	[empty string]	1000	HEAD-W	9051	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	bounty-hunter/stereo-headphones-9051	1
3	[empty string]	BOUNTY HUNTER	Bounty Hunter	CAMPING	Camping>Prospecting	[empty string]	1	169.99	0	169.99	54794-DEFAULT-l.jpg	169.99	54794-DEFAULT-m.jpg	QUICK SILVER DETECTOR	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]	2	150-to-200	0.00	[empty string]	Quick Silver	<p>The Quick Silver Metal Detector is designed with such features as three tone audio feedback and push button discrimination for easy detecting of coins, jewelry and whatever else your hunt digs up.</p>	[empty string]	N	169.99	169.99	[empty string]	54794-DEFAULT-s.jpg	[empty string]	1000	QSI	9054	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	bounty-hunter/quick-silver-detector-9054	1
4	[empty string]	BOUNTY HUNTER	Bounty Hunter	CAMPING	Camping>Prospecting	[empty string]	1	39.99	0	39.99	54795-DEFAULT-l.jpg	39.99	54795-DEFAULT-m.jpg	POUCH TROWEL COMBO	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]	4	25-to-50	0.00	[empty string]	Pouch And Digger Combo	<p>The Pouch and Digging Trowel Tool Kit is a very useful item for treasure hunters everywhere!</p>	[empty string]	N	39.99	39.99	[empty string]	54795-DEFAULT-s.jpg	[empty string]	1000	TP-KIT-W	9058	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	bounty-hunter/pouch-trowel-combo-9058	1
5	[empty string]	GARRETT	GARRETT	CAMPING	Camping>Prospecting	[empty string]	0	59.99	0	59.99	[empty string]	59.99	[empty string]	DLX GOLD PANNING 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]	12	50-to-100	0.00	[empty string]	Deluxe Gold Pan Kit	KIT INCLUDES:<br/> -14`` Gold Trap pan<br/> -15`` SuperSluice pan<br/> -14`` Sifter/Classifier<br/> -10`` Backpacker pan<br/> -Gold Guzzler bottle<br/> -2 Gold vials<br/> -Tweezers/magnifier<br/> -How to Find Gold field guide by Charles Garrett and Roy Lagal<br/> -Gold Panning Like a Pro DVD (featuring Freddy Dodge)<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	59.99	59.99	[empty string]	[empty string]	[empty string]	1000	1651410	53836	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	garrett/dlx-gold-panning-kit-53836	1
6	[empty string]	BOUNTY HUNTER	Bounty Hunter	CAMPING	Camping>Prospecting	[empty string]	1	99.99	0	99.99	41099-DEFAULT-l.jpg	99.99	41099-DEFAULT-m.jpg	GOLD DIGGER DETECTOR	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]	3	50-to-100	0.00	[empty string]	Gold Digger	<p>The Gold Digger Metal Detector will find all different types of metals from iron relics, coins and household items to precious metals like silver and gold. It also comes complete with headphones and 1/8`` headphone jack to allow more privacy when treasure seeking.</p>	[empty string]	N	99.99	99.99	[empty string]	41099-DEFAULT-s.jpg	[empty string]	1000	GOLD	95806	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	bounty-hunter/gold-digger-detector-95806	1
7	[empty string]	GARRETT	GARRETT	CAMPING	Camping>Prospecting	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	SAND SCOOP	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]	10	20-to-25	0.00	[empty string]	Plastic Sand Scoop	<p>Garrett`s Plastic Sand Scoop is durable and ideal for sifting.</p>	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	1600971	122854	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	garrett/sand-scoop-122854	1
8	[empty string]	GARRETT	GARRETT	CAMPING	Camping>Prospecting	[empty string]	0	669.99	0	669.99	[empty string]	669.99	[empty string]	AT PRO METAL DETECTOR	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]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	2	500-or-more	0.00	[empty string]	At Pro	<p>Using Garrett`s exclusive technology, this all-terrain detector, with enhanced audio features and a choice of Standard or Professional search modes makes it highly recommended for Coin Hunting, Jewelry Hunting, Relic Hunting, Cache Hunting, Prospecting, Ghost Town Hunting, Competition Events, and Beach/Fresh Water Hunting.</p>	[empty string]	N	669.99	669.99	[empty string]	[empty string]	[empty string]	1000	1140460	125333	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	garrett/at-pro-metal-detector-125333	1
9	[empty string]	BOUNTY HUNTER	Bounty Hunter	CAMPING	Camping>Prospecting	[empty string]	1	69.99	0	69.99	41096-DEFAULT-l.jpg	69.99	41096-DEFAULT-m.jpg	JUNIOR METAL DETECTOR	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]	4	50-to-100	0.00	[empty string]	Junior Metal Detector	<p>FEATURES:<br /> -Extends to 2 1/4`<br /> -Discrimination control to eliminate unwanted items<br /> -Volume proportional to signal strength<br /> -Compact, ergonomic design<br /> -For ages as young as 6 year old</p>	[empty string]	N	69.99	69.99	[empty string]	41096-DEFAULT-s.jpg	[empty string]	1000	BHJS	127668	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	bounty-hunter/junior-metal-detector-127668	1
10	[empty string]	GARRETT	GARRETT	CAMPING	Camping>Prospecting	[empty string]	0	749.99	0	749.99	[empty string]	749.99	[empty string]	AT GOLD DETECTOR	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]	1	500-or-more	0.00	[empty string]	At Gold	<p>The AT Gold features a 5`` x 8`` PROformance submersible searchcoil and The Garrett MasterSound headphones for not only superior finds but also unmistakable sounds when you`ve found something valuable. Not only that but it`s also uniquely submersible up to 10 feet or 3 meters. The AT Gold is highly recommended for prospecting, coin, jewelry, cache hunting, relic hunting, organized hunts and shallow fresh water hunting.</p>	[empty string]	N	749.99	749.99	[empty string]	[empty string]	[empty string]	1000	1140680	171509	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	garrett/at-gold-detector-171509	1
11	[empty string]	GARRETT	GARRETT	CAMPING	Camping>Prospecting	[empty string]	0	149.99	0	149.99	[empty string]	149.99	[empty string]	PRO POINTER AT	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]	10	100-to-150	0.00	[empty string]	Pro Pointer At	<p>Combining performance with sleek design, the Pro Pointer assists in pinpointing those hard-to-find targets. With One-Touch ease of use, you will never want to be in the field without one.</p>	[empty string]	N	149.99	149.99	[empty string]	[empty string]	[empty string]	1000	1140900	247860	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	garrett/pro-pointer-at-247860	1
12	[empty string]	BOUNTY HUNTER	Bounty Hunter	CAMPING	Camping>Prospecting	[empty string]	0	299.99	0	299.99	[empty string]	299.99	[empty string]	QUICK DRAW PRO DETECTOR	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]	2	250-to-300	0.00	[empty string]	Quick Draw Ii	<p>The Quick Draw II is designed with features such as a digital coin depth indicator to have you finding your treasure with more accuracy and ease.</p>	[empty string]	N	299.99	299.99	[empty string]	[empty string]	[empty string]	1000	PROQD	247950	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	bounty-hunter/quick-draw-pro-detector-247950	1
13	[empty string]	GARRETT	GARRETT	CAMPING	Camping>Prospecting	[empty string]	0	419.99	0	419.99	[empty string]	419.99	[empty string]	ACE 400	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	NOT ONLINE	[empty string]	[empty string]	4	400-to-450	0.00	[empty string]	Ace 400	<p>The king of ACEs, the ACE 400 includes advanced features like Iron Audio, Digital Target ID, and Frequency Adjust to help you dig more treasure and less trash.</p>	[empty string]	N	419.99	419.99	[empty string]	[empty string]	[empty string]	1000	1141260	266609	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	garrett/ace-400-266609	1
14	[empty string]	GARRETT	GARRETT	CAMPING	Camping>Prospecting	[empty string]	0	299.99	0	299.99	[empty string]	299.99	[empty string]	ACE 300	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]	3	250-to-300	0.00	[empty string]	Ace 300	Garrett has placed big features into the ACE 300—Digital Target ID, better detection abilities, a new audio system, and more—for a price that can`t be beat.<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	299.99	299.99	[empty string]	[empty string]	[empty string]	1000	1141150	266612	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	garrett/ace-300-266612	1
15	[empty string]	GARRETT	GARRETT	CAMPING	Camping>Prospecting	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	MASTER SOUND II HEADPHONES	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Master Sound Ii Headphones	[empty string]	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	1627300	288450	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	garrett/master-sound-ii-headphones-288450	1
16	[empty string]	BOUNTY HUNTER	Bounty Hunter	CAMPING	Camping>Prospecting	[empty string]	0	249.99	0	249.99	[empty string]	249.99	[empty string]	QUICK DRAW II PRO DETECTOR W/BAG/POINTER	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]	1	200-to-250	0.00	[empty string]	Quick Draw Ii Pro Detector W/bag/pointer	[empty string]	[empty string]	N	249.99	249.99	[empty string]	[empty string]	[empty string]	1000	QD2GWP	317839	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	bounty-hunter/quick-draw-ii-pro-detector-w-bag-pointer-317839	1
17	[empty string]	GARRETT	GARRETT	CAMPING	Camping>Prospecting	[empty string]	0	12.99	0	12.99	[empty string]	12.99	[empty string]	COIL COVER 5X8	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]	2	10-to-15	0.00	[empty string]	Coil Cover 5x8	[empty string]	[empty string]	N	12.99	12.99	[empty string]	[empty string]	[empty string]	1000	1607400	322213	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	garrett/coil-cover-5x8-322213	1
18	[empty string]	GARRETT	GARRETT	CAMPING	Camping>Prospecting	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	PROPOINTER HOLSTER	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]	2	25-to-50	0.00	[empty string]	Propointer Holster	[empty string]	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	G409	322537	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	garrett/propointer-holster-322537	1
19	[empty string]	BOUNTY HUNTER	Bounty Hunter	CAMPING	Camping>Prospecting	[empty string]	0	169.99	0	169.99	[empty string]	169.99	[empty string]	QUICK SILVER DETECTOR W/PRO POINTER	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Quick Silver Detector W/pro Pointer	[empty string]	[empty string]	N	169.99	169.99	[empty string]	[empty string]	[empty string]	1000	QSIGWP	339809	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	bounty-hunter/quick-silver-detector-w-pro-pointer-339809	1
20	[empty string]	GARRETT	GARRETT	CAMPING	Camping>Prospecting	[empty string]	0	579.99	0	579.99	[empty string]	579.99	[empty string]	ACE APEX WITH WIRELESS PHONES	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]	1	500-or-more	0.00	[empty string]	Ace Apex With Wireless Phones	[empty string]	[empty string]	N	579.99	579.99	[empty string]	[empty string]	[empty string]	1000	1142325	346186	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	garrett/ace-apex-with-wireless-phones-346186	1
21	[empty string]	GARRETT	GARRETT	CAMPING	Camping>Prospecting	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	METAL SAND SCOOP	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	Metal Sand Scoop	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	1600970	350873	EMPTY	EMPTY	EMPTY	0	0	0	PROSPECTING	[empty string]	garrett/metal-sand-scoop-350873	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts272 ORDER BY sortposition asc

Camping

Sort By:

Items per page:

Filter

Filter By

Price

Brand

Padded Nylon Carry Bag

Headphones

Quick Silver

Pouch And Digger Combo

Deluxe Gold Pan Kit

Gold Digger

Plastic Sand Scoop

At Pro

Junior Metal Detector

At Gold

Pro Pointer At

Quick Draw Ii

Ace 400

Ace 300

Master Sound Ii Headphones

Quick Draw Ii Pro Detector W/Bag/Pointer

Coil Cover 5x8

Propointer Holster

Quick Silver Detector W/Pro Pointer

Ace Apex With Wireless Phones

Metal Sand Scoop