News

Category Results

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

Wailing for Freedom

What would the world be like without a wee boy, women, or whales in the wild? Definitely worse.

Children Environment Humor News The Weekly Russia File Russia File

February 14, 2019

From Russia with Love

Russia’s full of crazy (but lovable) animal stories this week: polar bears, camels, and fathers, oh my!

Humor News Regions Russia File

January 24, 2019

Mud-slinging and Money-making

This week got a little shifty, with trash sent in packages, a possible tax evasion scheme, and a game retelling a contentious moment in recent Russian history.

News Politics The Weekly Russia File Russia File

January 17, 2019

The Beauty, the Beast, and the Bumbling Public Official

The post-holiday doldrums must not exist in Russia, where we find stories of hope, change, and a mayor that cares.

News Regions Rural Life The Weekly Russia File Russia File

January 10, 2019

Crooks and Crazies this Russian Christmas

Russian Orthodox Christmas has come and gone, leaving us with all sorts of holiday lunacy.

Holidays News Sports The Weekly Russia File Russia File

January 03, 2019

Out with the Old, in with the Emu

2018 is out, 2019 is in, and even with the holidays, Russian news didn’t stop.

Holidays News The Weekly Russia File Russia File

December 27, 2018

Favorite Stories from 2018

We look back and some of our, and your, favorite stories from The Weekly Russia File during 2018.

Humor News Politics Sports The Weekly Russia File Russia File

December 21, 2018

Richardson Receives Distinguished Alumni Award

Paul Richardson, publisher of Russian Life, was presented with the Indiana University REEI Distinguished Alumnus Award, an honor that celebrates alumni of the Institute who have made exceptional contributions to academia, public service, education, outreach, and other fields by drawing on their expertise in the Russian and East European region.

Journalism News Russia File

November 15, 2018

Whoosh, Bark, and Boo

This week was a grab bag of jobs well done, tear-jerkers, and meta-scary stories. Buckle up!

Holidays Humor News Russia File

November 08, 2018

Our Untold Stories

Ever wonder what we don’t publish? Well, here it is. The scraps on our cutting room floor, and last week’s fourth-best story – all collected in one wonderfully semi-interesting place.