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 2021-01-28 00:00:00.0 [empty string] [empty string] Center Mass Inc offers a variety of Tactical Patrol Officer Pins, Patches, and gift items that can be customized. Visit our website to view our full selection today. Tactical patrol officer pins, tactical patrol officer patches, tactical patrol officer glasses, tactical patrol officer hats, custom gifts [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