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>Do you remember the joy of a fresh pad of paper and a brand new set of colored pencils or watercolors just waiting for the moment of inspiration? At Whole Earth we have a broad selection of colored pencils and markers as well as watercolor sets and sketchbooks ready to unleash a child’s or your own creativity. You’ll also find kids’ arts and crafts sets for string art, potholder weaving, dreamcatchers, pressed flowers, embroidery and more.</p> |
F24F171F-1098-36AE-190FE3F22BC3A413 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
landing-category-page-content/category-contents/arts-and-crafts |
arts-and-crafts |
[empty string] |
arts-and-crafts |
[empty string] |
[empty string] |
983F9244-1098-36AE-190F91207B75E78E |
00000000000000000000000000000000001,756D7CF2-1098-36AE-190FB7E49A2E2255,983F9244-1098-36AE-190F91207B75E78E,F24F171F-1098-36AE-190FE3F22BC3A413 |
[empty string] |
[empty string] |
[empty string] |
arts-and-crafts |
Page |
arts-and-crafts |
|
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 = 'arts-and-crafts') AND (active = 1) AND (type='PAGE') AND ( (display = 1) or (display=2 and displaystart<='2022-07-05 05:31:52.0' and displaystop>='2022-07-05 05:31:52.0')
) |