Lenin returns to Petersburg.

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.815 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
=
'D2863B41-F513-EE89-81856EFBE5418861'
and
tcontent.subtype
=
'footnote'
)
AND (
tcontent.Display = 1
OR
(
tcontent.Display = 2
AND
(
(
tparent.type!='Calendar'
and tcontent.DisplayStart <=
{ts '2026-04-02 01:40:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 01:40:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-02 01:40:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 01:40:00'} or tcontent.DisplayStop is null)
)
)
)
)
AND (
tcontent.mobileExclude is null
OR
tcontent.mobileExclude in (0,1)
)
order by
tcontent.lastUpdate desc
siteidtitlemenutitlerestrictedrestrictgroupstypesubTypefilenamedisplaystartdisplaystopremotesourceremoteURLremotesourceURLkeypointscontentIDparentIDapprovedisLockedcontentHistIDtargettargetParamsreleaseDatelastupdatesummaryfileSizefileExtfileidtagscreditsaudienceorderNoratingtotalVotesdownVotesupVotescommentsparentTypepathcreatednextnmajorVersionminorVersionlockIDlockTypeexpiresAssocFilenamedisplayIntervaldisplayfileAltTextchangesetid

The Kremlin's Two Wars

Help Us Help the Resisters

 

A Few of Our Books

Murder at the Dacha
July 01, 2013

Murder at the Dacha

Senior Lieutenant Pavel Matyushkin has a problem. Several, actually. Not the least of them is the fact that a powerful Soviet boss has been murdered, and Matyushkin's surly commander has given him an unreasonably short time frame to close the case.

The Pet Hawk of the House of Abbas
October 01, 2013

The Pet Hawk of the House of Abbas

This exciting new trilogy by a Russian author – who has been compared to Orhan Pamuk and Umberto Eco – vividly recreates a lost world, yet its passions and characters are entirely relevant to the present day. Full of mystery, memorable characters, and non-stop adventure, The Pet Hawk of the House of Abbas is a must read for lovers of historical fiction and international thrillers.

 
Russian Rules
November 16, 2011

Russian Rules

From the shores of the White Sea to Moscow and the Northern Caucasus, Russian Rules is a high-speed thriller based on actual events, terrifying possibilities, and some really stupid decisions.

A Taste of Russia
November 01, 2012

A Taste of Russia

The definitive modern cookbook on Russian cuisine has been totally updated and redesigned in a 30th Anniversary Edition. Layering superbly researched recipes with informative essays on the dishes' rich historical and cultural context, A Taste of Russia includes over 200 recipes on everything from borshch to blini, from Salmon Coulibiac to Beef Stew with Rum, from Marinated Mushrooms to Walnut-honey Filled Pies. A Taste of Russia shows off the best that Russian cooking has to offer. Full of great quotes from Russian literature about Russian food and designed in a convenient wide format that stays open during use.

Driving Down Russia's Spine
June 01, 2016

Driving Down Russia's Spine

The story of the epic Spine of Russia trip, intertwining fascinating subject profiles with digressions into historical and cultural themes relevant to understanding modern Russia. 

Jews in Service to the Tsar
October 09, 2011

Jews in Service to the Tsar

Benjamin Disraeli advised, “Read no history: nothing but biography, for that is life without theory.” With Jews in Service to the Tsar, Lev Berdnikov offers us 28 biographies spanning five centuries of Russian Jewish history, and each portrait opens a new window onto the history of Eastern Europe’s Jews, illuminating dark corners and challenging widely-held conceptions about the role of Jews in Russian history.

Faith & Humor
December 01, 2011

Faith & Humor

A book that dares to explore the humanity of priests and pilgrims, saints and sinners, Faith & Humor has been both a runaway bestseller in Russia and the focus of heated controversy – as often happens when a thoughtful writer takes on sacred cows. The stories, aphorisms, anecdotes, dialogues and adventures in this volume comprise an encyclopedia of modern Russian Orthodoxy, and thereby of Russian life.

A Taste of Chekhov
December 24, 2022

A Taste of Chekhov

This compact volume is an introduction to the works of Chekhov the master storyteller, via nine stories spanning the last twenty years of his life.

Popular Articles

Using Laughter to Cope
September 07, 2021

Using Laughter to Cope

These eight outstanding Soviet comedies show ​​some of what has made Russians laugh over the past century. Most are still watched today. (First in our new series on learning about Russia through its films.)

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