March 17, 2020

Hot Fuzz


Hot Fuzz
Is hard labor easier than being a Russian policeman? We're not sure. Alex 'Florstein' Fedorov, Wikimedia Commons

This story has all the hallmarks of Russian-ness: banyas, dachas, and policemen.

The head of Arkhangelsk's police department is under investigation for coercing his subordinates into performing manual labor. According to Lenta.ru, two lower-level officers spent their work time constructing their boss's banya at his summer house. The officers performed their police duties only on weekends and in their free time. What's more, the chief charged the city for his and the two officers' salaries for the time spent at the dacha.

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.83 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
=
'DC0F044D-F311-2B85-0166666520B15F51'
and
tcontent.subtype
=
'footnote'
)
AND (
tcontent.Display = 1
OR
(
tcontent.Display = 2
AND
(
(
tparent.type!='Calendar'
and tcontent.DisplayStart <=
{ts '2026-04-01 10:15:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-01 10:15:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-01 10:15:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-01 10:15: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

Davai! The Russians and Their Vodka
November 01, 2012

Davai! The Russians and Their Vodka

In this comprehensive, quixotic and addictive book, Edwin Trommelen explores all facets of the Russian obsession with vodka. Peering chiefly through the lenses of history and literature, Trommelen offers up an appropriately complex, rich and bittersweet portrait, based on great respect for Russian culture.

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.

The Pet Hawk of the House of Abbas
October 01, 2013

The Pet Hawk of the House of Abbas

This exciting new trilogy by a Russian author – who has been compared to Orhan Pamuk and Umberto Eco – vividly recreates a lost world, yet its passions and characters are entirely relevant to the present day. Full of mystery, memorable characters, and non-stop adventure, The Pet Hawk of the House of Abbas is a must read for lovers of historical fiction and international thrillers.

 
Life Stories
September 01, 2009

Life Stories

The Life Stories collection is a nice introduction to contemporary Russian fiction: many of the 19 authors featured here have won major Russian literary prizes and/or become bestsellers. These are life-affirming stories of love, family, hope, rebirth, mystery and imagination, masterfully translated by some of the best Russian-English translators working today. The selections reassert the power of Russian literature to affect readers of all cultures in profound and lasting ways. Best of all, 100% of the profits from the sale of this book are going to benefit Russian hospice—not-for-profit care for fellow human beings who are nearing the end of their own life stories.

At the Circus
January 01, 2013

At the Circus

This wonderful novella by Alexander Kuprin tells the story of the wrestler Arbuzov and his battle against a renowned American wrestler. Rich in detail and characterization, At the Circus brims with excitement and life. You can smell the sawdust in the big top, see the vivid and colorful characters, sense the tension build as Arbuzov readies to face off against the American.

Russian Rules
November 16, 2011

Russian Rules

From the shores of the White Sea to Moscow and the Northern Caucasus, Russian Rules is a high-speed thriller based on actual events, terrifying possibilities, and some really stupid decisions.

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