Government

Category Results

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

Capital Taking Flight

15,000 millionaires are predicted to flee Russia by the end of 2022.

Economy Government Social Issues Statistics War Russia File

June 22, 2022

A Humiliating Lack of Recognition

"In general, it has been calculated that if the right of nations to self-determination is actually realized throughout the globe, then instead of the 193 states that are now members of the UN, more than 500 or 600 states would emerge on Earth. Of course, it would be chaos. For this reason, we don’t recognize Taiwan, Kosovo, South Ossetia, or Abkhazia. Apparently, this principle will be applied to the quasi-states, which, in our view, Luhansk and Donetsk are."

– President of Kazakhstan, Kassym-Jomart Tokayev, at a recent forum with President Putin

Government Int'l Relations News Quote

June 21, 2022

Precarious Citizenship

The citizenship of a well-known Armenian activist is at risk after speaking out against the war in Ukraine.

Dissent Government Moscow Social Issues Russia File

June 20, 2022

An Imposed Russian Birthright

Children born in the Ukrainian city of Kherson will now receive Russian citizenship, whether they want it or not.

Children Government Social Issues War Russia File

June 19, 2022

A Peace-Loving Priest

A St. Petersburg priest faces up to ten years in prison for speaking out against the Russian invasion of Ukraine.

Cities & Towns Dissent Government Int'l Relations Military Religion St. Petersburg War Russia File

June 17, 2022

Down and Dirty Journalism (Or, Poo-tin)

A Russian independent journalist has published an exposé on Putin's "biomaterials."

Government Journalism Russians Abroad Travel Russia File

June 15, 2022

A Loss for Justice

"The Committee against Torture has been protecting the rights of citizens who have suffered from torture and inhuman treatment by government officials all their lives. Despite the obvious benefits of this mission, the authorities have been trying for many years to give it an alien and harmful outline... Apparently, the authorities are giving a signal that torture is becoming (or has already become) part of state policy and is not a problem. Here I would like to remind you about the Constitution, where torture is prohibited (for the time being)."