EbLens | Streetwear & Sneakers I Free Shipping I All the Brands & Styles you can't find anywhere else.

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> </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> </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

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