Culture

Category Results

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.911 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 11:25:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 11:25:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-03 11:25:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 11:25:00'} or tcontent.DisplayStop is null)
)
)
)
)
AND (
tcontent.mobileExclude is null
OR
tcontent.mobileExclude in (0,1)
)
order by
tcontent.lastUpdate desc
siteidtitlemenutitlerestrictedrestrictgroupstypesubTypefilenamedisplaystartdisplaystopremotesourceremoteURLremotesourceURLkeypointscontentIDparentIDapprovedisLockedcontentHistIDtargettargetParamsreleaseDatelastupdatesummaryfileSizefileExtfileidtagscreditsaudienceorderNoratingtotalVotesdownVotesupVotescommentsparentTypepathcreatednextnmajorVersionminorVersionlockIDlockTypeexpiresAssocFilenamedisplayIntervaldisplayfileAltTextchangesetid
5 Reasons Silver is Precious
December 17, 2015

5 Reasons Silver is Precious

As a metal, Silver means second place; as a period of poetic production in Russia, the Silver Age is unparalleled. The years 1890-1925 (give or take) stand out for the explosion of poetic voices, forms, and innovations. With help from the recently published Russian Silver Age Poetry, we explore what sets that period apart.

Poke This
September 01, 2015

Poke This

You really have to be careful who you pose for a selfie with. Unless, of course that's what you meant to do.

I'm Vysotsky: The Legend of Russian Songwriting
July 25, 2015

I'm Vysotsky: The Legend of Russian Songwriting

Everyone in the Soviet Union knew his songs, despite constant censorship and troubles with the Soviet regime. To this day, any Russian will recognize his raspy singing voice and silly falsetto. But what was the great Vladimir Vysotsky like in person?

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.

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