Logo

Under Review

Category Results

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

Three Books About Women

In addition to three books about and by women – in recognition of March 8, International Women’s Day – we inaugurate the addition of vodka reviews to this section of our magazine. The review is one of the reviews from our affiliated website, vodkaphiles.com.
Volodos and Berezovsky
November 01, 2000

Volodos and Berezovsky

We review a new CD by pianist Arcadi Volodos, and a biography of Boris Berezovsky.
Three Books and a CD
January 01, 2000

Three Books and a CD

We review three books: PU-239 and other Russian Fantasies, Russia Abroad, and The Crime of Olga Arbyelina, and a CD: The Golden Age of the Russian Guitar.
Three books
October 01, 1999

Three books

Three books are reviewed: Who Killed Kirov?, Yeltsin's Russia, and The Post-Soviet Handbook.
Three Books Reviewed
June 01, 1999

Three Books Reviewed

We review four new books: Moscow Rediscovered, Pushkin: A Biography, Pushkin's Button, and Chronicle of the Russian Tsars.
In Search of the Russian Idea
March 01, 1997

In Search of the Russian Idea

A review of Resurrection, by David Remnick, and The Agony of the Russian Idea, by Tim McDaniel, and a consideration of Russia's attempt to define and embrace a new National Idea.
Deeper into Russia
December 01, 1996

Deeper into Russia

A look at recent travel books on Russia that explore travel beyond the capitals.
Under Review

Under Review

What our reviewer has been reading lately, and what it has gotten him thinking about.

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

Useful Links

Our Contacts

Russian Life
73 Main Street, Suite 402
Montpelier VT 05602

802-223-4955

[email protected]