Rural Life

Category Results

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.956 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-02 05:25:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 05:25:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-02 05:25:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-02 05:25:00'} or tcontent.DisplayStop is null)
)
)
)
)
AND (
tcontent.mobileExclude is null
OR
tcontent.mobileExclude in (0,1)
)
order by
tcontent.lastUpdate desc

siteid

title

menutitle

restricted

restrictgroups

type

subType

filename

displaystart

displaystop

remotesource

remoteURL

remotesourceURL

keypoints

contentID

parentID

approved

isLocked

contentHistID

target

targetParams

releaseDate

lastupdate

summary

fileSize

fileExt

fileid

Horse Power

Belarusian Alexei Usikov has invented a new vehicle – a horsemobile, with the mighty horsepower of one horse.

Humor Rural Life Transportation

March 01, 2019

In Putin's Footsteps

Nikita Khrushchev’s great granddaughter, Nina Khrushcheva, and an expat living and reporting on Russia and the Soviet Union since 1993, Jeffrey Tayler, offer a poignant exploration of the largest country on earth.

Regions Rural Life Travel

January 17, 2019

The Beauty, the Beast, and the Bumbling Public Official

The post-holiday doldrums must not exist in Russia, where we find stories of hope, change, and a mayor that cares.

News Regions Rural Life The Weekly Russia File Russia File

January 05, 2019

The Coldest Town in the World

The Australian edition of 60 Minutes traveled to Oymakon last winter and brought back this story.

Regions Rural Life Travel Russia File

January 01, 2019

A Winter's Tale (mostly about valenki)

In Russia, valenki are as near as you can get to the country's number-one footwear after regular leather boots.

Customs Humor Rural Life

November 01, 2018

People's Court

In which the Rural Council takes up the case of “The Conduct of Nikolayev, N. N.”

Law Rural Life

September 01, 2018

Two Fishing Tales

Fishing can tell you a lot about life in the countryside, about sickness and health, chance and Fate, to say nothing of electricity and sausage

Humor Rural Life

May 01, 2018

Avdotya and the District Medic

When the district medic comes around, the stage is set for a skirmish between modern and traditional medicine.

Rural Life

January 01, 2018

Retaking a Village

A Russian entrepreneur and family save a village, start an agro business, and share a recipe for Tatar pies.

Food & Drink Rural Life

January 01, 2018

Cats in the Fridge

“We do buy newspapers, and why wouldn’t we? It’s all spelled out in the paper – what the weather’s going to be like, how many rubles there are to the dollar, when the district center’s going to have chickens for sale. No, how can you do without the printed word?”