Category Results

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.864 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 09:25:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 09:25:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-03 09:25:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 09:25:00'} or tcontent.DisplayStop is null)
)
)
)
)
AND (
tcontent.mobileExclude is null
OR
tcontent.mobileExclude in (0,1)
)
order by
tcontent.lastUpdate desc
siteidtitlemenutitlerestrictedrestrictgroupstypesubTypefilenamedisplaystartdisplaystopremotesourceremoteURLremotesourceURLkeypointscontentIDparentIDapprovedisLockedcontentHistIDtargettargetParamsreleaseDatelastupdatesummaryfileSizefileExtfileidtagscreditsaudienceorderNoratingtotalVotesdownVotesupVotescommentsparentTypepathcreatednextnmajorVersionminorVersionlockIDlockTypeexpiresAssocFilenamedisplayIntervaldisplayfileAltTextchangesetid
Kalmykia: Reviving the Dusty Plain
September 01, 2003

Kalmykia: Reviving the Dusty Plain

A huge expanse of desert and grassy plains, this southern Russian republic has an austere beauty all its own. Of course there is also Chess City and the horse races...

Defending Russian Nature
September 01, 2003

Defending Russian Nature

Over the last century, Russia has created a system of preserves -- zapovedniki -- where wilderness holds sway and humans are rarely allowed. It is the world's largest system of strict nature preserves. We meet some of the heroes quietly working to preserve these zapovedniki, despite miserly allocations from the government.

Miracles on a Shoestring
September 01, 2003

Miracles on a Shoestring

The Russian Space Program has enjoyed a remarkable string of successes and firsts over the past half-century. But, since the fall of the USSR, it has been forced to adapt to new, more commercial realities. We sent Nick Allen to Baikonur, the main Russian launch site, to report back on how the program is fairing.

Notebook
September 01, 2003

Notebook

All the news that fits from all across Russia.

Where the Russians Are
September 01, 2003

Where the Russians Are

A color-coded map of the US, showing which states have the highest percentage of Russian immigrants.

Travel Notes
September 01, 2003

Travel Notes

The latest from the travel front.

Matroshkas, Dachas, Travel and more
September 01, 2003

Matroshkas, Dachas, Travel and more

In this issue, we review a book on the history of matryoshkas, a revised travel guide, a book on dachas, on Putin, some fiction and much more!

Calendar Items in Brief
July 01, 2003

Calendar Items in Brief

Short takes on some historical dates with anniversaries during this issue's publication period.

It's Berry Time
July 01, 2003

It's Berry Time

Summer is berry time in Russia. We look at all the favorite varieties and offer a recipe for that summer favorite, cranberry mors.

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