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	15-to-20
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

false

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	1	DRY STORAGE
2	5	FISHING
3	8	OUTFITTING
4	3	PADDLEBOARD ACCESSORIES
5	1	PFDS
6	3	RACKS & STORAGE
7	1	SAFETY

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 (1432,1433,1702,4503,8463,9332,11121,11135,11138,11139,17103,17383,22365,9327,9336,14871) GROUP BY subtyp1