Law

Category Results

Query
Template: /muraWRM/core/mura/content/feed/feedGateway.cfc:250
Execution Time: 0.819 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 10:30:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 10:30:00'} or tcontent.DisplayStop is null)
) OR (
tparent.type='Calendar'
and tcontent.DisplayStart <=
{ts '2027-04-03 10:30:00'}
and (tcontent.DisplayStop >=
{ts '2026-04-03 10:30: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

Sinfully Good Burgers

A Russian woman is suing McDonald's for producing advertising so effective she gave up on Lent.

Food & Drink Holidays Law Religion Russia File

August 02, 2021

Leaving the Mark of Marriage at the Altar

A move to allow Russians to choose whether their marriage status will be included in their passports has met with traditional backlash. What was that about a ball and chain, now?

Culture Customs Government Law Russia File

June 21, 2021

Drinking Not En-Cur-Aged

If you’re craving hair of the dog, Russia’s State Duma might recommend leaving the dog—or any pet, for that matter—behind.

Animals Government Law Russia File

May 21, 2021

Security Snoops on Banya Bathers

A court case in the city of Perm unveils a story combining three quintessentially Soviet things: bathhouses, religious oppression, and an (extremely) intrusive surveillance state.

Espionage Law Religion Russia File

April 13, 2021

Computer-Judge Finds You Guilty

Russian authorities are planning to make laws that computers can understand and, by extension, adjudicate.

Government Law Science Social Issues Russia File

April 02, 2021

Seeking a Sniper

Looking for work? Moscow authorities have posted an opening for a police sniper on the aptly-named HeadHunter.ru.

Internet Law Military Moscow Russia File

March 01, 2021

Tipping Point?

Just over a decade ago in Moscow, I interviewed Alexey Navalny, who was then only beginning to carve out his profile as a blogger, activist, and politician. It was May of 2008.

Law Opinion Politics Social Issues

February 25, 2021

Have Your Cake

On February 18, the Moscow Department of the Investigative Committee of Russia (CK) released a stern reminder for Russian youth who might be considering a stint in theft, robbery, extortion or other shenanigans after their fourteenth birthdays.

Education Government Law Social Issues Russia File

February 11, 2021

Sputnik Rap, Dolls, and Animal Skulls

In this week's Odder News, how one man spent his pandemic, prisoners teach us how to get out of the pandemic, and a new video game connects you to the Russian police.