Category Results

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.743 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-04 04:35:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-04 04:35:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-04 04:35:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-04 04:35: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

Best Destinations of 2015

The leading travel company shares with us their nine best Instagram photos from their fascinating destinations.

Travel Russia File

January 27, 2016

Salt and Loathing in St. Petersburg

Why are St. Petersburg residents cheering the city's new approach to snow removal?

Regions Travel Russia File

January 26, 2016

Blagoveshchensk

Igor Ageyenko, 29, lives in Blagoveshchensk. This week he offers us a tour of his city, plus a few other places in the Amur oblast.

Regions Everyday Russia Russia File

January 24, 2016

On This Day

Quite often, I am intrigued by the juxtaposition of events that show up in our "On This Day" listings. It is almost as if there were a thin thread across time, linking things together that one might never expect.

History Russia File

January 20, 2016

Krasnoyarsk Krai

Elena Chernyshova, 34, lives in Norilsk. She sends us pictures of this mining town, as well as the Siberian city of Kodinsk.

Regions Everyday Russia Russia File

January 15, 2016

War, Peace and Cable

On Monday, January 18, a new BBC six-part miniseries of Lev Tolstoy's War and Peace comes to American television. Here's your crib sheet.

Film & TV Literature Russia File

January 14, 2016

Russian Life Book Receives National Award

The classic work of Russian journalism, Moscow and Muscovites, by journalist Vladimir Gilyarovsky (translated by Brendan Kiernan), received the prestigious 2015 AATSEEL Award for Best Scholarly Translation into English.

History Literature Russian Life Magazine Russia File

January 13, 2016

13 Crazes Proving Putinmania Is Here to Stay

Join with us in a celebration of 13 inspired displays of Putinalia (not as nasty as it sounds) that Russia has gifted to the world.

Culture Humor Politics Russia File

January 06, 2016

More Dangerous Than Gunpowder

Under Stalin, a poem could mean life or death. For many poets, it was a one-way ticket to the Gulag. Today, poems can be a means to face cultural memories of arrests in the night, forced labor, and the silence demanded of people fearing those fates.