Category Results

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 1.19 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 08:25:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 08:25:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-02 08:25:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 08:25:00'} or tcontent.DisplayStop is null)
)
)
)
)
AND (
tcontent.mobileExclude is null
OR
tcontent.mobileExclude in (0,1)
)
order by
tcontent.lastUpdate desc
siteidtitlemenutitlerestrictedrestrictgroupstypesubTypefilenamedisplaystartdisplaystopremotesourceremoteURLremotesourceURLkeypointscontentIDparentIDapprovedisLockedcontentHistIDtargettargetParamsreleaseDatelastupdatesummaryfileSizefileExtfileidtagscreditsaudienceorderNoratingtotalVotesdownVotesupVotescommentsparentTypepathcreatednextnmajorVersionminorVersionlockIDlockTypeexpiresAssocFilenamedisplayIntervaldisplayfileAltTextchangesetid
Not your everyday potato
September 01, 2000

Not your everyday potato

Kartofelnaya zapekanka, a baked casserole with potatoes, onions and mushrooms, is the dish of choice for this issue's recipe page, which is part of our annual Russian Flavors section, focusing this year on potatoes.

Tuber or Not Tuber
September 01, 2000

Tuber or Not Tuber

The potato, a beloved staple at the Russian table, was first met in Russia with riots and superstition.

How Beer Can Save Russia
September 01, 2000

How Beer Can Save Russia

The title says it all. Beer is making a comeback in Russia, and one can hope that vodka consumption will take a hit.

Shaman and Native Mysticism
August 18, 2000

Shaman and Native Mysticism

The term Shaman is both a noun and a verb. It is from the Tungus language and is seen as saman or haman. The actions of the Shaman are, what western explorers referred to as, Shamanism. It is the oldest known demonstration of human spirituality.

Women Combat Aviators of the Patriotic War
August 08, 2000

Women Combat Aviators of the Patriotic War

Told that the Rodina was not in so bad a shape that she needed girls to protect her, these future heroes were sent home to their mothers.  Soon, they were called back and became a crucial element in the protection of their homeland and victory over Nazi Germany.

A Tender Tartar Dish
July 01, 2000

A Tender Tartar Dish

Shashlik a la Tartar is the featured dish this issue, with a delectable plum sauce... No summer could be complete without it.

Peter and the Cathedral
July 01, 2000

Peter and the Cathedral

Interestingly, both Tchaikovsky and Savior’s have been surrounded by controversy since well before both rose to prominence in Moscow 117 or so years ago.

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