Nicholas II (ruled 1894-1917) born.

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 1.05 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
=
'D2D78ACC-A0A4-713F-A8BB7118E9CEF2DC'
and
tcontent.subtype
=
'footnote'
)
AND (
tcontent.Display = 1
OR
(
tcontent.Display = 2
AND
(
(
tparent.type!='Calendar'
and tcontent.DisplayStart <=
{ts '2026-04-04 02:55:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-04 02:55:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-04 03:55:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-04 02:55: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

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.

Davai! The Russians and Their Vodka
November 01, 2012

Davai! The Russians and Their Vodka

In this comprehensive, quixotic and addictive book, Edwin Trommelen explores all facets of the Russian obsession with vodka. Peering chiefly through the lenses of history and literature, Trommelen offers up an appropriately complex, rich and bittersweet portrait, based on great respect for Russian culture.

Little Golden Calf
February 01, 2010

Little Golden Calf

Our edition of The Little Golden Calf, one of the greatest Russian satires ever, is the first new translation of this classic novel in nearly fifty years. It is also the first unabridged, uncensored English translation ever, and is 100% true to the original 1931 serial publication in the Russian journal 30 Dnei. Anne O. Fisher’s translation is copiously annotated, and includes an introduction by Alexandra Ilf, the daughter of one of the book’s two co-authors.

Moscow and Muscovites
November 26, 2013

Moscow and Muscovites

Vladimir Gilyarovsky's classic portrait of the Russian capital is one of Russians’ most beloved books. Yet it has never before been translated into English. Until now! It is a spectactular verbal pastiche: conversation, from gutter gibberish to the drawing room; oratory, from illiterates to aristocrats; prose, from boilerplate to Tolstoy; poetry, from earthy humor to Pushkin. 

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.

Fearful Majesty
July 01, 2014

Fearful Majesty

This acclaimed biography of one of Russia’s most important and tyrannical rulers is not only a rich, readable biography, it is also surprisingly timely, revealing how many of the issues Russia faces today have their roots in Ivan’s reign.

Murder and the Muse
December 12, 2016

Murder and the Muse

KGB Chief Andropov has tapped Matyushkin to solve a brazen jewel heist from Picasso’s wife at the posh Metropole Hotel. But when the case bleeds over into murder, machinations, and international intrigue, not everyone is eager to see where the clues might lead.

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