Arcadian Shop | Outdoor Specialty Store

struct
ACTION	[empty string]
BRAND	[empty string]
CHOOSEADDRESS	[empty string]
CONFIRM	NO
CURRENTPAGE	1
Color	[empty string]
DEPT	Camp and Hike
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	camp_and_hike-health_and_safety
SUBTYP_1	EMPTY
SUBTYP_2	EMPTY
SUBTYP_3	EMPTY
Size	[empty string]
TITLE	[empty string]
TYP	Health and Safety
WEB_TAXONOMY_ID	945
mapping	/camp_and_hike-health_and_safety
waterproof	[empty string]

query

RESULTSET

query
	SUBTYP_1	WEB_URL
1	Bear Safety	camp_and_hike-health_and_safety-bear_safety
2	Camp Bathroom	camp_and_hike-health_and_safety-camp_bathroom
3	Fire Starters	camp_and_hike-health_and_safety-fire_starters
4	First Aid Supplies	camp_and_hike-health_and_safety-first_aid_supplies
5	Sun & Bug Protection	camp_and_hike-health_and_safety-sun_and_bug_protection
6	Survival	camp_and_hike-health_and_safety-survival
7	Runner's Safety	CAMP_AND_HIKE/HEALTH_AND_SAFETY/RUNNERS_SAFETY

CACHED

false

EXECUTIONTIME

SQL

SELECT subtyp_1, web_url FROM tb_web_taxonomy WHERE dept='CAMP AND HIKE' and typ='HEALTH AND SAFETY' and subtyp_1>'' and subtyp_2='EMPTY' and subtyp_1<>'EMPTY' ORDER BY sort_position

query

RESULTSET

query
	ITEMCOUNT	SUBTYP1
1	5	BEAR SAFETY
2	20	CAMP BATHROOM
3	10	FIRE STARTERS
4	17	FIRST AID SUPPLIES
5	7	RUNNERS SAFETY
6	27	SUN & BUG PROTECTION
7	16	SURVIVAL

CACHED

false

EXECUTIONTIME

SQL

SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount FROM web_all_products WHERE dept='CAMP AND HIKE' and typ='HEALTH AND SAFETY' and upper(subtyp1)<>'EMPTY' and style_id IN (75,76,78,79,80,88,90,94,99,101,103,104,106,108,109,111,113,114,115,119,445,448,449,453,455,3119,3784,3785,3798,3802,3831,3835,3877,3898,3919,3922,3924,3925,3939,4039,4089,4124,4158,4185,4188,4201,4522,4524,4527,4529,4538,7759,8386,8387,8399,8400,8450,8451,11337,13975,13977,14366,14415,14416,14418,14419,14742,15118,15333,15650,15690,15786,15926,16145,16914,17088,17109,17111,17112,17115,17116,17118,17136,17406,17688,17833,18260,19187,19240,19254,19465,19467,19619,19984,20453,20647,20648,21756,21774,21775,21778,21813,4525) GROUP BY subtyp1