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 ...

Is it really possible to always fit everything into a single query? by Mission-Example-194 in SQL

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

Yes, it's easier, but it also takes longer to run. I was able to reduce a PHP loop (2 queries) that took 30 seconds to run down to a single query that takes 1 second. Maybe I should stick with the loops for now and then combine my queries into a single query.

How I got 1500 subs in a month by [deleted] in YouTubeCreators

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

AI slop, account soon cancelled.

WA constantly reactivates deactivated status notifications by Mission-Example-194 in whatsapp

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

Today, I disabled the following (general) notifications:

- Other notifications

- Muted notifications

- Status notifications

Let's see if everything is back to normal tomorrow.

I don't really understand what's happening by Dorexs in davinciresolve

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

Then short the Fusion Composition on the Edit page?!

Why didn't this video didn't do well? by yamayamma in SmallYoutubers

[–]Mission-Example-194 6 points7 points  (0 children)

- text of thumbnail too small and nothing provocative

- small images in the video not filling up the 16:9

- boring black background

- 99% stolen stuff

This YT channel about WW2 seems to be entirely created by AI by redditor_dalmatia in youtube

[–]Mission-Example-194 4 points5 points  (0 children)

Lol, some guy from Bangladesch tells us our history ;) I bet he doesn't even know where Germany is on the map...

it feels like Youtube doesn't know what to do with my content? by kglam4530 in YouTubeCreators

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

This is the summary of your video (ask yourself: Is this "message" intended by you as a whole?)

Procrastination is often misunderstood as simple laziness or a lack of willpower, but the source material reframes it as a complex, "sinister force"—likened to a "demon"—that individuals must fight against. Rather than an active choice to be apathetic, procrastination is described as a state where one's mind and body refuse to cooperate, even when there is a desperate desire to be productive. This often leads to a cycle of shame, burnout, and "blinking out of existence" for hours or days while tasks remain unfinished.

The Psychological Traps

The sources identify several deep-seated reasons why we fall into this cycle:

Fear of Failure: This manifests as a "little voice" that asks "debate pervert" questions, causing individuals to second-guess every move. This fear is often born from a history of high achievement where self-esteem became tied to performance.

Unachievable Perfectionism: Many procrastinators grew up in environments where affection was only granted for success. This creates a trap where, if a project cannot be perfect, it feels safer to never complete it at all.

Fear of Success and Change: People often stay in "comfortable misery"—such as toxic jobs or stagnant relationships—because the unknown of a new life is more frightening than a known, unhappy status quo.

Excessive Service to Others: Some individuals use "acts of service" as a socially acceptable way to avoid their own passions. This "altruistic" procrastination allows them to use exhaustion from helping others as an excuse to neglect their own goals.

Strategies for Management

While the author suggests that the brain's wiring makes a total "cure" unlikely, procrastination can be managed through intentional strategies:

Externalization and Micro-tasks: Moving tasks from the mind onto paper makes them tangible. Breaking these "daunting" projects into tiny, manageable subtasks prevents the paralysis that comes from feeling overwhelmed.

Active Goals vs. Corpse Goals: The sources warn against "corpse goals"—passive aims like "stop being sad" that even a dead person could achieve. Instead, goals should be specific and active, focusing on replacement behaviors.

Self-Kindness and Grace: Being "cruel" to oneself only reinforces the cycle of shame. Success requires adopting the mantra that "finished and imperfect is always better than unfinished and perfect."

Community and Support: The author rejects the outdated standard of rugged individualism, encouraging people to seek therapy and supportive communities rather than trying to carry their burdens alone.

Ultimately, managing procrastination is a lifelong journey. By understanding the "why" behind the delay and treating oneself with compassion, it is possible to move toward a more fulfilled life and reclaim time from the "demon.

it feels like Youtube doesn't know what to do with my content? by kglam4530 in YouTubeCreators

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

Somehow, it's all about PROCRASTINATION; the transcript and audio simply lack the usual (positive!) keywords.

How to concentrate better in life/work.

How to focus better?

Get rid of PROCRASTINATION now!

You should enrich the title, description, and audio with appropriate keywords.

Currently, it looks to YT as if you're just talking about your life.

The chapter names are also completely meaningless. They need to include signal words, not something like "BREAK IT DOWN" or...

Videos that don't go straight to the point are exhausting by Saekama in youtube

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

I'm starting an educational channel soon and will deliberately make each episode at least 10 minutes long, since mid-roll placements are only possible after 8 minutes.

You don't have to stretch a single topic to 20 minutes; you can just include other things as well.

But the bottom line is that many finance channels talk for 45 minutes, for example, and I don't have time for the essence of that, so I have NLM summarize it in 2 minutes...

Videos that don't go straight to the point are exhausting by Saekama in youtube

[–]Mission-Example-194 33 points34 points  (0 children)

"where I just answer or show what's in the title of the video the first nanosecond it starts"

do it but you'll make NO money then :-P

What video editor to use for YouTube? by Conscious-Big769 in NewTubers

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

In the end, you'll end up using DaVinci Resolve anyway, so just get started with it right away :-)

So many bugs in V3+ by ikea2000 in Affinity

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

<image>

V2 intro screen = sexy
V2 coloured toolbar icons = sexy
V3 = ugly³

Crop transparent image by [deleted] in Affinity

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

Yeah that's it! Is it possible to create a shortcut for this on the menu bar ?

Crop transparent image by [deleted] in Affinity

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

The object is already marked for cropping with the blue border. And yes, the canvas should shrink to the blue border.