Category Results

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.968 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-04 03:00:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-04 03:00:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-04 03:00:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-04 03:00:00'} or tcontent.DisplayStop is null)
)
)
)
)
AND (
tcontent.mobileExclude is null
OR
tcontent.mobileExclude in (0,1)
)
order by
tcontent.lastUpdate desc
siteidtitlemenutitlerestrictedrestrictgroupstypesubTypefilenamedisplaystartdisplaystopremotesourceremoteURLremotesourceURLkeypointscontentIDparentIDapprovedisLockedcontentHistIDtargettargetParamsreleaseDatelastupdatesummaryfileSizefileExtfileidtagscreditsaudienceorderNoratingtotalVotesdownVotesupVotescommentsparentTypepathcreatednextnmajorVersionminorVersionlockIDlockTypeexpiresAssocFilenamedisplayIntervaldisplayfileAltTextchangesetid
The New Dissidents
August 14, 2012

The New Dissidents

The three women - Maria Alyokhina, Yekaterina Samutsevich & Nadezhda Tolokonnikova - on trial in Russia for "hooliganism" for their punk rock performance in Savior's Cathedral, made long closing statements last week. While people can debate the women's tactics, it is excruciatingly difficult after reading their statements to doubt that the women are serious, thoughtful and extremely articulate critics of authoritarianism in Russia.

 
 
Flipping Publishing
July 01, 2012

Flipping Publishing

We have an ambitious, exciting new publishing project, so we are turning to you, our Tribe of Russophiles and bibliophiles, to partner with us.

The Blessing of Language
July 01, 2012

The Blessing of Language

In early June, a noisy, colorful band landed in Manhattan: Thirty Russian authors, two dozen publishers, as many journalists, and half as many organizers.

Notebook
July 01, 2012

Notebook

All the news that fits from all across Russia.

Chernobyl, Chechnya and a bit of Scifi
July 01, 2012

Chernobyl, Chechnya and a bit of Scifi

A review of "Visit Sunny Chernobyl," by Andrew Blackwell, "Sniper" by Nicolai Lilin, "Roadside Picnic" by Arkady and Boris Strugatsky, and Natasha Borzilova's new CD, "Out of My Hands."

Collective Vision
July 01, 2012

Collective Vision

Against the grim backdrop of Stalin's rise, Sergei Gerasimov painted a radiant image of collectivism. While politically propagandistic, it makes beautiful use of light and mood. And it features a collective feast where surely Sour Cabbage - this issue's recipe - would be welcome.

Matilda Kshesinskaya
July 01, 2012

Matilda Kshesinskaya

It would be hard to imagine a ballerina’s life that was more storied than Matilda Kshesinskaya’s. Celebrated on world stages, the lover of tsars and princes, she lived to be 99 years old.

Northern Limits
July 01, 2012

Northern Limits

Over the past few years Russia has sought to extend its protection and dominion over the Arctic. But this is not a new pursuit. In fact, this year marks the centenary of several significant explorations of the Russia’s northern boundaries.

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