select * from application.getWebTaxonomy where upper(web_url)=? and sort_position<>'NO'
SQLPARAMETERS
array
1
LITTLE-KID-OUTERWEAR
query
RESULTSET
query
web_url
1
infant-and-toddler-clothing
CACHED
false
EXECUTIONTIME
0
SQL
select web_url from application.getWebTaxonomy where upper(dept)='CLOTHING & FOOTWEAR' and upper(typ)='KIDS' and upper(subtyp_1)='INFANT & TODDLER' and upper(subtyp_2)='CLOTHING & ACCESSORIES' and subtyp_3='EMPTY'
select * from application.getWebTaxonomy where upper(web_url)=? and sort_position<>'NO'
SQLPARAMETERS
array
1
LITTLE-KID-OUTERWEAR
query
RESULTSET
query
web_url
1
infant-and-toddler-clothing
CACHED
false
EXECUTIONTIME
0
SQL
select web_url from application.getWebTaxonomy where upper(dept)='CLOTHING & FOOTWEAR' and upper(typ)='KIDS' and upper(subtyp_1)='INFANT & TODDLER' and upper(subtyp_2)='CLOTHING & ACCESSORIES' and subtyp_3='EMPTY'