December 18, 2009

Annual Holiday Gift Guide


Annual Holiday Gift Guide

Link to our Online Buyers Guides here

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.844 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
=
'AFAB0B86-5056-A32F-D5BC7AF9163EC9B0'
and
tcontent.subtype
=
'footnote'
)
AND (
tcontent.Display = 1
OR
(
tcontent.Display = 2
AND
(
(
tparent.type!='Calendar'
and tcontent.DisplayStart <=
{ts '2026-04-02 13:05:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 13:05:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-02 13:05:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 13:05: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.

How Russia Got That Way
September 20, 2025

How Russia Got That Way

A fast-paced crash course in Russian history, from Norsemen to Navalny, that explores the ways the Kremlin uses history to achieve its ends.

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.

Fish
February 01, 2010

Fish

This mesmerizing novel from one of Russia’s most important modern authors traces the life journey of a selfless Russian everywoman. In the wake of the Soviet breakup, inexorable forces drag Vera across the breadth of the Russian empire. Facing a relentless onslaught of human and social trials, she swims against the current of life, countering adversity and pain with compassion and hope, in many ways personifying Mother Russia’s torment and resilience amid the Soviet disintegration.

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.

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.

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.

Jews in Service to the Tsar
October 09, 2011

Jews in Service to the Tsar

Benjamin Disraeli advised, “Read no history: nothing but biography, for that is life without theory.” With Jews in Service to the Tsar, Lev Berdnikov offers us 28 biographies spanning five centuries of Russian Jewish history, and each portrait opens a new window onto the history of Eastern Europe’s Jews, illuminating dark corners and challenging widely-held conceptions about the role of Jews in Russian history.

Murder and the Muse
December 12, 2016

Murder and the Muse

KGB Chief Andropov has tapped Matyushkin to solve a brazen jewel heist from Picasso’s wife at the posh Metropole Hotel. But when the case bleeds over into murder, machinations, and international intrigue, not everyone is eager to see where the clues might lead.

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.

 

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