Aleksandr Solzhenitsyn published "Gulag Archipelago," an expose of the Soviet prison system.

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 1.08 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
=
'D2906E4F-C398-5212-1B786A578E90EEEC'
and
tcontent.subtype
=
'footnote'
)
AND (
tcontent.Display = 1
OR
(
tcontent.Display = 2
AND
(
(
tparent.type!='Calendar'
and tcontent.DisplayStart <=
{ts '2026-04-03 18:45:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 18:45:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-03 18:45:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 18:45: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.

The Latchkey Murders
July 01, 2015

The Latchkey Murders

Senior Lieutenant Pavel Matyushkin is back on the case in this prequel to the popular mystery Murder at the Dacha, in which a serial killer is on the loose in Khrushchev’s Moscow...

Woe From Wit (bilingual)
June 20, 2017

Woe From Wit (bilingual)

One of the most famous works of Russian literature, the four-act comedy in verse Woe from Wit skewers staid, nineteenth century Russian society, and it positively teems with “winged phrases” that are essential colloquialisms for students of Russian and Russian culture.

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.

Steppe
July 15, 2022

Steppe

This is the work that made Chekhov, launching his career as a writer and playwright of national and international renown. Retranslated and updated, this new bilingual edition is a super way to improve your Russian.

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. 

Popular Articles

Why Don't Russians Smile?
January 10, 2014

Why Don't Russians Smile?

It is a common trope that Russians never smile. Which of course is interpreted to mean they are unfriendly, gloomy, sullen – positively Dostoyevskian. This, of course, is a complete misreading of body language and cultural norms.

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