Category Results

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.805 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 15:15:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 15:15:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-02 15:15:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 15:15:00'} or tcontent.DisplayStop is null)
)
)
)
)
AND (
tcontent.mobileExclude is null
OR
tcontent.mobileExclude in (0,1)
)
order by
tcontent.lastUpdate desc
siteidtitlemenutitlerestrictedrestrictgroupstypesubTypefilenamedisplaystartdisplaystopremotesourceremoteURLremotesourceURLkeypointscontentIDparentIDapprovedisLockedcontentHistIDtargettargetParamsreleaseDatelastupdatesummaryfileSizefileExtfileidtagscreditsaudienceorderNoratingtotalVotesdownVotesupVotescommentsparentTypepathcreatednextnmajorVersionminorVersionlockIDlockTypeexpiresAssocFilenamedisplayIntervaldisplayfileAltTextchangesetid
The Coldest Village on Earth
March 01, 2004

The Coldest Village on Earth

So you think it has been cold in the US this winter? Well, you don't know from cold. You want cold, you go to Siberia. And when Siberians want cold, they go to Oymyakon. So that's where Nick Allen went. You get to tag along.

The Oligarchs and the President
March 01, 2004

The Oligarchs and the President

The vital subtext for March’s election is the battle between the Kremlin and the oligarchs. We walk back through recent history and provide up-to-date profiles of Russia’s weakened robber-barons.

Russia on a Thousand Rubles a Day
March 01, 2004

Russia on a Thousand Rubles a Day

Or perhaps we should say, “Russia on the Cheap.” We asked a long-time expat in Russia to report on how travelers are seeing an intimate and unexpected side of Russia, and doing it inexpensively.

The World's Longest Road
March 01, 2004

The World's Longest Road

In this, the final installment in Ilya Stogoff’s journey across the Russian Far East, the intrepid (if politically incorrect) journalist tries to get home on the Transsiberian Railroad.

Notebook
March 01, 2004

Notebook

All the news that fits from all across Russia.

Six Imperial Era Titles
March 01, 2004

Six Imperial Era Titles

A quick review of six new books that focus on or have their roots in the pre-Revolutionary era.

Mapping Russia
March 01, 2004

Mapping Russia

A map can be such a vivid, descriptive portal into a nation’s history. We asked a map collector and Russophile to share with us some of the most interesting historic maps of Russia.

Putin Boots Kasyanov
February 24, 2004

Putin Boots Kasyanov

The probable has become inexorable. March 14, the date of Russia's Presidential Reelection, will now assuredly cement in place the most significant depluralization of Russian politics since 1989. Putin is expected to get between 70 and 80% of the vote that day -- a number reminiscent of when Brezhnev teetered to the polls.

Meanwhile, there are no checks on executive power. Russia no longer enjoys a Free Press. There is no independent judiciary. The recently elected Duma is a Rubber St
Putinlovefest
January 27, 2004

Putinlovefest

Russia's March presidential election was exciting for about 5 minutes, when there was talk amongst "opposition" candidates of boycotting elections, to deny Putin an electoral minimum, bringing a constitutionally mandated end to his presidency. But, by minute 6, a prominent democrat had defected and enough wacko candidates were popping up in the wings to guarantee the required 50% voter turnout. Now we are ensured a Putinlovefest of unprecedented proportions. Stay tuned...

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