Jay's Sporting Goods

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]	UNCLE ALS FINFOWL	Uncle Als Fin Fowl	OUTDOOR COOKING	Outdoor Cooking>Spices and Seasonings	[empty string]	1	4.99	0	4.99	103584-DEFAULT-l.jpg	4.99	103584-DEFAULT-m.jpg	4.5OZ CAJUN MOON DUST	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	NONTAX	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	10	5-AND-under	0.00	[empty string]	Cajun Moondust	<p>Cajun Moondust Seasoning and Rub adds a spicy kick to just about everything. You can use it on anything that goes on the grill or in the smoker. Cajun Moondust adds flavor to baked chicken, the daily catch and every vegetable out there. </p> <p> </p> <ul> <li>Net Wt. 4.5 oz (128g)</li> </ul>	[empty string]	N	4.99	4.99	[empty string]	103584-DEFAULT-s.jpg	[empty string]	1000	CAJUN MOON DUST	319698	EMPTY	EMPTY	EMPTY	0	0	0	SPICES AND SEASONINGS	[empty string]	uncle-als-fin-fowl/cajun-moondust-319698	1
2	[empty string]	UNCLE ALS FINFOWL	Uncle Als Fin Fowl	OUTDOOR COOKING	Outdoor Cooking>Spices and Seasonings	[empty string]	1	4.99	0	4.99	103586-DEFAULT-l.jpg	4.99	103586-DEFAULT-m.jpg	4.5OZ DAKOTA STEAK/BURGER SEASONING	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	NONTAX	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	18	5-AND-under	0.00	[empty string]	Dakota Seasoning & Rub	<p>Dakota Seasoning and Rub is your not your average seasoning salt. Use it on burgers, steaks, roasts, French fries, corn on the cob, vegetables, and scrambled eggs.</p> <p> </p> <ul> <li>Net Wt 4.5oz </li> </ul>	[empty string]	N	4.99	4.99	[empty string]	103586-DEFAULT-s.jpg	[empty string]	1000	DAKOTA SEASON	319699	EMPTY	EMPTY	EMPTY	0	0	0	SPICES AND SEASONINGS	[empty string]	uncle-als-fin-fowl/dakota-seasoning-rub-319699	1
3	[empty string]	UNCLE ALS FINFOWL	Uncle Als Fin Fowl	OUTDOOR COOKING	Outdoor Cooking>Spices and Seasonings	[empty string]	1	4.99	0	4.99	103587-DEFAULT-l.jpg	4.99	103587-DEFAULT-m.jpg	16OZ CAJUN MOON SPICY MIX	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	NONTAX	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	9	5-AND-under	0.00	[empty string]	Cajun Moon Spicy Cajun Breading	<p>Cajun Moon is not for the weak. Uncle Al amped up the heat with the addition of habanero. It is a flavorful heat that sneaks up on you. Try this one with chicken thighs, jumbo wings, and breaded chicken sandwiches or wraps.</p>	[empty string]	N	4.99	4.99	[empty string]	103587-DEFAULT-s.jpg	[empty string]	1000	CAJUN MOON 16	323644	EMPTY	EMPTY	EMPTY	0	0	0	SPICES AND SEASONINGS	[empty string]	uncle-als-fin-fowl/cajun-moon-spicy-cajun-breading-323644	1
4	[empty string]	UNCLE ALS FINFOWL	Uncle Als Fin Fowl	OUTDOOR COOKING	Outdoor Cooking>Spices and Seasonings	[empty string]	1	4.99	0	4.99	103588-DEFAULT-l.jpg	4.99	103588-DEFAULT-m.jpg	16OZ MAMAS CHICKEN MIX	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	NONTAX	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	12	5-AND-under	0.00	[empty string]	Mama's Chicken Homestyle Breading	<p>Mama’s Chicken is the go-to breading for fried chicken and pork tenderloins. Restaurants and private clubs have been using Mama’s Chicken breading for years and now you can use it in your own kitchen! Use it to fry green tomatoes, fresh zucchini, summer squash, pickles and, of course, chicken! Also known as Fin & Fowl Restaurant Mix</p>	[empty string]	N	4.99	4.99	[empty string]	103588-DEFAULT-s.jpg	[empty string]	1000	MAMAS CHICKEN 16	323645	EMPTY	EMPTY	EMPTY	0	0	0	SPICES AND SEASONINGS	[empty string]	uncle-als-fin-fowl/mama-s-chicken-homestyle-breading-323645	1
5	[empty string]	UNCLE ALS FINFOWL	Uncle Als Fin Fowl	OUTDOOR COOKING	Outdoor Cooking>Spices and Seasonings	[empty string]	1	4.99	0	4.99	103589-DEFAULT-l.jpg	4.99	103589-DEFAULT-m.jpg	16OZ ORIGINAAL CAPTAINS MIX	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	NONTAX	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	2	5-AND-under	0.00	[empty string]	Captains Catch Original Recipe Breading	<p>Captain’s Catch is a favorite among fishermen. It is a lightly seasoned, tender breading perfect for any kind of fish and is kid-approved for chicken strips. Use an egg wash to lightly bread or make a wet batter using flat, light beer.</p>	[empty string]	N	4.99	4.99	[empty string]	103589-DEFAULT-s.jpg	[empty string]	1000	CAPTAINS 16	323646	EMPTY	EMPTY	EMPTY	0	0	0	SPICES AND SEASONINGS	[empty string]	uncle-als-fin-fowl/captains-catch-original-recipe-breading-323646	1
6	[empty string]	UNCLE ALS FINFOWL	Uncle Als Fin Fowl	OUTDOOR COOKING	Outdoor Cooking>Spices and Seasonings	[empty string]	1	4.99	0	4.99	103590-DEFAULT-l.jpg	4.99	103590-DEFAULT-m.jpg	16OZ LEMON PEPPER MIX	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	NONTAX	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	11	5-AND-under	0.00	[empty string]	Island Zest Lemon Pepper Breading	<p>Island Zest Lemon Pepper Breading is Uncle Al’s favorite because it smells so good! We use the highest quality lemon pepper seasoning and marjoram to whip up this island-inspired creation. Use it on shrimp, fish, chicken and summer veggies. Try creating your own “Island Moon” mix by mixing together equal parts Island Zest and Cajun Moon for a delicious combo that amps up the zest and tones down the habenero heat.</p>	[empty string]	N	4.99	4.99	[empty string]	103590-DEFAULT-s.jpg	[empty string]	1000	ISLAND ZEST 16	323647	EMPTY	EMPTY	EMPTY	0	0	0	SPICES AND SEASONINGS	[empty string]	uncle-als-fin-fowl/island-zest-lemon-pepper-breading-323647	1
7	[empty string]	UNCLE ALS FINFOWL	Uncle Als Fin Fowl	OUTDOOR COOKING	Outdoor Cooking>Spices and Seasonings	[empty string]	1	4.99	0	4.99	103591-DEFAULT-l.jpg	4.99	103591-DEFAULT-m.jpg	16OZ BAYOUS BEST MILD CAJUN MIX	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	NONTAX	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	4	5-AND-under	0.00	[empty string]	Bayou's Best Mild Cajun Breading	<p>Bayou’s Best is the first notch on the heat scale for our Uncle Al’s lovers. It has a tad bit more cayenne than Mama’s Chicken. Uncle Al recommends using this one to spice up frog legs, fried mushrooms, onion rings or cheese sticks. You can even replace half the breadcrumbs in your favorite meatloaf or meatball recipe with Bayou’s Best Mild Cajun for a spicy kick. </p>	[empty string]	N	4.99	4.99	[empty string]	103591-DEFAULT-s.jpg	[empty string]	1000	BAYOU BEST 16	323648	EMPTY	EMPTY	EMPTY	0	0	0	SPICES AND SEASONINGS	[empty string]	uncle-als-fin-fowl/bayou-s-best-mild-cajun-breading-323648	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter