query
RESULTSET
query
  Body DisplayStart DisplayStop FileName Notes Summary Tags Title active contentID credits display fileID parentID path releaseDate type urlTitle
1 <div> <div><a href="https://www.eblens.com/mens/browse/brand/nike" title="Shop Mens » Shoes » Born Fly Products">Nike</a></div> <div><a href="https://www.eblens.com/mens/browse/brand/jordan/orderby/new-arrivals/perpage/135" title="Shop Mens » Shoes » Born Fly Products">Jordan</a></div> </div> <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/all-products/browse/orderby/new-arrivals/keyword/champion/perpage/300">Champion</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>&nbsp;</div> [empty string] [empty string] /header-content/menu-brand-dropdowns1/mens-brand-column [empty string] [empty string] [empty string] Mens Brand Column 1 4E204AA7-C214-4406-81DA045C9D555351 [empty string] 1 [empty string] 4E1314BA-9F3A-18DB-55373114ADF08C2C 00000000000000000000000000000000003,7397134B-E783-0F4A-84CCFA2B51CC188C,4E1314BA-9F3A-18DB-55373114ADF08C2C,4E204AA7-C214-4406-81DA045C9D555351 [empty string] Component Mens Brand Column
2 <div><a href="https://www.eblens.com/womens/browse/brand/nike/orderby/new-arrivals/perpage/127" title="Shop Womens » Shoes » Freeze Products">Nike</a></div> <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> <div>&nbsp;</div> [empty string] [empty string] /header-content/menu-brand-dropdowns1/womens-brand-column [empty string] [empty string] [empty string] Womens Brand Column 1 4E1DBFBB-05F2-2E77-6A62E5643CDDA8B3 [empty string] 1 [empty string] 4E1314BA-9F3A-18DB-55373114ADF08C2C 00000000000000000000000000000000003,7397134B-E783-0F4A-84CCFA2B51CC188C,4E1314BA-9F3A-18DB-55373114ADF08C2C,4E1DBFBB-05F2-2E77-6A62E5643CDDA8B3 [empty string] Component Womens Brand Column
3 <p><a href="https://www.eblens.com/kids/browse/brand/nike/orderby/new-arrivals/perpage/159" title="Shop Kids » Boys Shoes » Jordan Products">Nike</a><br /> <a href="https://www.eblens.com/kids/browse/brand/jordan" title="Shop Kids » Boys Shoes » Jordan Products">Jordan</a><br /> <a href="https://www.eblens.com/kids/browse/brand/adidas" title="Shop Kids » Boys Shoes » adidas Products">adidas</a><br /> <a href="https://www.eblens.com/kids/browse/brand/champion" title="Shop Kids » Boys Shoes » Champion Products">Champion</a><br /> <a href="https://www.eblens.com/kids/browse/brand/chinatown-market" title="Shop Kids » Boys Shoes » Chinatown Market Products">Chinatown Market</a><br /> <a href="https://www.eblens.com/kids/browse/brand/fila" title="Shop Kids » Boys Shoes » FILA Products">FILA</a><br /> <a href="https://www.eblens.com/kids/browse/brand/jordan-craig" title="Shop Kids » Boys Shoes » Jordan Craig Products">Jordan Craig</a></p> [empty string] [empty string] /header-content/menu-brand-dropdowns1/kids-brand-column [empty string] [empty string] [empty string] Kids Brand Column 1 4E1B35A5-D154-D802-382A3E9219E016D7 [empty string] 1 [empty string] 4E1314BA-9F3A-18DB-55373114ADF08C2C 00000000000000000000000000000000003,7397134B-E783-0F4A-84CCFA2B51CC188C,4E1314BA-9F3A-18DB-55373114ADF08C2C,4E1B35A5-D154-D802-382A3E9219E016D7 [empty string] Component Kids Brand Column
CACHED false
EXECUTIONTIME 0
SQL SELECT contentID, active, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Body, credits, display, Notes, type FROM application.cmsdata WHERE (parentID = '4E1314BA-9F3A-18DB-55373114ADF08C2C') AND (active = 1) and display > 0 ORDER BY orderno
find a storefind a store

Free Shipping Over $99!*

login | my Account cart icon view bag