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 = 'at-home-workout') AND (active = 1) AND (type='PAGE') AND ( (display = 1) or (display=2 and displaystart<='2023-10-03 19:40:28.0' and displaystop>='2023-10-03 19:40:28.0')
) |