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 2
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
find a storefind a store

Free Shipping Over $49!

login | my Account cart icon view bag