January 04, 2020

Iconic Tagging


Iconic Tagging

Artist Aleksandr Tsypkov and a handful of other artists feel everyone, not just church-goers, should be able to see religious art. So naturally, they are tagging bridges and underpasses with "iconic" images. Source: RFE/RL

Tags: graffitiart
Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.878 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
=
'71D88CCD-F002-1FE0-6F6CE545884842F5'
and
tcontent.subtype
=
'footnote'
)
AND (
tcontent.Display = 1
OR
(
tcontent.Display = 2
AND
(
(
tparent.type!='Calendar'
and tcontent.DisplayStart <=
{ts '2026-04-03 09:15:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 09:15:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-03 09:15:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 09: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

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.

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.

Woe From Wit (bilingual)
June 20, 2017

Woe From Wit (bilingual)

One of the most famous works of Russian literature, the four-act comedy in verse Woe from Wit skewers staid, nineteenth century Russian society, and it positively teems with “winged phrases” that are essential colloquialisms for students of Russian and Russian culture.

Bears in the Caviar
May 01, 2015

Bears in the Caviar

Bears in the Caviar is a hilarious and insightful memoir by a diplomat who was “present at the creation” of US-Soviet relations. Charles Thayer headed off to Russia in 1933, calculating that if he could just learn Russian and be on the spot when the US and USSR established relations, he could make himself indispensable and start a career in the foreign service. Remarkably, he pulled it of.

The Latchkey Murders
July 01, 2015

The Latchkey Murders

Senior Lieutenant Pavel Matyushkin is back on the case in this prequel to the popular mystery Murder at the Dacha, in which a serial killer is on the loose in Khrushchev’s Moscow...

Fearful Majesty
July 01, 2014

Fearful Majesty

This acclaimed biography of one of Russia’s most important and tyrannical rulers is not only a rich, readable biography, it is also surprisingly timely, revealing how many of the issues Russia faces today have their roots in Ivan’s reign.

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. 

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.

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.

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.

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