Arcadian Shop | Outdoor Specialty Store

struct
ACTION	[empty string]
BRAND	[empty string]
CHOOSEADDRESS	[empty string]
CONFIRM	NO
CURRENTPAGE	1
Color	[empty string]
DEPT	Paddlesports
GOTO	[empty string]
KEYWORD	[empty string]
NAV_CHOOSER	home
NEW	[empty string]
ORDER	[empty string]
ORDERBY	[empty string]
PAGE	1
PAYMETHOD	CC
PERPAGE	[empty string]
PPSUCCESS	NO
PRICE	[empty string]
RATE	[empty string]
RECEIPT_NUM	[empty string]
RETURNTO	[empty string]
RETURN_TO_PAGE	[empty string]
SALE	[empty string]
SAVEDCART	NO
SHIPPING	[empty string]
SHOP	paddlesports-accessories
SUBTYP_1	EMPTY
SUBTYP_2	EMPTY
SUBTYP_3	EMPTY
Size	[empty string]
TITLE	[empty string]
TYP	Accessories
WEB_TAXONOMY_ID	609
mapping	/paddlesports-accessories
waterproof	[empty string]

query

RESULTSET

query
	SUBTYP_1	WEB_URL
1	Care & Repair	paddlesports-accessories-care_and_repair
2	Carts	paddlesports-accessories-carts
3	Clothing & Accessories	paddlesports-accessories-clothing_and_accessories
4	Dry Storage	paddlesports-accessories-dry_storage
5	Fishing	paddlesports-accessories-fishing
6	Outfitting	paddlesports-accessories-outfitting
7	Paddleboard Accessories	paddlesports-accessories-paddleboard_accessories
8	Paddles	paddlesports-accessories-paddles
9	PFDs	paddlesports-accessories-pfds
10	Racks & Storage	paddlesports-accessories-racks_and_storage
11	Safety	paddlesports-accessories-safety
12	Skirts and Cockpit Covers	paddlesports-accessories-skirts_and_cockpit_ covers

CACHED

true

EXECUTIONTIME

SQL

SELECT subtyp_1, web_url FROM tb_web_taxonomy WHERE dept='PADDLESPORTS' and typ='ACCESSORIES' and subtyp_1>'' and subtyp_2='EMPTY' and subtyp_1<>'EMPTY' ORDER BY sort_position

query

RESULTSET

query
	ITEMCOUNT	SUBTYP1
1	11	CARE & REPAIR
2	4	CARTS
3	15	CLOTHING & ACCESSORIES
4	25	DRY STORAGE
5	49	FISHING
6	45	OUTFITTING
7	10	PADDLEBOARD ACCESSORIES
8	16	PADDLES
9	29	PFDS
10	18	RACKS & STORAGE
11	5	SAFETY
12	5	SKIRTS AND COCKPIT COVERS

CACHED

false

EXECUTIONTIME

SQL

SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount FROM web_all_products WHERE dept='PADDLESPORTS' and typ='ACCESSORIES' and upper(subtyp1)<>'EMPTY' and style_id IN (23,28,29,30,31,33,34,38,386,394,477,956,957,1454,1479,1504,1645,1663,1664,1665,1668,1672,1673,1675,1677,1678,1690,1693,1702,1704,1706,1708,1709,1710,1711,1715,1720,1723,1724,1728,1729,1733,1739,2832,4030,4063,4077,4078,4494,4495,4497,4501,4503,4505,4507,4508,4510,4511,4512,4515,4516,4828,4830,4834,4835,4855,4856,5117,5118,5119,5120,5121,8345,8405,8410,8414,8444,8445,8446,8447,8452,8463,8466,8471,8473,8475,9186,9187,9189,9190,9191,9192,9193,9195,9196,9197,9200,9201,9202,9204,9273,9318,9321,9332,10999,11001,11002,11007,11009,11098,11099,11100,11101,11106,11107,11110,11111,11112,11113,11118,11121,11122,11125,11126,11127,11128,11129,11130,11131,11132,11133,11134,11135,11136,11137,11138,11139,11149,11151,11460,13897,14268,14754,14802,14803,14804,14805,15019,15025,15026,15073,15132,15272,15273,15274,15673,20,1503,1505,1662,1699,1705,1721,1727,2831,3278,5789,8363,8457,8460,9183,9320,9322,9323,9325,9326,9327,9330,9333,9335,9336,9339,11092,11093,11103,11109,11115,11119,11120,11145,11146,11148,11150,11357) GROUP BY subtyp1