Regions

Category Results

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

siteid

title

menutitle

restricted

restrictgroups

type

subType

filename

displaystart

displaystop

remotesource

remoteURL

remotesourceURL

keypoints

contentID

parentID

approved

isLocked

contentHistID

target

targetParams

releaseDate

lastupdate

summary

fileSize

fileExt

fileid

A Race With a Heart (of a Dog)

Every year, people from all over the world convene in a small snowy town in northern Russia for the friendliest and fluffiest of sports events – started by an Orthodox nun in a wheelchair who had an idea... and a dog.

NGOs Regions Sports Russia File

March 01, 2019

Women at the Top of the World

At the top of the world, in the bitter reaches of the Arctic, no man can survive without his chumwife. So why is the state cutting off their salaries?

Family Regions

March 01, 2019

In Putin's Footsteps

Nikita Khrushchev’s great granddaughter, Nina Khrushcheva, and an expat living and reporting on Russia and the Soviet Union since 1993, Jeffrey Tayler, offer a poignant exploration of the largest country on earth.

Regions Rural Life Travel

February 21, 2019

Black Snow, Brown Bears, and Sore Losers

Two bears (Bers) meet very different fates. Meanwhile, black ice gets a whole new meaning.

Environment Humor Regions The Weekly Russia File Russia File

February 14, 2019

From Russia with Love

Russia’s full of crazy (but lovable) animal stories this week: polar bears, camels, and fathers, oh my!

Humor News Regions Russia File

February 08, 2019

Tomin: Video Artist Extraordinaire

Khabarovsk artist Tomin creates mind-bending, universe-tilting videos. We tracked him down to find out how he does it.

Art Internet Regions Russia File

January 17, 2019

The Beauty, the Beast, and the Bumbling Public Official

The post-holiday doldrums must not exist in Russia, where we find stories of hope, change, and a mayor that cares.

News Regions Rural Life The Weekly Russia File Russia File

January 05, 2019

The Coldest Town in the World

The Australian edition of 60 Minutes traveled to Oymakon last winter and brought back this story.

Regions Rural Life Travel Russia File

January 01, 2019

The Visitation

In 1947, on the 17th day of February, one of the largest meteorites to strike the Earth in the twentieth century fell in the Russian Far East. Its landing site was a perfect spot from which to watch the Geminid meteor showers.