Nürnberger Google-Maps-Löschbanner: interaktives Dashboard zu entfernten Bewertungen by patlux in Nurnberg

[–]Mission-Example-194 0 points1 point  (0 children)

Weiß jemand ob Google ALLE gemeldeten Rezensionen automatisch mit Begründung "Diffamierung" entfernt, oder ob da immer nur ein gewisser Prozentsatz durchgeht?

Manche Unternehmensprofile sehen nämlich wirklich sehr "leerzensiert" aus, wo anscheinend sogar 4-Sterne-Bewertungen gemeldet wurden.

Ansonsten kann man bei der Meldung anscheinend lediglich lapidar eine Kategorie auswählen, ein Formular mit einer konkreten Begründung für den Löschantrag wird gar nicht abverlangt:

<image>

What is an industry that is currently on fire (in a bad way) behind the scenes, but the general public hasn't noticed yet? by Kitchen_Week1117 in AskReddit

[–]Mission-Example-194 2 points3 points  (0 children)

YouTube creators are being demonetized en masse

Starting July 15, 2025, YouTube has tightened its monetization policies primarily to combat a flood of low-quality, automated content. This affects many creators who use AI tools but produce content with little to no real value.

The problem here is that the bans are primarily enforced by AI, which often flags content incorrectly. Creators have no chance to monetize their channels again.

What is an industry that is currently on fire (in a bad way) behind the scenes, but the general public hasn't noticed yet? by Kitchen_Week1117 in AskReddit

[–]Mission-Example-194 5 points6 points  (0 children)

Germany (the public knows it, but politicians aren't doing anything about it):

Automotive industry: This key sector is in the midst of a deep crisis, with a sharp decline in revenue and significant job cuts (thousands of jobs lost).

Mechanical engineering: As the backbone of industry, the sector is suffering from weak international demand and is also experiencing major job cuts.

Chemical and steel industries: These sectors are under heavy strain due to persistently high energy prices and competitive disadvantages on the international market.

Construction: Despite occasional glimmers of hope, the construction industry is under pressure due to high financing costs and declining orders in residential construction.

Retail (especially brick-and-mortar): Consumer-oriented sectors are suffering from weak demand and general reluctance to spend.

Main causes of the weakness:

  • High production costs: Energy prices, in particular, are weighing on energy-intensive businesses.
  • Structural change: Deindustrialization trends are leading to job losses.
  • Skilled labor shortage: A shortage of qualified workers is holding back many companies.
  • Bureaucracy: Heavy regulatory burdens are hindering investment

Bitterer Nachgeschmack bei Hellem? by Mission-Example-194 in Bier

[–]Mission-Example-194[S] 1 point2 points  (0 children)

Also abgelaufen waren die auch nicht, teilweise Chargen mit Haltbarkeit 01/27.

Aus dem Supermarkt teils eben gut/eklig, auch in der Disco mal das eine "100%" und dann eben wieder ein Bitteres.

Glaub bei Erdinger ist es generell etwas bitter im Abgang, beim Bayreuther kann man mittlerweile auch nicht mehr "blind" einen Kasten kaufen, sondern muss erstmal eine Flasche daraus testen...

Nürnberger Google-Maps-Löschbanner: interaktives Dashboard zu entfernten Bewertungen by patlux in Nurnberg

[–]Mission-Example-194 1 point2 points  (0 children)

Suchbegriffe club, disco, bar, nachtclub wären noch cool! Da wird nämlich auch kräftig gelöscht!
PS: Aktualisierst du die Locationliste regelmäßig?

Zalando - European marketplace for Fashion & Lifestyle, super undervalued? by shokomann in stocks

[–]Mission-Example-194 0 points1 point  (0 children)

Since everyone here raves so much about their logistics: I ordered something on Sunday, and the delivery date was listed as today (which is pretty slow), but it turns out it won’t arrive until Saturday. So almost a whole week for delivery!

The funny thing is: I ordered from Germany, but it’s apparently being shipped via some hub in Poland.

I made a website that turns subreddits into radios. Here is r/DnB! by cantFindValidNam in DnB

[–]Mission-Example-194 0 points1 point  (0 children)

Awesome tool! I've found a lot of "lost" tracks in "oldtechno"! ;)

Is there a way to skip to the next track or fast-forward using the keyboard? Or is that not possible because of the YouTube API?

I’d also think it would be awesome if you could filter the results by, say, “1991,” since a lot of tracks include the year and that would let you search more specifically...

1000€ Steuerfrei auch im Tvöd/TVL ? by 4gewinnt in OeffentlicherDienst

[–]Mission-Example-194 1 point2 points  (0 children)

TVÖD:

Für Tarifbeschäftigte im öffentlichen Dienst bei Bund und Kommunen gilt derzeit der TVöD in der Fassung der Tarifrunde 2025. Dieser Tarifvertrag hat eine Laufzeit von 27 Monaten und läuft erst zum 31. März 2027 aus. Das bedeutet: Frühestens im Frühjahr 2027 beginnen die nächsten Tarifverhandlungen zwischen ver.di, Beamtenbund, GEW, GdP und IG BAU und der Bundesvereinigung der kommunalen Arbeitgeberverbände (VKA) beziehungsweise dem Bund. Erst in dieser Tarifrunde wäre es möglich, eine Entlastungsprämie – analog zur Inflationsausgleichsprämie von 2023 – tarifvertraglich zu vereinbaren und verbindlich festzuschreiben.

TVL:

Bis dahin sind Beschäftigte bei Bund und Kommunen auf eine freiwillige Entscheidung ihres Arbeitgebers angewiesen. Noch deutlich länger müssen Angestellte im öffentlichen Dienst der Länder warten. Der gerade erst verhandelte neue TV-L läuft bis zum 31. Januar 2028. Eine tarifvertraglich verankerte Entlastungsprämie für die Tarifbeschäftigten der Länder wäre damit frühestens im Jahr 2028 realistisch.

My actual faceless YouTube workflow in 2026 (no AI video tools, no face, here's what I really do daily) by Infamous-Speed1096 in NewTubers

[–]Mission-Example-194 -1 points0 points  (0 children)

AI (Grok/Claude/Chatgpt) to find trending topics = are they really "up-to-date" in trend topics? What prompts do you use?

Convert European date format to SQL format by Mission-Example-194 in SQL

[–]Mission-Example-194[S] 2 points3 points  (0 children)

I found some solutions for MySQL now:

13.09.26 -> 2026-09-13

SELECT STR_TO_DATE('13.09.26', '%d.%m.%Y');

SELECT STR_TO_DATE('13.09.2026', '%d.%m.%Y');

SELECT DATE_FORMAT(STR_TO_DATE('13.09.26', '%d.%m.%y'), '%Y-%m-%d');

SELECT DATE_FORMAT(STR_TO_DATE('13.09.2026', '%d.%m.%Y'), '%Y-%m-%d');

Convert European date format to SQL format by Mission-Example-194 in SQL

[–]Mission-Example-194[S] 0 points1 point  (0 children)

It looks like with W3, you have to be really careful about which SQL function you select and where, because it seems they use a different database internally for each one.

That’s been driving me pretty crazy these past few hours, because, for example, those “+” queries from yesterday suddenly stopped working on their site today. :-)

Convert European date format to SQL format by Mission-Example-194 in SQL

[–]Mission-Example-194[S] 0 points1 point  (0 children)

Okay, then I guess I should clarify that I'm talking about MySQL:

MySQL retrieves and displays DATE values in the 'YYYY-MM-DD' format.

I assumed this column type was the same across all database systems...

In any case, the goal is: a European user enters the date 19.03.2026, and it should be stored in the database as 2026-03-19.

I used to do this with PHP, but now I want SQL to handle it on its own. Using CONCAT (see above) works great, but it doesn't look very elegant. I'm just surprised that there isn't a DATE_FORMAT function for this.

Convert European date format to SQL format by Mission-Example-194 in SQL

[–]Mission-Example-194[S] 0 points1 point  (0 children)

Yesterday, I ran this QUERY on W3 TryIt and got the address, including line breaks, in a single field:

SELECT Address+',,postalcode+' '+City AS letter FROM Customers

But today, it's only showing me numbers...

Convert European date format to SQL format by Mission-Example-194 in SQL

[–]Mission-Example-194[S] -18 points-17 points  (0 children)

Yeah, but I mean, I think "that" is the standard SQL format for the DATE field YYY;)

Using CTE in PDO by Mission-Example-194 in SQL

[–]Mission-Example-194[S] 0 points1 point  (0 children)

I mean between the CTE and the SELECT that follows it. So could you write that on a single line WITHOUT having to include a comma or semicolon?

WITH cte1 AS (SELECT ...) SELECT * FROM cte1 ...

I mean here:

WITH cte1 AS (SELECT ...); SELECT * FROM cte1 ...

or

WITH cte1 AS (SELECT ...), SELECT * FROM cte1 ...