query
RESULTSET
query
  ACTIVE BODY CONTENTID CREDITS DISPLAY DISPLAYSTART DISPLAYSTOP FILEID FILENAME NOTES PARENTID PATH RELEASEDATE SUMMARY TAGS TITLE TYPE URLTITLE
1 1 <div><a href="https://www.eblens.com/mens/browse/brand/adidas" title="Shop Mens » Shoes » adidas Products">adidas</a></div> <div><a href="https://www.eblens.com/mens/browse/brand/baws" title="Shop Mens » Shoes » Baws Products">Baws</a></div> <div><a href="https://www.eblens.com/mens/browse/brand/bkys" title="Shop Mens » Shoes » BKYS Products">BKYS</a></div> <div><a href="https://www.eblens.com/mens/browse/brand/black-pyramid" title="Shop Mens » Shoes » BLACK PYRAMID Products">BLACK PYRAMID</a></div> <div><a href="https://www.eblens.com/mens/browse/brand/bleeker-mercer" title="Shop Mens » Shoes » Bleeker &amp; Mercer Products">Bleeker &amp; Mercer</a></div> <div><a href="https://www.eblens.com/mens/browse/brand/nike" title="Shop Mens » Shoes » Born Fly Products">Nike</a></div> 4E204AA7-C214-4406-81DA045C9D555351 [empty string] 1 [empty string] [empty string] [empty string] /header-content/menu-brand-dropdowns1/mens-brand-column [empty string] 4E1314BA-9F3A-18DB-55373114ADF08C2C 00000000000000000000000000000000003,7397134B-E783-0F4A-84CCFA2B51CC188C,4E1314BA-9F3A-18DB-55373114ADF08C2C,4E204AA7-C214-4406-81DA045C9D555351 [empty string] [empty string] [empty string] Mens Brand Column Component Mens Brand Column
2 1 <div><a href="https://www.eblens.com/womens/browse/brand/adidas" title="Shop Womens » Shoes » adidas Products">adidas</a></div> <div><a href="https://www.eblens.com/womens/browse/brand/cello" title="Shop Womens » Shoes » CELLO Products">CELLO</a></div> <div><a href="https://www.eblens.com/womens/browse/brand/champion" title="Shop Womens » Shoes » Champion Products">Champion</a></div> <div><a href="https://www.eblens.com/womens/browse/brand/elite-jeans" title="Shop Womens » Shoes » ELITE JEANS Products">ELITE JEANS</a></div> <div><a href="https://www.eblens.com/womens/browse/brand/fila" title="Shop Womens » Shoes » FILA Products">FILA</a></div> <div><a href="https://www.eblens.com/womens/browse/brand/freeze" title="Shop Womens » Shoes » Freeze Products">Freeze</a></div> 4E1DBFBB-05F2-2E77-6A62E5643CDDA8B3 [empty string] 1 [empty string] [empty string] [empty string] /header-content/menu-brand-dropdowns1/womens-brand-column [empty string] 4E1314BA-9F3A-18DB-55373114ADF08C2C 00000000000000000000000000000000003,7397134B-E783-0F4A-84CCFA2B51CC188C,4E1314BA-9F3A-18DB-55373114ADF08C2C,4E1DBFBB-05F2-2E77-6A62E5643CDDA8B3 [empty string] [empty string] [empty string] Womens Brand Column Component Womens Brand Column
3 1 <p><a href="https://www.eblens.com/kids/browse/brand/adidas" title="Shop Kids » Boys Shoes » adidas Products">adidas</a></p> <p><a href="https://www.eblens.com/kids/browse/brand/champion" title="Shop Kids » Boys Shoes » Champion Products">Champion</a></p> <p><a href="https://www.eblens.com/kids/browse/brand/chinatown-market" title="Shop Kids » Boys Shoes » Chinatown Market Products">Chinatown Market</a></p> <p><a href="https://www.eblens.com/kids/browse/brand/fila" title="Shop Kids » Boys Shoes » FILA Products">FILA</a></p> <p><a href="https://www.eblens.com/kids/browse/brand/jordan" title="Shop Kids » Boys Shoes » Jordan Products">Jordan</a></p> <p><a href="https://www.eblens.com/kids/browse/brand/jordan-craig" title="Shop Kids » Boys Shoes » Jordan Craig Products">Jordan Craig</a></p> 4E1B35A5-D154-D802-382A3E9219E016D7 [empty string] 1 [empty string] [empty string] [empty string] /header-content/menu-brand-dropdowns1/kids-brand-column [empty string] 4E1314BA-9F3A-18DB-55373114ADF08C2C 00000000000000000000000000000000003,7397134B-E783-0F4A-84CCFA2B51CC188C,4E1314BA-9F3A-18DB-55373114ADF08C2C,4E1B35A5-D154-D802-382A3E9219E016D7 [empty string] [empty string] [empty string] Kids Brand Column Component Kids Brand Column
CACHED false
EXECUTIONTIME 13
SQL SELECT contentID, active, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Body, credits, display, Notes, type FROM tcontent WHERE (parentID = '4E1314BA-9F3A-18DB-55373114ADF08C2C') AND (active = 1) and display > 0 ORDER BY orderno