Answer by warren for How to find entries where the right-hand side of an outer join query is empty?

Here is a joinless pattern: index=ndx sourcetype=srctp requestID=* service IN(ServiceA, ServiceB) | stats values(service) as service min(_time) as early max(_time) as late by requestID | where mvcount(service)<2 “` eliminate only ServiceB from results “` | search service=ServiceA | eval early=strftime(early,"%c"), late=strftime(late,"%c") from User warren – Stack Overflow https://stackoverflow.com/questions/79753971/how-to-find-entries-where-the-right-hand-side-of-an-outer-join-query-is-empty/79760194#79760194 via IFTTT

Favorite tweets

Passivity and “niceness” are not harmless. They ruin families, churches, and nations. And it does so without firing a shot. Entire civilizations are being undone by passive men. — J. Chase Davis (@jchasedavis) Sep 9, 2025 from http://twitter.com/jchasedavis via IFTTT

Favorite tweets

@RnaudBertrand I think what you’re exposing is how barbaric and cowardly Hamas acted resulting in their elimination. — Joshua (@woohoo1215) Sep 9, 2025 from http://twitter.com/woohoo1215 via IFTTT

Favorite tweets

@RnaudBertrand Ok so let me get this straight Transparently telling the entire planet that this is a “last chance” is now akin to negotiating in bad faith? They rejected the deal and Trump’s final offer. This is the consequence. — David Frank Writes (@David_N_Frank) Sep 9, 2025 from http://twitter.com/David_N_Frank via IFTTT

Favorite tweets

@RnaudBertrand He told them they should make a deal. And Israel said they acted alone. Sounds to me like we tried to help them out by giving a fair warning, and they didn’t listen. That’s not our fault. Is there anything you don’t try to blame on USA? https://t.co/9y7scuo6ng — Brandy (@_mind_your_biz) Sep 9, 2025 …
Continue reading Favorite tweets

Favorite tweets

Hamas confirms 5 members killed in an Israeli strike on the Qatari capital Doha https://t.co/hKWFsBYUxM https://t.co/Tj9fOFqlDW — Anadolu English (@anadoluagency) Sep 9, 2025 from http://twitter.com/anadoluagency via IFTTT

Favorite tweets

@zerohedge Apple has AI, OpenAI, and Grok. And how many other companies make AI but no Device? Apple is making a powerful device for it to run on. Ask Kodak if that matters. Ask Sony if they sell the same number of cameras. Ask Landline companies how the same phone affected the — Corechamber (@CoreChamber) …
Continue reading Favorite tweets

Favorite tweets

This is demonstrably demonic and evil. There is no question about it. Even those who try to sweep the story under the rug or find some means of minimizing the matter know, without a shadow of a doubt, this was evil. The problem is that this culture has willingly allowed itself https://t.co/m9SzCNoWHN — Chris Hohnholz …
Continue reading Favorite tweets

Favorite tweets

This is who @owenjonesjourno @campbellclaret @HumzaYousaf and @mehdirhasan are mourning. https://t.co/wevEmbpyBO — Graham Linehan 🎗️ (@Glinner) Sep 9, 2025 from http://twitter.com/Glinner via IFTTT

Favorite tweets

BREAKING: “Operation Summer Heat” just arrested 11 in child predators in Alabama, including three illegals The suspects allegedly engaged in sexually explicit conversations with children online, attempted to meet a child for sex, or tried to traffic a child to others. MONSTERS https://t.co/spjonN7Ppk — Libs of TikTok (@libsoftiktok) Sep 9, 2025 from http://twitter.com/libsoftiktok via IFTTT

Favorite tweets

MAHA Commission: Make Our Children Healthy Again LIVE https://t.co/VjcCCtO9gY — Scarlett Johnson (@scarlett4kids) Sep 9, 2025 from http://twitter.com/scarlett4kids via IFTTT

Favorite tweets

.@PressSec: “Freedom of speech is arguably the most important issue of our time. It is enshrined in our Constitution and @POTUS believes in it strongly… we have take significant action with regards to Brazil in the form of both sanctions, and also leveraging the use of tariffs https://t.co/mkWz3eA7tR — Rapid Response 47 (@RapidResponse47) Sep 9, …
Continue reading Favorite tweets

Favorite tweets

Under Mao, we were so hungry, my uncle tried to show me how to trap rats in my grandma’s community courtyard for food. Pretty soon, rats ran out too. Socialists like @ZohranKMamdani don’t know what they are talking about because they never lived it. @YeonmiParkNK and I did. https://t.co/8slLumNzXp — Lily Tang Williams (@Lily4Liberty) Sep …
Continue reading Favorite tweets

Favorite tweets

Everyone needs to see this. This could be you, your daughter, your sister, or your mother. We can’t let the media keep it under wraps https://t.co/vKnz2UbWft — TaraBull (@TaraBull808) Sep 9, 2025 from http://twitter.com/TaraBull808 via IFTTT

Favorite tweets

Another rich day contemplating the preaching of the four Gospels. Grateful for the calls to biblical exposition, the practical help, and the palpable love for the Word of God & the God of the Word exemplified by each of these men. Preaching #forthechurch https://t.co/3dOFlZrRHw https://t.co/4qgms5cg9f — Jordan Wilbanks (@JPWilbanks) Sep 9, 2025 from http://twitter.com/JPWilbanks via …
Continue reading Favorite tweets

Favorite tweets

We are in a CRISIS in education in America. The scores released by NAEP today show historically low reading results for American students.. yet again. We cannot continue with the current outdated model of education. It is time to return to the basics of phonics and math but use https://t.co/qQhTexzTSN — Tina Descovich 🇺🇸 (@TinaDescovich) …
Continue reading Favorite tweets

Favorite tweets

If some Chicago gang members want to go to war with the national guard, I think they should get what they want. In fact, I would be ecstatic if that happened in every city. https://t.co/q4mfYKb6OF — Samuel Sey (@SlowToWrite) Sep 9, 2025 from http://twitter.com/SlowToWrite via IFTTT

Favorite tweets

The city of Chicago spends twice as much as the entire country of El Salvador yet they can’t fix crime. Crime is a choice. https://t.co/4Y9sXMOBFY — Peter St Onge, Ph.D. (@profstonge) Sep 9, 2025 from http://twitter.com/profstonge via IFTTT

Favorite tweets

But isn’t that an admission that crime is committed by “minorities”? https://t.co/z1lxgyFftB — Nancy Pearcey (@NancyRPearcey) Sep 9, 2025 from http://twitter.com/NancyRPearcey via IFTTT

Favorite tweets

I outline a bear case for China to @DouthatNYT: substantial numbers of the rich, the creative, and the desperate are eager to emigrate — the latter trekking across the southwestern US border. Whose great rejuvenation is this? And a scenario in which China wins: it doesn’t have — Dan Wang (@danwwang) Sep 9, 2025 from …
Continue reading Favorite tweets

Favorite tweets

8/ If the black community ditched the Democrats and embraced these principles again—faith, family, freedom—everything would change: 🚀 Safer streets 🚀 Thriving schools 🚀 Stronger families 🚀 True economic power That’s not theory. That’s history. https://t.co/JnXLvUsaE9 — Rod D. Martin (@RodDMartin) Sep 9, 2025 from http://twitter.com/RodDMartin via IFTTT