War

Category Results

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

Painting Veterans

Artist Sasha Sokolova has undertaken a personal, artistic and cultural project to document the daily life of Russia’s remaining war veterans.

Art History War Russia File

May 01, 2018

Veteran Lives

The daily lives of World War II veterans is the subject of a new art project that brings these heroes’ stories and visages front and center.

History Photography War

November 01, 2017

The Wallenberg Secret

The disappearance of Raoul Wallenberg remains just that. But need it be?

History War

October 03, 2017

A Finnish Finish

Our last stop on the Children of 1917 expedition was Finland, namely Tampere, the country's second largest city, where we met our final two heroes.

Holidays Travel War Children of 1917 Russia File

September 26, 2017

Minsk – City for Giants

Minsk is a city built for giants. And it is where we met a great soul, Maria Fyodorovna Rylik, who dedicated her life to teaching and her family.

History Regions Travel War Children of 1917 Russia File

August 29, 2017

The Last Hero

A train ride, a war hero, sunflower fields, and the Loch Ness monster - just another day on the road for the Children of 1917 team.

Health Regions Travel War Children of 1917 Russia File

August 09, 2017

Music Defeats War

When Shostakovich's Seventh Symphony was performed from besieged Leningrad on August 9, 1942, music suspended the horrors of war.

History Int'l Relations Music War Russia File

June 28, 2017

On the Tragedy of One Family... and an Entire People

As told in two letters, two certificates and the autobiography of one centenarian, who turned 100 on June 16 and is the oldest person in her village of 100.

Culture History War Children of 1917 Russia File

January 09, 2017

Maria's War: A Soldier's Autobiography

This astonishingly gripping autobiography by the founder of the Russian Women’s Death Battallion in World War I is an eye-opening documentary of life before, during and after the Bolshevik Revolution.

History War Nonfiction

September 29, 2016

The Babi Yar Tragedy, Remembered in Poetry

On September 29-30, 1941, Nazi troops shot over 33,000 Jews at the edge of the Babi Yar ravine near Kiev. Yevgeny Yevtushenko's poem memorializing the tragedy ensures it will never be forgotten.

Culture History Literature War Russia File

May 01, 2015

Signatures of War

What better way to remember veterans of World War II than through portraits? Arthur Bondar’s project takes us there.