Category Results

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.889 ms
Record Count: 0
Cached: No
Lazy: No
SQL:
SELECT
tcontent.siteid, tcontent.title, tcontent.menutitle, tcontent.restricted, tcontent.restrictgroups,
tcontent.type, tcontent.subType, tcontent.filename, tcontent.displaystart, tcontent.displaystop,
tcontent.remotesource, tcontent.remoteURL,tcontent.remotesourceURL, tcontent.keypoints,
tcontent.contentID, tcontent.parentID, tcontent.approved, tcontent.isLocked, tcontent.contentHistID,tcontent.target, tcontent.targetParams,
tcontent.releaseDate, tcontent.lastupdate,tcontent.summary,
tfiles.fileSize,tfiles.fileExt,tcontent.fileid,
tcontent.tags,tcontent.credits,tcontent.audience, tcontent.orderNo,
tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes,
tcontentstats.comments, tparent.type parentType,
tcontent.path, tcontent.created, tcontent.nextn, tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText,tcontent.changesetid
FROM
tcontent
left Join tfiles on (tcontent.fileid=tfiles.fileid)
left Join tcontentstats on (tcontent.contentid=tcontentstats.contentid
and tcontent.siteid=tcontentstats.siteid)
Left Join tcontent tparent on (tcontent.parentid=tparent.contentid
and tcontent.siteid=tparent.siteid
and tparent.active=1)
Left Join tcontentfilemetadata on (tcontent.fileid=tcontentfilemetadata.fileid
and tcontent.contenthistid=tcontentfilemetadata.contenthistid
and tcontent.siteid=tcontentfilemetadata.siteid)
WHERE
tcontent.siteid in ('default')
and tcontent.active = 1
and tcontent.Approved = 1
AND tcontent.isNav = 1
AND tcontent.moduleid = '00000000000000000000000000000000000'
AND tcontent.searchExclude = 0
AND tcontent.contentid <> '00000000000000000000000000000000001'
AND tcontent.type <>'Module'
and (
tcontent.parentid
=
'3392B216-0A1E-B89A-01AB1CD5FABB3269'
and
tcontent.subtype
=
'footnote'
)
AND (
tcontent.Display = 1
OR
(
tcontent.Display = 2
AND
(
(
tparent.type!='Calendar'
and tcontent.DisplayStart <=
{ts '2026-04-03 20:35:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 20:35:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-03 20:35:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 20:35:00'} or tcontent.DisplayStop is null)
)
)
)
)
AND (
tcontent.mobileExclude is null
OR
tcontent.mobileExclude in (0,1)
)
order by
tcontent.lastUpdate desc
siteidtitlemenutitlerestrictedrestrictgroupstypesubTypefilenamedisplaystartdisplaystopremotesourceremoteURLremotesourceURLkeypointscontentIDparentIDapprovedisLockedcontentHistIDtargettargetParamsreleaseDatelastupdatesummaryfileSizefileExtfileidtagscreditsaudienceorderNoratingtotalVotesdownVotesupVotescommentsparentTypepathcreatednextnmajorVersionminorVersionlockIDlockTypeexpiresAssocFilenamedisplayIntervaldisplayfileAltTextchangesetid
Notebook
July 01, 1997

Notebook

All the news that fits from all across Russia.

Russian Genealogy
June 01, 1997

Russian Genealogy

If you have family roots in Russia, you are in good company. Between 1820 and 1992, according to INS data, some 3,512,332 individuals immigrated to the United States from Russia, most of them around the turn of the century (2.5 mn between 1897 and WWI).

Mother Russia's
June 01, 1997

Mother Russia's "Difficult Kids"

Russian folk wisdom has it that, the more difficult the child, the stronger you love him (or her). And so, in honor of International Children’s Day, this year’s first summer issue is dedicated to Russia’s difficult kids, greatly loved.

Digging up your Russian Roots
June 01, 1997

Digging up your Russian Roots

How to trace your family roots from Russia, with resource listings and interesting facts on the "waves" of Russian immigration to the US.

The Magical Land of Tuva
June 01, 1997

The Magical Land of Tuva

In this, the fourth in our series of articles on Gary and Monika Westcott's drive across Russia, the couple visits the Republic of Tuva, best known for its postage stamps and throat-singing. But the "usual" tourist attractions are not what the Westcotts were after...

The Most Privileged Class
June 01, 1997

The Most Privileged Class

For any nation, its children are its most valuable resource. For this reason, Russian Life asked Yelena Utenkova, on the occasion of International Children's Day, to look at the state of children in Russia today. She returns with a picture at once sobering and revealing.

Northern Citadel
June 01, 1997

Northern Citadel

For almost all of its 600 years, the Cyril-Belozersk Monastery guarded Russia's northern frontiers, while serving as an influential religious outpost. William Brumfield recounts the monastery's long history.

About Us

Russian Life is a publication of a 30-year-young, award-winning publishing house that creates a bimonthly magazine, books, maps, and other products for Russophiles the world over.

Latest Posts

Our Contacts

Russian Life
73 Main Street, Suite 402
Montpelier VT 05602

802-223-4955