September 10, 2020

Meet the New Minister, Meat in a Sausage, Mete Out a Fine


Meet the New Minister, Meat in a Sausage, Mete Out a Fine
In Odder News

In this week's Odder News we learn what goes on at meat-packing plants, Ramzan Kadyrov's new minister pick comes as no surprise, and TikTok does what TikTok was designed to do.

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.766 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
=
'43EA8B41-E10B-D75E-16A823CE53D9470B'
and
tcontent.subtype
=
'footnote'
)
AND (
tcontent.Display = 1
OR
(
tcontent.Display = 2
AND
(
(
tparent.type!='Calendar'
and tcontent.DisplayStart <=
{ts '2026-04-02 09:45:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 09:45:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-02 09:45:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 09:45: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

Moscow and Muscovites
November 26, 2013

Moscow and Muscovites

Vladimir Gilyarovsky's classic portrait of the Russian capital is one of Russians’ most beloved books. Yet it has never before been translated into English. Until now! It is a spectactular verbal pastiche: conversation, from gutter gibberish to the drawing room; oratory, from illiterates to aristocrats; prose, from boilerplate to Tolstoy; poetry, from earthy humor to Pushkin. 

A Taste of Chekhov
December 24, 2022

A Taste of Chekhov

This compact volume is an introduction to the works of Chekhov the master storyteller, via nine stories spanning the last twenty years of his life.

Stargorod: A Novel in Many Voices
May 01, 2013

Stargorod: A Novel in Many Voices

Stargorod is a mid-sized provincial city that exists only in Russian metaphorical space. It has its roots in Gogol, and Ilf and Petrov, and is a place far from Moscow, but close to Russian hearts. It is a place of mystery and normality, of provincial innocence and Black Earth wisdom. Strange, inexplicable things happen in Stargorod. So do good things. And bad things. A lot like life everywhere, one might say. Only with a heavy dose of vodka, longing and mystery.

Driving Down Russia's Spine
June 01, 2016

Driving Down Russia's Spine

The story of the epic Spine of Russia trip, intertwining fascinating subject profiles with digressions into historical and cultural themes relevant to understanding modern Russia. 

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.

93 Untranslatable Russian Words
December 01, 2008

93 Untranslatable Russian Words

Every language has concepts, ideas, words and idioms that are nearly impossible to translate into another language. This book looks at nearly 100 such Russian words and offers paths to their understanding and translation by way of examples from literature and everyday life. Difficult to translate words and concepts are introduced with dictionary definitions, then elucidated with citations from literature, speech and prose, helping the student of Russian comprehend the word/concept in context.

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.

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