February 04, 2021

Sports, Sleep, and the State Duma


Sports, Sleep, and the State Duma
In Odder News

This week's Odder News features hockey, mixed martial arts, and an active Duma.

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.885 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
=
'6C43DB56-037C-28F3-B34589186B85E188'
and
tcontent.subtype
=
'footnote'
)
AND (
tcontent.Display = 1
OR
(
tcontent.Display = 2
AND
(
(
tparent.type!='Calendar'
and tcontent.DisplayStart <=
{ts '2026-04-02 22:10:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 22:10:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-02 22:10:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 22:10:00'} or tcontent.DisplayStop is null)
)
)
)
)
AND (
tcontent.mobileExclude is null
OR
tcontent.mobileExclude in (0,1)
)
order by
tcontent.lastUpdate desc
siteidtitlemenutitlerestrictedrestrictgroupstypesubTypefilenamedisplaystartdisplaystopremotesourceremoteURLremotesourceURLkeypointscontentIDparentIDapprovedisLockedcontentHistIDtargettargetParamsreleaseDatelastupdatesummaryfileSizefileExtfileidtagscreditsaudienceorderNoratingtotalVotesdownVotesupVotescommentsparentTypepathcreatednextnmajorVersionminorVersionlockIDlockTypeexpiresAssocFilenamedisplayIntervaldisplayfileAltTextchangesetid
Like this post? Get a weekly email digest + member-only deals

Some of our Books

Murder at the Dacha
July 01, 2013

Murder at the Dacha

Senior Lieutenant Pavel Matyushkin has a problem. Several, actually. Not the least of them is the fact that a powerful Soviet boss has been murdered, and Matyushkin's surly commander has given him an unreasonably short time frame to close the case.

Survival Russian
February 01, 2009

Survival Russian

Survival Russian is an intensely practical guide to conversational, colloquial and culture-rich Russian. It uses humor, current events and thematically-driven essays to deepen readers’ understanding of Russian language and culture. This enlarged Second Edition of Survival Russian includes over 90 essays and illuminates over 2000 invaluable Russian phrases and words.

Faith & Humor
December 01, 2011

Faith & Humor

A book that dares to explore the humanity of priests and pilgrims, saints and sinners, Faith & Humor has been both a runaway bestseller in Russia and the focus of heated controversy – as often happens when a thoughtful writer takes on sacred cows. The stories, aphorisms, anecdotes, dialogues and adventures in this volume comprise an encyclopedia of modern Russian Orthodoxy, and thereby of Russian life.

The Moscow Eccentric
December 01, 2016

The Moscow Eccentric

Advance reviewers are calling this new translation "a coup" and "a remarkable achievement." This rediscovered gem of a novel by one of Russia's finest writers explores some of the thorniest issues of the early twentieth century.

How Russia Got That Way
September 20, 2025

How Russia Got That Way

A fast-paced crash course in Russian history, from Norsemen to Navalny, that explores the ways the Kremlin uses history to achieve its ends.

The Little Humpbacked Horse
November 03, 2014

The Little Humpbacked Horse

A beloved Russian classic about a resourceful Russian peasant, Vanya, and his miracle-working horse, who together undergo various trials, exploits and adventures at the whim of a laughable tsar, told in rich, narrative poetry.

About Us

Russian Life is a publication of a 30-year-young, award-winning publishing house that creates a bimonthly magazine, books, maps, and other products for Russophiles the world over.

Latest Posts

Our Contacts

Russian Life
73 Main Street, Suite 402
Montpelier VT 05602

802-223-4955