Category Results

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

Chocolate, Chichikov, and Chivalry

This week, Lukashenko turns action hero; chocolate is serious business; and a classic Russian author is proven to be right all along.

Business Government Literature Military Politics Social Issues Women Odder News

September 02, 2020

Happiness, Ants, and a Cold Winter

“Alla Borisovna [Pugacheva] drank not the elixir of youth, but the elixir of happiness.”

– A fan’s post on Maxim Galkin's Instagram account, in reaction to a new photo of the couple

Internet Music Quote

September 01, 2020

Day of Knowledge and the Start of School

September 1 is not only the start of the school year in Russia, but also a time to celebrate knowledge and wisdom.

Children Culture Education Russia File

September 01, 2020

How to Start a Fall Day

A perfect recipe for fall, apple fritters, is offered with two variants.

Family Food & Drink

September 01, 2020

United Across 9000 Kilometers

What unites Khabarovsk and Minsk?

Politics Social Issues

September 01, 2020

God in Nature

The veneration and preservation of nature are at the root of Mari culture. We get a unique inside look at their most sacred annual ritual of worship.

Culture Regions Religion Rural Life

September 01, 2020

In Search of Terra Incognita

Two hundred years ago, the first sighting of Antarctica was recorded – by a Russian expedition. The author retraces the expedition’s steps, and not without hiccups.

Geography History

September 01, 2020

September/October 2020

The Mari People * Life in Isolation * Russia's Discovery of Antarctica * Raspberry Picking * Semyonovsky Revolt * Battle on the Ugra * Sergei Bondarchuk * Table Russian * Bird Language * Apple Fritters * Chicks the TV Series * Kamchatka and Belarus

Culture Geography Regions Social Issues Travel War

September 01, 2020

Creating Anna Karenina

When Tolstoy started Anna Karenina, he was forty-four. He guessed that he would finish the novel, conceived as only a novella, in two weeks. Anna Karenina took him more than four years.