Category Results

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

The Poet of Time

Joseph Brodsky was one of the greatest poets of the 20th century. We explore his life and art, with the help of his friends.

A Collector's Passion
May 01, 2006

A Collector's Passion

James Sinclair and his passion for collecting Soviet militaria has led to the preservation of some very unique uniforms from the height of the Stalin era.

Non-Governmental Spies
May 01, 2006

Non-Governmental Spies

A new Russian law on non-governmental organizations has many in Russia and the West worried about State interference. For instruction, we look at how a similar law has been implemented in neighboring Belarus.

Summer Entertainment Guide
May 01, 2006

Summer Entertainment Guide

Wondering what to read or view this summer? This guide is a start, featuring some of the best fiction for Russophiles out this summer.

The Treasury of Russian Art
May 01, 2006

The Treasury of Russian Art

On the occasion of the 150th anniversary of Moscow's Tretyakov Gallery, we look back at the people and art that have helped this institution endure.

Belarusan Election
May 01, 2006

Belarusan Election

On March 19, according to official data, current Belarusan President Alexander Lukashenko was reelected with 82% of the popular vote. But many voters disagreed with these results.

Tales of Russian Cities & Conservatism
May 01, 2006

Tales of Russian Cities & Conservatism

A review of books on Odessa, Palekh and the roots of Russian conservatism. Plus a few odds and ends, including the winner of a new annual Russian to English Translation prize.

Chado, the Roving Superdog
May 01, 2006

Chado, the Roving Superdog

"A dog is a basic necessity in the village, and the bigger the dog, the better..." But this is not a story about a big dog, at least not physically...

Frittering Away the Harvest
May 01, 2006

Frittering Away the Harvest

A consideration of harvest time naturally leads to this recipe for Olady, or Apple Fritters. Quite tasty they are, too!

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