Military

Category Results

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

Ukraine's Decisive Strikes

Ukraine's effective use of long-range weaponry shocks the Russian military.

Military News Politics War Russia File

July 19, 2022

One Prison to the Next

Russian prisoners with military experience are being recruited to join the fight in Ukraine.

Government Law Military NGOs Social Issues War Russia File

July 18, 2022

Sexual Violence in the Ukrainian Invasion

Over one hundred cases of sexual assault by Russian troops have been reported during the invasion of Ukraine.

Health Law Military War Women Russia File

July 15, 2022

Incendiary Weapons in Ukraine?

Russia has allegedly used incendiary weapons, such as white phosphorus, in their war on Ukraine.

Government Health Int'l Relations Military Politics War Russia File

July 15, 2022

Patching the Holes

Russian lawmakers have been vigorously adding new laws in response to political and cultural developments and public protests, rather than due to pressure from the public or practical necessity.

Dissent Economy Espionage Law Military Politics War

July 14, 2022

It's Nothing Serious... Right?

In a recent meeting, President Vladimir Putin claimed that the invasion into Ukraine wasn't anything "real" or "serious."

Government Int'l Relations Military War Russia File

July 13, 2022

Prone to Resist

“Prone to betrayal, lies and deceit. He refused to participate in a special military operation on the territory of the LPR, DPR and Ukraine.”

– A stamp on a Russian soldier's military ID after he refused to fight in Ukraine

Dissent Government Men Military War Quote

July 08, 2022

The Center of Denial

Putin denies Russia shelled a shopping center in Kremenchug, Ukraine, that killed 18 people.

Int'l Relations Military War Russia File

July 02, 2022

Stealing Grains

Since the Russian invasion of Ukraine, the country has lost approximately 400,000 tons of grain to theft by Russian troops.

Agriculture Food & Drink Int'l Relations Military War Russia File

June 29, 2022

Suing for Peace, and Compensation

"The looting of Ukrainian goods for export – including grain and steel – has already led to rising prices and an increase in the number of people dying of hunger worldwide. This barbarism must be stopped, and Russia must pay in full. I believe in justice, and I will fight for it.”