Government

Category Results

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

Musical Ministerial Chairs

After President Putin was reelected there was a government reshuffling. But very little new blood.

Government

July 01, 2018

Kolyma, Empires and Chernobyl

In which we review books on empire and disasters.

Government History

May 01, 2018

Harrass at Will

On why #metoo is not taking hold in Russia.

Government Men Social Issues Women

March 01, 2018

Margarita, Salvage and the House of Government

In which we review a novel about Bulgakov and his love, Margarita (Mikhail and Margarita, by Julie Himes); Soviet Salvage, by Catherine Walworth; and The House of Government, by Yuri Slezkine.

Architecture Art Government Literature

March 01, 2018

The Women of Russian Diplomacy

Over the 70-year lifespan of the “most equal and democratic nation” known as the Soviet Union, just a handful of women rose to the rank of ambassador. A few more have attained this level since 1991, yet diplomacy in Russia remains largely a male preserve.

Government History Women

March 01, 2018

Death of Cinema?

This is the first time that Russia's Culture Ministry has censored a film by cancelling its license to be shown in theaters. Satire takes a hit.

Film & TV Government History

March 01, 2017

Notebook - Copy

All the news that fits, including quotes overheard and notables' obituaries.

Government News

July 01, 1995

American On Island During Sakhalin Quake

Special report from the scene of the devastating May 28, 1995 quake on Sakhalin Island.

Government Regions

July 01, 1995

Is the Kremlin sinking?

Reconstruction showed up some problems with the land supporting the Kremlin. How past and present efforts have alternately weakened and strengthened the fundament of the famed fortress.