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.827 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-02 16:15:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 16:15:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-02 16:15:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 16: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

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.

The Samovar Murders
November 01, 2019

The Samovar Murders

The murder of a poet is always more than a murder. When a famous writer is brutally stabbed on the campus of Moscow’s Lumumba University, the son of a recently deposed African president confesses, and the case assumes political implications that no one wants any part 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...

Steppe
July 15, 2022

Steppe

This is the work that made Chekhov, launching his career as a writer and playwright of national and international renown. Retranslated and updated, this new bilingual edition is a super way to improve your Russian.

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. 

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. 

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