Regions

Category Results

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

The Ghost of the Mountains

Editor Maria Antonova headed off to the mountains of the Altai to learn about a project that monitors rare snow leopards. We get to tag along.

Environment Regions

February 28, 2017

Kaliningrad

Alexander Podgorchuk takes us to Russia's westernmost city, Kaliningrad.

History Regions Everyday Russia Russia File

February 21, 2017

Pskov

Accomplished photographer Dmitry Markov takes us on a tour of Pskov, "Where Russia Begins."

History Regions Everyday Russia Russia File

February 15, 2017

Kandalaksha

Teacher Ilona Isayeva shares with us some of the charms of Kandalaksha, a small industrial town on the White Sea.

History Regions Everyday Russia Russia File

February 10, 2017

Veliky Novgorod

Journalist Irina Mordasova and photographer Konstantin Chalabov give us a tour of Veliky Novgorod, a history lover's paradise.

History Regions Everyday Russia Russia File

January 31, 2017

Novosibirsk

Photographer Anton Karliner explains why trains, a metro bridge, and World War II have a place in Novosibirsk history.

History Regions Everyday Russia Russia File

January 24, 2017

Tchaikovsky

Maria Plotnikova acquaints us with Tchaikovsky. No, not the composer, the town named for him in Siberia's Perm Krai.

Music Regions Everyday Russia Russia File

January 17, 2017

Samara

Photographer Kristina Syrchikova explains what a goose has to do with Samara and the Volga River.

Regions Everyday Russia Russia File

January 10, 2017

Chelyabinsk

Artist Anastasia Bogomolova takes us on a tour of Chelyabinsk, famous for its meteorite, tanks, and a very special forest.

Regions Everyday Russia Russia File

January 04, 2017

Yekaterinburg

Photographer Daria Kozinova takes us on a tour of the capital of the Urals: Yekaterinburg.

Regions Everyday Russia Russia File

January 01, 2017

Ivan's Return

Every nation builds monuments to those who symbolize the best the country has produced. Yet sometimes there is wide disagreement on what “best” means.