RESULTSET |
query |
|
ACTIVE |
BODY |
CONTENTID |
CREDITS |
DISPLAYSTART |
DISPLAYSTOP |
FILEID |
FILENAME |
HTMLTITLE |
KEYPOINTS |
MENUTITLE |
METADESC |
METAKEYWORDS |
PARENTID |
PATH |
RELEASEDATE |
SUMMARY |
TAGS |
TITLE |
TYPE |
URLTITLE |
1 |
1 |
<p>Need new shoelaces for your hiking boots? Want to transform a pair of regular lace up shoes into no tie shoes? We have what you’re looking for! You’ll find extra-long, durable laces for hiking boots and lace-locks for no-tie shoes. And if you’re feeling the need for some extra cushioning in your shoes, we have an assortment of insoles including heel cushions that can improve the fit, performance and comfort of your boots and shoes. You’ll also find kits for boot and shoe care and repair.</p> |
B0E8F42B-1098-36AE-190FBC3A023CFBAC |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
landing-category-page-content/category-contents/mens-shoe-accessories |
mens-shoe-accessories |
[empty string] |
mens-shoe-accessories |
[empty string] |
[empty string] |
983F9244-1098-36AE-190F91207B75E78E |
00000000000000000000000000000000001,756D7CF2-1098-36AE-190FB7E49A2E2255,983F9244-1098-36AE-190F91207B75E78E,B0E8F42B-1098-36AE-190FBC3A023CFBAC |
[empty string] |
[empty string] |
[empty string] |
mens-shoe-accessories |
Page |
mens-shoe-accessories |
|
SQL |
SELECT contentID, active, Body, METAKEYWORDS, METADESC, parentID, path, HTMLTITLE, releaseDate, FileName, Title, menuTitle, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Type, KEYPOINTS,credits
FROM tcontent
WHERE (parentID = '983F9244-1098-36AE-190F91207B75E78E') and (urltitle = 'mens-shoe-accessories') AND (active = 1) AND (type='PAGE') AND ( (display = 1) or (display=2 and displaystart<='2022-07-05 03:57:57.0' and displaystop>='2022-07-05 03:57:57.0')
) |