Home > Clothing & Footwear > Women's Outerwear > Women's Coats and Jackets > Women's Fleece Jackets > Women's Full Zip Fleece Jackets

query

RESULTSET

query
	ACTIVE	BACKGROUNDIMAGE	CATEGORYTEMPLATE	CATEGORY_STYLE	DEPT	DLU	GOOGLEPRODUCTTAXONOMY	LONG_DESCRIPTION	LONG_DESCRIPTION_2	META_TAGS	SHORT_DESC	SHORT_DESC_ON_PAGE	SITE	SORT_POSITION	SUBTYP_1	SUBTYP_2	SUBTYP_3	TYP	WEB_TAXONOMY_ID	WEB_URL
1	1	[empty string]	[empty string]	[empty string]	Clothing & Footwear	2022-07-19 00:00:00.0	[empty string]	[empty string]	[empty string]	[empty string]	Women's Full Zip Fleece Jackets	[empty string]	1	11	Women's Coats and Jackets	Women's Fleece Jackets	Women's Full Zip Fleece Jackets	Women's Outerwear	668	womens-full-zip-fleece-jackets

CACHED

false

EXECUTIONTIME

SQL

select * from application.getWebTaxonomy where upper(web_url)=? and sort_position<>'NO'

SQLPARAMETERS

array
1	WOMENS-FULL-ZIP-FLEECE-JACKETS

query

RESULTSET

query
	web_url
1	womens-fleece-jackets

CACHED

false

EXECUTIONTIME

SQL

select web_url from application.getWebTaxonomy where upper(dept)='CLOTHING & FOOTWEAR' and upper(typ)='WOMEN''S OUTERWEAR' and upper(subtyp_1)='WOMEN''S COATS AND JACKETS' and upper(subtyp_2)='WOMEN''S FLEECE JACKETS' and subtyp_3='EMPTY'

Filters

Home > Clothing & Footwear > Women's Outerwear > Women's Coats and Jackets > Women's Fleece Jackets > Women's Full Zip Fleece Jackets

query

RESULTSET

query
	ACTIVE	BACKGROUNDIMAGE	CATEGORYTEMPLATE	CATEGORY_STYLE	DEPT	DLU	GOOGLEPRODUCTTAXONOMY	LONG_DESCRIPTION	LONG_DESCRIPTION_2	META_TAGS	SHORT_DESC	SHORT_DESC_ON_PAGE	SITE	SORT_POSITION	SUBTYP_1	SUBTYP_2	SUBTYP_3	TYP	WEB_TAXONOMY_ID	WEB_URL
1	1	[empty string]	[empty string]	[empty string]	Clothing & Footwear	2022-07-19 00:00:00.0	[empty string]	[empty string]	[empty string]	[empty string]	Women's Full Zip Fleece Jackets	[empty string]	1	11	Women's Coats and Jackets	Women's Fleece Jackets	Women's Full Zip Fleece Jackets	Women's Outerwear	668	womens-full-zip-fleece-jackets