Category Results

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.848 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-02 20:25:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 20:25:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-02 20:25:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 20:25:00'} or tcontent.DisplayStop is null)
)
)
)
)
AND (
tcontent.mobileExclude is null
OR
tcontent.mobileExclude in (0,1)
)
order by
tcontent.lastUpdate desc
siteidtitlemenutitlerestrictedrestrictgroupstypesubTypefilenamedisplaystartdisplaystopremotesourceremoteURLremotesourceURLkeypointscontentIDparentIDapprovedisLockedcontentHistIDtargettargetParamsreleaseDatelastupdatesummaryfileSizefileExtfileidtagscreditsaudienceorderNoratingtotalVotesdownVotesupVotescommentsparentTypepathcreatednextnmajorVersionminorVersionlockIDlockTypeexpiresAssocFilenamedisplayIntervaldisplayfileAltTextchangesetid
A Gogol for the 20th Century
March 01, 2003

A Gogol for the 20th Century

Nikolai Zabolotsky is one of the greatest Russian poets of modern times. Yet few outside Russia know his name.

The Cats Who Guard the Hermitage
March 01, 2003

The Cats Who Guard the Hermitage

If you think St. Petersburg's Hermitage museum is famous only for its great collections and masterpieces, you are mistaken. Meet the felines that prowl the basements.

Mysteries of Ice Fishing
March 01, 2003

Mysteries of Ice Fishing

Ice fishing in a hut, with a radio and a heated bench? Surely you must be joking! Russians have a better way.

Lost and Found in Siberia
March 01, 2003

Lost and Found in Siberia

Eleven Americans were lost in Stalin's Siberia for nearly a month before anyone even knew they were there. This is their story of survival.

What Goes Around...
March 01, 2003

What Goes Around...

For forty years, in the era of NATO and the Warsaw Pact, Russia did all it could to force a wedge between the US and its European allies. Now Putin wants to do everything he can to keep the alliance together.

Stalin's Death
March 01, 2003

Stalin's Death

On March 5, fifty years ago, one of the most awful tyrants of the 20th century, Joseph Stalin (1879-1953), died.

Boris Messerer
March 01, 2003

Boris Messerer

On April 15, 1933, Boris Messerer, a talented theatrical designer, artist, scene-painter, book designer and a man of many awards, was born.

Vladimir Vernadsky
March 01, 2003

Vladimir Vernadsky

On March 12 (February 28, old style) 140 years ago, the scientist Vladimir Vernadsky (1863-1945) was born in St. Petersburg.

Unofficially Speaking
March 01, 2003

Unofficially Speaking

A look at life after the passage of a proposed Law on the State Language.

Midwinter Fish Fest
March 01, 2003

Midwinter Fish Fest

Nothing tastes quite like fish pulled from the icy waters beneath a winter fishing hole. Here is a simple recipe for a Russian Fish Bake.

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