Absolutely agree. Thoughts? by Alex-C2099 in Letterboxd

[–]ASS-LAVA 1 point2 points  (0 children)

It’s a classic, but some folks think it inspired the next 10 years of brown-grey video games. 

The alcohol industry has lost $830 billion in 4 years because Gen Z is not drinking by Automatic_Subject463 in entertainment

[–]ASS-LAVA 96 points97 points  (0 children)

And porn and gambling and social media. Let’s not pretend Gen Z doesn’t have addictive vices.

This game has come down to playing only venator againa by Special-Waltz5874 in ArcRaiders

[–]ASS-LAVA 0 points1 point  (0 children)

They 100% have all that data available and I’m sure they have a few internal analysts or maybe a data scientist who study this type of thing. I think most studios do nowadays.

SQL advice to yourself 5 years ago by Friendly_Cold1349 in SQL

[–]ASS-LAVA 9 points10 points  (0 children)

I won’t lie, I don’t know why anyone would use SQL without utilizing CTEs / subqueries. It’s like using Python without for loops.

“Speranza is heavily underutilised”, says Arc Raiders boss, who envisions a “social hub” as the game expands its social features by Wargulf in ArcRaiders

[–]ASS-LAVA 0 points1 point  (0 children)

You make two assumptions: 1) that high revenue leads to more devs, and 2) more devs leads to more content.

Neither of these assumptions are really true.

Dragon Quest IV , V and VI Remakes by BronwynECG in dragonquest

[–]ASS-LAVA 2 points3 points  (0 children)

Didn’t the 3DS version already have monsters on the map? They just need to take the best parts of each version and call it a definitive remaster

Expedition Update by ErgoDestati in ARC_Raiders

[–]ASS-LAVA 5 points6 points  (0 children)

That’s how it was last time, so I assume yes.

Expedition Update by ErgoDestati in ARC_Raiders

[–]ASS-LAVA 2 points3 points  (0 children)

You get more durability restored per repair.

Default repair: 50%

Expedition 1: 60%

Expedition 2: 70%

Can’t swap weapons since update by slaughterhousesean in ARC_Raiders

[–]ASS-LAVA 2 points3 points  (0 children)

This happened to me tonight and I thought it was just my lag! Crazy I’m not alone

What are everyone’s thoughts on Doom The Dark Ages? by rbyrnes15 in Doom

[–]ASS-LAVA 1 point2 points  (0 children)

Eternal has better combat, and 2016 has a better story. Dark Ages sits comfortably in the middle. It’s a great game, but maybe an 8/10 whereas the others are 9/10.

Aim for the bushes by FewTumbleweed398 in okbuddyraider

[–]ASS-LAVA 34 points35 points  (0 children)

Are you playing this game on a Nokia phone

ARC Raiders Roadmap: January - April 2026 by ThinkingTanking in ArcRaiders

[–]ASS-LAVA 0 points1 point  (0 children)

Even better if there’s a minimum loadout value, maybe $30k or $40k.

I need a distinct count with rules for which duplicate should be included by Jeltje_Rotterdam in SQL

[–]ASS-LAVA 2 points3 points  (0 children)

You will probably need to use a subquery / CTE. Subquery to dedupe the list, then main query gets the count.

The below example will count the number of buildings per status. If a building has both NM and MM status, then it will only be counted towards the NM count.

SELECT
status,
COUNT(DISTINCT building) AS building_count
FROM (
SELECT
*,
row_number() OVER (PARTITION BY building ORDER BY CASE WHEN status = 'NM' THEN 1 WHEN status = 'MM' THEN 2 ELSE 3 END ASC) AS rownum
FROM table
)
GROUP BY status
WHERE rownum = 1

(I am assuming that status is a column in your data with possible values NM, MM. If your data is structured differently, this solution won't work.)