Category Results

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

Man of Birch

Invite Vasily Chikov to a party and it's likely he'll turn up in a birch bark vest and hat ... and serenade you and your guests with a flute made from, you guessed it, birch bark!

The Magazine Boom
May 01, 2002

The Magazine Boom

Want proof Russia's economy is on the mend? Look no further than the newsstands. New national magazine brands are being introduced every week. So we sent Editor Mikhail Ivanov to look at what is behind the boom in publishing and where it is going.

Imperial Portrait
May 01, 2002

Imperial Portrait

Portrait of Tsar Nikolai I (1796-1855, ruled 1825-1855), by Dmitry Slepushkin (see page 40), painted under a special commission for display in the Kremlin’s Great Kremlin Palace.

Summer Sorrel Shchi
May 01, 2002

Summer Sorrel Shchi

A great dish for summer dacha days is this sorrel soup. Try it at home!

The Moscow Summit
May 01, 2002

The Moscow Summit

In May, US President George Bush became only the sixth sitting US President to visit Russia. On the eve of this visit, we met with one of Russia's leading Amerikanists, Georgi Bovt, and got his read on what to expect for the summit and the months beyond.

Notebook
May 01, 2002

Notebook

All the news that fits from all across Russia.

100 Young Russians to Watch
March 01, 2002

100 Young Russians to Watch

This is the eighth article in our nine-part series: 100 Young Russians to Watch. In this issue we present ten notable individuals—from a chocolatier to a public defender, from an actor and a border guardian to an art dealer and a TV personality ... All personify the sort of excellence and hope which embody a positive Russian future.

Two Great Writers
March 01, 2002

Two Great Writers

Two great modern Russian writers turn 65 in March: Vladimir Makanin celebrates his birthday on the 13th, Valentin Rasputin on the 15th.

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