Category Results

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

Operation Infektion

This week, the New York Times released a well-researched, well-produced series of three videos on Russian and Soviet disinformation activities against the US and the rest of the world. Every Russophile needs to watch them.

Int'l Relations Politics 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 14, 2018

Olga's Amazing Work of Art

Olga Ezova-Denisova explains in words and pictures the complex process behind making her special bear linocut prints for our New Russian Life project.

Art Journalism Russia File

November 09, 2018

Being Turgenev

Everyone in Russia knows the great writer Ivan Turgenev, whose 200th birthday is today, and they make his acquaintance in three stages.

History Literature Russia File

November 09, 2018

First Love

An excerpt from First Love, which Turgenev called his most autobiographical novel, tells the story of a sixteen-year-old boy’s infatuation with an older girl.

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.

Internet News Russia File

November 01, 2018

Warm Feelings for the Cool Weather

If you’re here for Halloween spooks, we can’t help you: all we’ve got this week are feel-good stories!

Humor News Russia File

November 01, 2018

How Can I Thank You Enough?

To thank (blagodarit) is one of the Russian language's most beautiful words. We go in for a deep dive.

Humor Language

November 01, 2018

Overheard

Quotes, quips and asides spoken by those in the know (and not).

Humor Politics

November 01, 2018

Church at War

Ukraine will soon have its own independent Orthodox church, fueled by the ongoing Russia-Ukraine conflict.

News Religion

November 01, 2018

The Incomparable Uspensky

The writer Eduard Uspensky passed away recently. In this language section, we look back at one of his contributions to Russian literature and folklore.