Sort by:
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] 1240 LEO Insignia, Apparel and Gifts 2019-07-29 00:00:00.0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 1 EMPTY EMPTY EMPTY SWAT Operator 19 leo-insignia-apparel-gifts-swat-operator
2 1 [empty string] [empty string] 1304 LEO Insignia, Apparel and Gifts 2019-07-29 00:00:00.0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 3 EMPTY EMPTY EMPTY Tactical Patrol Officer 24 leo-insignia-apparel-gifts-tactical-patrol-officer
3 1 [empty string] [empty string] 1286 LEO Insignia, Apparel and Gifts 2019-09-06 00:00:00.0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 5 EMPTY EMPTY EMPTY Police Sniper Qualification 29 leo-insignia-apparel-gifts-police-sniper
4 1 [empty string] [empty string] 1254 LEO Insignia, Apparel and Gifts 2019-09-06 00:00:00.0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 6 EMPTY EMPTY EMPTY Patrol Rifle Qualification 30 leo-insignia-apparel-gifts-patrol-rifle
5 1 [empty string] [empty string] 1235 LEO Insignia, Apparel and Gifts 2019-07-29 00:00:00.0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 7 EMPTY EMPTY EMPTY One Asterisk 31 leo-insignia-apparel-gifts-one-asterisk
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM myCatVars.subCategories ORDER BY sort_position ASC
Featured Items

33825 plymouth road, livonia MI 48150 |ph: (800) 794-1216|hours: M-F 10a to 8p / sat. & sun: 10a to 6p