Category Results

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.817 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 09:10:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 09:10:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-02 09:10:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 09:10:00'} or tcontent.DisplayStop is null)
)
)
)
)
AND (
tcontent.mobileExclude is null
OR
tcontent.mobileExclude in (0,1)
)
order by
tcontent.lastUpdate desc
siteidtitlemenutitlerestrictedrestrictgroupstypesubTypefilenamedisplaystartdisplaystopremotesourceremoteURLremotesourceURLkeypointscontentIDparentIDapprovedisLockedcontentHistIDtargettargetParamsreleaseDatelastupdatesummaryfileSizefileExtfileidtagscreditsaudienceorderNoratingtotalVotesdownVotesupVotescommentsparentTypepathcreatednextnmajorVersionminorVersionlockIDlockTypeexpiresAssocFilenamedisplayIntervaldisplayfileAltTextchangesetid
The Controversial Composer
May 07, 2015

The Controversial Composer

The personal and professional have become increasingly intertwined in considerations of the life and work of Pyotr Ilyich Tchaikovsky. Music historian Richard Taruskin shows that this is nothing new – it all began shortly after the master composer's death.

Bears in the Caviar
May 01, 2015

Bears in the Caviar

Bears in the Caviar is a hilarious and insightful memoir by a diplomat who was “present at the creation” of US-Soviet relations. Charles Thayer headed off to Russia in 1933, calculating that if he could just learn Russian and be on the spot when the US and USSR established relations, he could make himself indispensable and start a career in the foreign service. Remarkably, he pulled it of.

Free Economic Society
May 01, 2015

Free Economic Society

The Free Economic Society was founded on June 26, 1765, promoted by several Russian aristocrats that earned the blessing of Catherine II herself.

Euphe-Putin-isms
May 01, 2015

Euphe-Putin-isms

The things people say these days when they don't say anything can be rather illuminating.

A Dangerous Woman and a Soviet Kid
May 01, 2015

A Dangerous Woman and a Soviet Kid

In which we review "A Very Dangerous Woman," by Deborah McDonald and Jeremy Dronfield; "The Complete Folktales of A.N. Afanas'ev," by Jack V. Haney; "USSR: Diary of a Perestroika Kid," by Vladimir Kozlov; "Moscow, St. Petersburg & The Golden Ring," by Masha Nordbye; and "High Society Dinners," by Yuri Lotman.

A Classic Treat
May 01, 2015

A Classic Treat

Stuffed prunes. So much more than you think they are. Luxurious and tasty, and a perfect treat for spring.

The Kryashen
May 01, 2015

The Kryashen

Neither Tatar or Russian, the Kryashen are a fascinating ethnic minority that struggles to defend its place, and identity, in southern Russia.

A Photo Bug
May 01, 2015

A Photo Bug

We catch up with a Russian émigré who has turned his love of photography and his hankering for business into one of the most successful online photo marketplaces.

A Forest Terem
May 01, 2015

A Forest Terem

Deep in a northern forest, a restless adventurer discovered a crumbling relic of a bygone era. Since then, he has been fighting against the odds to restore it.

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