Regions

Category Results

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

Altai

Ekaterina Novikova shares her region, the Altai, with us through words and images.

Photography Regions Travel Everyday Russia Russia File

June 21, 2016

Sochi

This week we travel to Russia's warmer climes. Lesya Polyakova gives us a quick tour of Sochi.

Photography Regions Travel Everyday Russia Russia File

June 14, 2016

Kursk Region

Anastasiya Tsayder takes us inside village living rooms and kitchens, showing a rarely scene slice of Russian rural life.

Photography Regions Everyday Russia Russia File

June 07, 2016

Rostov-on-Don

Sveta Balashova-Kuzmina gives us a tour of her hometown, Rostov-on-Don, at the apex of five seas.

Regions Everyday Russia Russia File

May 31, 2016

Khakassia

Constantine Gulyaev takes us on a tour of Khakassia, "warm Siberia," home to shamans, powerful mountains, petroglyphs and Russia's largest hydroelectric dam.

Regions Everyday Russia Russia File

May 24, 2016

Mariy El

Nikolai Gontar leads us on a trip to the Republic of Mariy El, home to layered pancakes and some very unusual architecture.

Regions Religion Travel Everyday Russia Russia File

May 17, 2016

Tver

Olga Titova takes us to Tver, a main city located between Moscow and St. Petersburg, a land of candles and goats, bridges and rivers.

Photography Regions Travel Everyday Russia Russia File

May 16, 2016

The Most Beautiful Village in Russia

Last week tiny Kinerma was named as this year's "most beautiful Russian village." As it turns out, Kinerma was a stop on The Spine of Russia project...

Humor Regions Travel Spine of Russia Russia File

May 10, 2016

Nizhny Novgorod

Mikhail Solunin, 28, takes us on a tour of Nizhny Novgorod, at the confluence of the Volga and Oka rivers.

Photography Regions Everyday Russia Russia File

May 01, 2016

The Master of Olkhon

Twenty years ago, scheduled flights halted at this distant, Siberian airfield. But that hasn't stopped Vladimir Prokopiyev and his wife Gerald from keeping the landing strip in working order.

Regions

April 26, 2016

Veliky Ustyug

Yuli Lyubeznikov and Alexandra Ivanova show off their town, one of the oldest in the Russian North: Veliky Ustyug

Regions Everyday Russia Russia File

April 19, 2016

Chukotka

Do you know what a karakurt is? Ever been to a Smelt Holiday? Know why some reindeer horns are trimmed? This week, travel with Timur Akhmetov to Chukotka, to find out this and more...

Regions Everyday Russia Russia File