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
|
drinkware.jpg
|
[empty string]
|
[empty string]
|
Travel & Outdoor Gear
|
2019-09-17 00:00:00.0
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
1
|
3
|
EMPTY
|
EMPTY
|
EMPTY
|
EMPTY
|
64
|
travel-and-outdoor-gear
|
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
select * from application.getWebTaxonomy where upper(web_url)=? and sort_position<>'NO' |
SQLPARAMETERS |
array
|
1 |
TRAVEL-AND-OUTDOOR-GEAR |
|