Category Results

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

A Salad For All Tastes

Vinaigrette is the one Russian salad for which there is no definite recipe...

Notebook
January 01, 1998

Notebook

All the news that fits from all across Russia.

A Prophet and His Country
November 01, 1997

A Prophet and His Country

Thirty-five years ago this month, a little book was published that changed Russia forever. On the anniversary of the publication of Aleksandr Solzhenitsyn's One Day in the Life of Ivan Denisovich, we asked two esteemed observers to offer their views on the great writer's legacy.

Where the Revolution Failed
November 01, 1997

Where the Revolution Failed

The 1917 Bolshevik coup d’etat is arguably the most important event of our century. As historian Richard Pipes has written, “had there not been a Russian Revolution, there would very likely have been no National Socialism; probably no Second World War and no decolonization; and certainly no Cold War, which once dominated our lives."

Damp Area with Firs and Bushes
November 01, 1997

Damp Area with Firs and Bushes

In the final installment of this tour of towns of the Russian North, William Brumfield takes us to Totma, a former salt-producing center now struggling for an identity.

Hidden St. Petersburg
November 01, 1997

Hidden St. Petersburg

We asked some travel experts where to go off the beaten path in the Northern Capital.

Russia's Elusive Middle Class
November 01, 1997

Russia's Elusive Middle Class

There is much talk of Russia's newly rich and sadly poor. But little is heard of its nascent middle class. And what better time to investigate this than on the 80th anniversary of the Bolshevik Revolution, which sought to annhilate the country's middle class?

Notebook
November 01, 1997

Notebook

All the news that fits from all across 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