Russia File

Category Results

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

Refugees Aboard the Volendam

A well-known cruise line has offered one of its ships to aid the humanitarian effort for Ukraine.

Government Int'l Relations Transportation Travel War Russia File

April 15, 2022

Huawei Slinks Out

Russia's international economic isolation continues as Chinese telecoms giant Huawei moves to leave the country.

Economy Int'l Relations Politics Russia File

April 14, 2022

Russian Denials Inspire Pet Meme

After the atrocities committed by Russia's military in towns surrounding Kyiv first came to light this month, Moscow labeled the extensive evidence a "fake." The blatant attempt to hide the obvious inspired... a viral cat meme.

Humor War Russia File

April 12, 2022

A Nation's Symbol: the Flag of Ukraine

The Ukrainian flag that flies as a symbol of patriotism and solidarity has a strong history.

Culture Government History Int'l Relations Politics War Russia File

April 11, 2022

Protesting Horror

Despite bans on protests, Russians have found creative ways to voice their anti-war stance.

Cities & Towns Government Media Moscow War Russia File

April 09, 2022

Ukrainian Animals, Suffering

In the midst of the Russian invasion of Ukraine, many animals in zoos and shelters have suffered immensely.

Animals Health Int'l Relations Military News War Russia File

April 08, 2022

Soldiers Flee Chernobyl Radiation

Russian soldiers are fleeing Chernobyl fortifications due to claims of radiation sickness.

Geography Health History Military War Russia File

April 07, 2022

Is This the Plan?

Putin says things are going according to plan in Ukraine. What if he's right?

History Int'l Relations Military War Russia File

April 06, 2022

More Facts and Figures from the War

Yet another round-up of some facts and figures from the Russian War on Ukraine.

Int'l Relations War Russia File

April 05, 2022

Putin's War on the Russian Mind

What the Kremlin is telling Russians about the war in Ukraine.

Government Journalism Media War Russia File

April 04, 2022

The Russian Spring Draft

Vladimir Putin recently called for 134,500 new army conscripts.

Government Int'l Relations Military Politics War Russia File

April 03, 2022

Pysanky for Peace

Ukrainian Easter pysanky are a colorful symbol of peace and prosperity. As the country resists Russian aggression, there are ways to support Ukrainian pysanka makers, learn to decorate your own Easter egg, or join a local event to learn about this unique tradition.

Art Culture Customs Holidays Russia File