Under Review

Category Results

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

siteid

title

menutitle

restricted

restrictgroups

type

subType

filename

displaystart

displaystop

remotesource

remoteURL

remotesourceURL

keypoints

contentID

parentID

approved

isLocked

contentHistID

target

targetParams

releaseDate

lastupdate

summary

fileSize

fileExt

fileid

Review

In which we review a book on dissidents, and a novel about literary envy.

Government History Literature

March 01, 2020

Punk Rock and Klotsvog

Reviews of a history of punk rock and a novel about a not very likeable woman.

Literature Music

November 01, 2019

Pale Horse and Remembering Leningrad

A review of two books: one work of fiction, and one labor of love.

July 01, 2019

Khodasevich and Vodolazkin

Two recently published works of fiction that we liked and wanted to share with you.

Literature Memoir

March 01, 2019

Stalin's Scribe

I can’t imagine a cleverer or more perverse way of presenting “the first political biography” of Mikhail Sholokhov (1905-1975) than as if from the conscience-addled Sholokhov’s perspective.

Biographies History Literature Reviews

November 01, 2018

Anna and an Atlas

In which we review The Anna Karenina Fix: Life Lessions from Russian Literature, by Viv Groskop, and Restless Empire, by Ian Barnes.

History Literature

September 01, 2018

Six Books

We review books of fiction (Chekhov, Remizov, the Brothers Strugatsky, and Anderson) and an enticing cookbook.

Literature

July 01, 2018

Kolyma, Empires and Chernobyl

In which we review books on empire and disasters.

Government History

May 01, 2018

Is Everything Really Normal?

Reviews of three books and a movie for Russophiles.

March 01, 2018

Margarita, Salvage and the House of Government

In which we review a novel about Bulgakov and his love, Margarita (Mikhail and Margarita, by Julie Himes); Soviet Salvage, by Catherine Walworth; and The House of Government, by Yuri Slezkine.

Architecture Art Government Literature

January 01, 2018

Spies, Found Life, and other Fantasies

In which we review Amy Knight's Orders to Kill, Linor Goralik's Found Life, a new translation of Monday Starts on Saturday, and the new novel Gogol's Head.