Category Results

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

A Pixelated Palace for Putin

Now you, too, can experience the glamor of Putin's Black Sea palace without the pricetag in the digital worlds of Minecraft.

Internet Politics Pop Culture Russia File

February 08, 2021

Mimosas (The Flower, Not the Drink) in Sochi

Unusually warm weather brings bright yellow blossoms to the region much earlier than normal.

Agriculture Cities & Towns Environment Russia File

February 08, 2021

Christopher Plummer's Last Station

In memory of actor Christopher Plummer, who died last week at age 91, we look back at his role as a dying Leo Tolstoy in the 2009 film, The Last Station.

Biographies Film & TV News Russia File

February 07, 2021

Don't Cross the Domovoy

The creaks of a home can startle the most grounded adult. What kind of mischief might this mean, what kind of creatures lurk unseen?

Culture History Religion Russia File

February 05, 2021

Not a Snowball's Chance in Arkhangelskaya Oblast

One wouldn’t expect it to be an issue for a snowman to be left out in the cold, but in the village of Zachachye in Arkhangelsk Oblast, four such fellows were found wanting for warmth.

Humor Politics Regions Russia File

February 04, 2021

Sports, Sleep, and the State Duma

This week's Odder News features Russian athletes making international news, low-tax sports gear, and more opportunity for restful shut-eye.

Government News Sports Odder News

February 04, 2021

Culture Is Back in 2021 (Whether the Pandemic Is Over or Not)

In this week's Odder News, museums reopen with some strange offerings, the organizing game Tetris is coming to the big screen, and we are thrilled that Russians love the Home Alone franchise as much as we do.

Culture Film & TV Odder News

February 03, 2021

Shurpa: Gulnaz's Taste of Home

Gulnaz has lived in many places: the Siberian North, St. Petersburg, Georgia, and Moscow. And shurpa has been with her wherever she went.

Food & Drink Regions Food Stories Russia File

February 03, 2021

Russia's Cup of Tea

Russian scientists are attempting to bring tea cultivation to more Northern regions of the country.

Agriculture Food & Drink Regions Science Russia File

February 03, 2021

Freed Internet or Internment?

“Everything is ready for it technologically. All decisions have also been made at the legislative level, but (…) it is not easy, and it is really not desired. I still, frankly speaking, do not see any signs of this happening, because, for obvious reasons, it is a double-edged weapon.”