Logo

Category Results

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.993 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
=
'3392B216-0A1E-B89A-01AB1CD5FABB3269'
and
tcontent.subtype
=
'footnote'
)
AND (
tcontent.Display = 1
OR
(
tcontent.Display = 2
AND
(
(
tparent.type!='Calendar'
and tcontent.DisplayStart <=
{ts '2026-04-03 14:20:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 14:20:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-03 14:20:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 14:20:00'} or tcontent.DisplayStop is null)
)
)
)
)
AND (
tcontent.mobileExclude is null
OR
tcontent.mobileExclude in (0,1)
)
order by
tcontent.lastUpdate desc
siteidtitlemenutitlerestrictedrestrictgroupstypesubTypefilenamedisplaystartdisplaystopremotesourceremoteURLremotesourceURLkeypointscontentIDparentIDapprovedisLockedcontentHistIDtargettargetParamsreleaseDatelastupdatesummaryfileSizefileExtfileidtagscreditsaudienceorderNoratingtotalVotesdownVotesupVotescommentsparentTypepathcreatednextnmajorVersionminorVersionlockIDlockTypeexpiresAssocFilenamedisplayIntervaldisplayfileAltTextchangesetid
An Unfortunate Misunderstanding
November 01, 2010

An Unfortunate Misunderstanding

If the boyars of Serpukhov had not been so intransigent, history would have been much different for the town of Podolsk. As it turned out, the little town was forever transformed by a chance visit by American entrepreneurs.
Tolstoy's Flight
November 01, 2010

Tolstoy's Flight

Author Pavel Basinsky has penned a new book about Tolstoy’s last days in Yasnaya Polyana and it has become a Russian bestseller, proving that the classic author is still widely popular in his homeland.
Vodka with a Kiss
November 01, 2010

Vodka with a Kiss

Konstantin Makovsky's Boyarina Bearing a Tray serves as an introduction to an ancient Russian custom of hospitality.
Apocalypse Nyet
November 01, 2010

Apocalypse Nyet

Russian church officials were so sure that the year 7000, counting from the purported beginning of time (1492 in modern calendar time), would herald in the Apocalypse, that they did not bother making Easter calendars beyond that year.
The Napoleon Code
November 01, 2010

The Napoleon Code

There have been rumors of, and searches for, Napoleon’s Treasure since the mid- nineteenth century. Anna Dymkovets tagged along with some modern-day treasure seekers to find out what they are looking for.
Uchites 09
November 01, 2010

Uchites 09

The ninth edition of our Uchites language insert, sponsored by Russkiy Mir Foundation, uses the Itinerants art movement to explore the language of art. A recording is also available online.
Spies, Androids and Napoleon
November 01, 2010

Spies, Androids and Napoleon

Reviews of Stalin's Romeo Spy, Lost and Found in Russia, Russia Against Napoleon, Android Karenina, The New Nobility, and Russian Music for Cello and Piano.
Dueling Calendars
November 01, 2010

Dueling Calendars

Women journalism students from Moscow State University reveal 2 contrasting calendars.
Notebook
November 01, 2010

Notebook

All the news that fits from all across Russia.
Travel Notes
November 01, 2010

Travel Notes

The latest from the travel front.

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

Useful Links

Our Contacts

Russian Life
73 Main Street, Suite 402
Montpelier VT 05602

802-223-4955

[email protected]