Category Results

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

Genius Temporis

Victor Pelevin may well be the greatest Russian writer of his generation. Not as he seems to care, though.

Juries on Trial
November 01, 2004

Juries on Trial

After nearly a 100-year hiatus, jury trials have returned to Russia. The results, as one might expect, have been mixed.

Shooting for Gold
November 01, 2004

Shooting for Gold

The Athens Olympic Games are over. Time for the Monday morning quarterbacking to begin. Here is how the Russian team did, and should have done (includes a special profile of three female gold medalists from Volgograd).

Two Cities: A Tale
November 01, 2004

Two Cities: A Tale

On Russia’s western frontier, two cities straddle an international border that is less than 15 years old.

Notebook
November 01, 2004

Notebook

All the news that fits from all across Russia.

Chechnya: A Gordian Knot
November 01, 2004

Chechnya: A Gordian Knot

In the wake of the Beslan tragedy, we asked noted expert on Chechnya, Alexei Malashenko, to offer some insights on where the conflict is headed and how Russia can solve this problem in the near or long term.

Travel Notes
November 01, 2004

Travel Notes

The latest from the travel front.

For Whom the Bells
November 01, 2004

For Whom the Bells

75 years ago, the Soviets silenced church bells in Russia. We look at the long history of these musical (and social) instruments.

The One and the Many
November 01, 2004

The One and the Many

A review of Andrey Zvyagintsev's movie, new on DVD, "The Return," and a new film, Notes from the Underground. Also briefly reviewed are three CDs.

Bringing in the New Year
November 01, 2004

Bringing in the New Year

From her village in the Bryansk region, Laura Williams offers a distinctly rural picture of the New Year's holidays in Russia.

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