Category Results

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

Notebook

All the news that fits from all across Russia.

Two Stalin-Faced Books
May 01, 2004

Two Stalin-Faced Books

Stalin's visage can still sell books. We review two recent titles on his era, one on Shostakovich, one by Isaiah Berlin. Plus we briefly review 5 other new titles. The link to this article leads to places you can order the books.

Kremlin Ghosts
May 01, 2004

Kremlin Ghosts

Hidden behind the walls of Moscow’s ancient fortress are phantoms and shades from centuries gone by.

Flirting, Courting and Saying it Right
March 01, 2004

Flirting, Courting and Saying it Right

Ah, the language of love. It is a many-tangled thing. And often you only get one chance to get it right. Be sure to study this column before putting your best foot forward.

Calendar Items in Brief
March 01, 2004

Calendar Items in Brief

Short takes on some historical dates with anniversaries during this issue's publication period.

Rolling into Spring
March 01, 2004

Rolling into Spring

In March, Russian citizens will renew the mandate of President Vladimir Putin for another four years. At least that is what the polls tell us to expect.

Fazil Iskander
March 01, 2004

Fazil Iskander

A look at the life and work of one of Russia's most beloved contemporary writers, on the occasion of his 75th birthday.

Herding Cats: Yuri Kuklachyov
March 01, 2004

Herding Cats: Yuri Kuklachyov

They say you couldn't train cats. Maybe no one told Yuri Kuklachov, who has been doing it for nearly thirty years.

Putin Held Hostage
March 01, 2004

Putin Held Hostage

With his reelection a sure bet, President Vladimir Putin is poised to begin his second Kremlin term. We turned to a noted satirist and opposition activist to find out what he projects for Putin 2.0.

The Soup of Life
March 01, 2004

The Soup of Life

Most Americans consider borshch the quintissential Rusian soup, but the truth is that shchi -- cabbage soup -- holds that honor. Here we look at its history and offer a tasty recipe.

The Invisible Statue
March 01, 2004

The Invisible Statue

In St. Petersburg, every alley and cornice has a history. And the Admiralty, central to the city’s history for three centuries, has plenty of stories to tell. Here is just one.

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