Regions

Category Results

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

Jarkov Mammoth

Finding the remains of the prehistoric giant mammoth in the far reaches of northern Siberia is not an unusual occurrence. Bones and tusks reveal themselves when the permafrost thaws. However, the discovery of an intact mammoth is something for scientists to get excited about.

Regions Science Russia File

October 11, 2005

Chechnya; Land of Conflict

Republic of Chechnya and Russia; ancient ethnic conflict in modern times.

History Int'l Relations Regions Russia File

December 17, 2001

Dagestan - Islamic Center and War Zone

Dagestan Republic, the war with Chechyna and the battle for ancient Islamic homeland.

History Regions Russia File

June 14, 2001

Weather Across Russia

Check current conditions and forecasts for several Russian cities.

Environment Regions Russia File

February 13, 2001

Doukhobors of Russia

Part II of this feature

Regions Russia File

February 09, 2001

Doukhobors of Russia

The origins, persecution and emigration to Canada of the Russian religious sect known as the Doukhobors. A direct result of Nikon's reforms and resulting Church schism, learn about their beliefs and culture.

Regions Russia File

August 18, 2000

Shaman and Native Mysticism

The term Shaman is both a noun and a verb. It is from the Tungus language and is seen as saman or haman. The actions of the Shaman are, what western explorers referred to as, Shamanism. It is the oldest known demonstration of human spirituality.

Regions Religion Russia File

June 03, 2000

Golden Khokhloma

Unique and enchanting folk art from the region of Transvolga.

Art Regions Russia File

March 15, 2000

String of Pearls

Russia and Japan have yet to sign a WWII peace treaty. At the center of the dispute are four ancient volcanic islands, part of the Kuril Islands help by Russia and known to Japan as the Northern Territory.