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] 50616 FD, EMS Insignia Apparel & Gifts 2019-08-22 00:00:00.0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 [empty string] EMPTY EMPTY EMPTY SWAT Medic 114 fd-ems-insignia-apparel-gifts-swat-medic
2 1 [empty string] [empty string] 50617 FD, EMS Insignia Apparel & Gifts 2019-08-22 00:00:00.0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 [empty string] EMPTY EMPTY EMPTY Rescue Task Force 115 fd-ems-insignia-apparel-gifts-rescue-task-force
3 1 [empty string] [empty string] 50777 FD, EMS Insignia Apparel & Gifts 2019-08-22 00:00:00.0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 [empty string] EMPTY EMPTY EMPTY Fire and EMS 116 fd-ems-insignia-apparel-gifts-fire-ems
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