War

Category Results

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

Genocide Preventing Genocide

Russia filed an official objection against Ukraine's case that Russia committed genocide during its invasion of its neighbor.

Government Int'l Relations Law War Russia File

October 16, 2022

Brussels Sprouts and Nuclear Strikes

Russian politician Dmitry Medvedev dismissed EU Representative Josep Borrell's fear of nuclear war as "paranoid."

Government Int'l Relations War Russia File

October 15, 2022

We'll Swim After Victory

Our correspondent was offered a business trip to Odesa, Ukraine. He took it and brought this back.

Regions Travel Urban Life War

October 15, 2022

Notes at the Front

Conviction of a journalist, regional dissent, and voices raised against the war.

Dissent Journalism Media News War Women

October 15, 2022

Never Abandon Your Own

When circumstances force you to leave the country, what do you do with your beloved pets?

Animals Culture Travel War

October 15, 2022

A Knight Brave and Bold

A mother in a remote village grapples with past, present, and future losses to war.

Culture History War

October 15, 2022

Russian and Me

A translator with Russian roots ruminates on her past, and what it means to be a Russophile today.

Family History Language War

October 15, 2022

Poems in a Piggy Bank

War births poetry. We share five recently created and translated anti-war poems.

Dissent Literature War

October 15, 2022

Everything is Connected

We are all daily shaken and unsettled by the fire hose of bad news from Russia and Ukraine, and we all would love “something good, loving, and light from Russia to counterbalance the darkness, the senseless brutality, and the horrors perpetrated by Russian hands in Ukraine.”