History

Category Results

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

First Love

On the importance of coffee, academicians, a museum, a rooster, the harvesting of turf, and collectivization. Oh, and Novosibirsk.

History Regions Travel

September 02, 2017

First Love

On the importance of coffee, academicians, a museum, a rooster, the harvesting of turf, and collectivization.

History Humor Regions Children of 1917 Russia File

September 01, 2017

1917 Diary

In which we look at the events of 1917 through the words and works of the politicians, artists, and luminaries living through them.

History

August 24, 2017

Scenes from the Road

Photographic proof that all we have done on this trip is work, work, work... and nap.

History Regions 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

July 28, 2017

Old Fears

It was with mixed feelings of bitter guilt and disgust, overcome with shameful and cowardly thoughts, that I joined the Children of 1917 project.

Culture Health History Travel Russia File

July 08, 2017

Two Riverbanks*

Our producer, Misha, wanted us to row across the Volga River to visit 100-year-old Tatyana Semyonovna. He felt it would be epic and symbolic. We disagreed...

History Social Issues Children of 1917 Russia File

July 01, 2017

1917 Diary

In which we look at the revolutionary year through the eyes of the people living through it. In this issue, the politicians, the tsar, and Alexander Blok.

History

July 01, 2017

Tearing Down Walls

On where we want and don't want walls.

History Int'l Relations

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

June 28, 2017

Catherine Seizes Power

On June 28, 1762, Catherine (born Sofia Frederika Augusta), the German wife of a weakened tsar, seized Russian throne. She soon earned the appellation "the Great."