Peggy Lipton

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.73 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
=
'CF2EAAF5-EB19-265D-F3619FB68A9931C9'
and
tcontent.subtype
=
'footnote'
)
AND (
tcontent.Display = 1
OR
(
tcontent.Display = 2
AND
(
(
tparent.type!='Calendar'
and tcontent.DisplayStart <=
{ts '2026-04-03 10:40:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 10:40:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-03 10:40:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 10: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

Stargorod: A Novel in Many Voices
May 01, 2013

Stargorod: A Novel in Many Voices

Stargorod is a mid-sized provincial city that exists only in Russian metaphorical space. It has its roots in Gogol, and Ilf and Petrov, and is a place far from Moscow, but close to Russian hearts. It is a place of mystery and normality, of provincial innocence and Black Earth wisdom. Strange, inexplicable things happen in Stargorod. So do good things. And bad things. A lot like life everywhere, one might say. Only with a heavy dose of vodka, longing and mystery.

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...

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.

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.

The Little Humpbacked Horse
November 03, 2014

The Little Humpbacked Horse

A beloved Russian classic about a resourceful Russian peasant, Vanya, and his miracle-working horse, who together undergo various trials, exploits and adventures at the whim of a laughable tsar, told in rich, narrative poetry.

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.

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.

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