2021.10.24 01:13 LostChildhood425 Why I Don't Get The Great Relationship Or Friends In My Life You All Out There Reading? It Is Complicated!
|submitted by LostChildhood425 to MeanGirls [link] [comments]|
2021.10.24 01:13 Nucks11 My girlfriend made this meme for that 2nd period.
|submitted by Nucks11 to canucks [link] [comments]|
2021.10.24 01:13 Heavy_Muscle_8189 What would you do if you woke up as Beyonce and in 2005?
2021.10.24 01:13 throwra4296969 Anyone help me with BSB? New bloodtinge playthrough and I'm having an awful time of it.
2021.10.24 01:13 Landen10e What should you name your pet?
2021.10.24 01:13 helloreddit974 Count NULL contents from all COLUMNNAME starting with « name » (name1, name2 etc)
Hi reddit, Not even sure if it is possible, I’m struggling with some one-line-queries !
I have a table with data and a few columns starting with page1, page2, page3 etc. I’m trying to count how much « pageX » are null or empty.
1) as Single row ———————————————————————————- id | name | etc | page1 | page2 | page3 | page4 | from ———————————————————————————- 1 | hello | Hi | NULL | NULL | string | string | foo <—— wanted OUTPUT (2) 2 | hello | Hi | NULL | NULL | NULL | string | foo <——wanted OUTPUT (3)
2) and as a SUM ———————————————————————————- id | name | etc | page1 | page2 | page3 | page4 | from ———————————————————————————- 1 | hello | Hi | NULL | NULL | string | string | foo 2 | hello | Hi | NULL | NULL | NULL | string | foo
WHERE from=foo <——— wanted OUTPUT (5)
I found a dirty-looking way online for QUERY n°1
« SELECT (SELECT (IFNULL(page1, 1) + IFNULL(page2, 1) + IFNULL(page3, 1) + … ) as nulls FROM TABLE WHERE id=1) as nulls, * FROM TABLE WHERE id=1 »
It looks so bad, but it works. Because example query (1) uses « id » twice in it, I can’t wrap my head around making the SUM query (2), I suck.
What’s the purpose? Just making percentage of filled pages lol. Want to get rid of dirty php code like :
——— Is there a solution or any better way ? Have an amazing day !
submitted by helloreddit974 to mysql [link] [comments]
2021.10.24 01:13 chickenbeatup Want storm watch
2021.10.24 01:13 Young_feet6 My feet look so rough after dancing…
|submitted by Young_feet6 to Feetishh [link] [comments]|
2021.10.24 01:13 Sadan27 Should I take the plunge into the dark side and take an AI? 1651 Test, 90 Estradiol after 2 Months TRT
My protocol 30 mg test cyp/day, 500 IU HCG E3D (transitioning to 300 IU EOD), T3/T4 thyroid 30 mg/day, DHEA 50 mg/day.
I stopped taking Anastrozole after the first couple weeks after researching its short and long term effects. I don’t have gyno or related symptoms, my sexual function is fine, and I’m not emo.
I do have acne on my shoulders - not sure whether a symptom of excess DHT or estrogen? I was having brain fog and fatigue that was continuing from before when I started TRT, which had already started improving a bit with these blood levels (FYI the blood work was done two days after 30 mg test injection, and one day after 500 iu hcg injection)
I’ve read and watched many knowledgeable TRT specialists claim that the percentage of estradiol relative to total testosterone is what’s important, not the estradiol number itself. And that approximately 5% is ideal. Mine comes in at 5.4%
I’ve heard other knowledgeable TRT specialists claim it is ideal to have estradiol in the 20s (usually mid 20s). My estradiol is in fact really high - over 2x the top number (39) of the assay, and over 3x what some claim is ideal
I definitely don’t want to crush estrogen, nor its neuroprotective or cardioprotective effects. Plus I feel pretty good overall. But I don’t want overly high estradiol to eventually lead to health and other problems.
Should I take anastrozole? If so it seems twice week is the minimum necessary frequency for a sustained effect. What would be the minimum amount to get estradiol to like 50 or 60 tops. I feel good for the first time in a long time and really don’t want to reduce my test dose.
submitted by Sadan27 to trt [link] [comments]
2021.10.24 01:13 izzyinchainss Foot cramping
I own a pair of impala quads I use for park skating... every time I skate I end up with these horrible foot cramps for ages after..
I’m not sure if it’s the boot itself, the raised heel on it, but I recon I could probably fit some insoles into it if need be.
Any suggestions + ideas on how to stop this?
submitted by izzyinchainss to Rollerskating [link] [comments]
2021.10.24 01:13 YeetHereIAmYolo1324 Copy cat, creates one extra cat at random
|submitted by YeetHereIAmYolo1324 to Bossfight [link] [comments]|
2021.10.24 01:13 Rhetty1spaghetti Look at what they did to my boy
|submitted by Rhetty1spaghetti to newworldgame [link] [comments]|
2021.10.24 01:13 Arthuurtel120 ¿Cómo le va a El Salvador con el bitcoin? Fallos, protestas y una escena que "puede ser terrible"
2021.10.24 01:13 Matchakitkat_5 [LF] 3 green mushroom platforms [FT] NMTs, bells, anything
2021.10.24 01:13 jeremiahthedamned The Japanese folktale of the selfish scholar - Iseult Gillespie
|submitted by jeremiahthedamned to The_Honkening [link] [comments]|
2021.10.24 01:13 Iliketoortless Jon Van Zyle signed poster/painting - Any value or should I toss it?
2021.10.24 01:13 SupremoZanne POLL: If you are a Nickelodeon addict, what level of addiction do you rate yourself at?
This here is a poll to determine how addicted you are to Nickelodeon:
Now remember, this poll is not strictly for current addicts, but former addicts of Nickelodeon can also answer for what their addiction level was in the past.
and here are the addiction levels to describe: LEVEL 1 addicts had a hard time not thinking about it
LEVEL 2 addicts felt it was the most important entertainment to them
LEVEL 3 addicts are completely fixated on the subject
LEVEL 4 addicts could not live without watching any hours of it
LEVEL 5 addicts were so addicted, that Nickelodeon is or was the only thing they ever thought of.
submitted by SupremoZanne to TruckStopBathroom [link] [comments]
2021.10.24 01:13 archanox Broken ADS in Zombies with a controller?
Pressing L2 on my backbone controller on iOS does nothing.
To a lesser extent pressing R3 also does not mark locations like the other game modes, but instead does a melee.
submitted by archanox to CODMobile [link] [comments]
2021.10.24 01:13 Louis_iverson We got over 780+ people joined this community in less then 1 day join up if you bought PHUN
2021.10.24 01:13 extrasprinkle Thomas Kinkade Disney: Mickey and Minnie - Ceaco - 500 Pieces
|submitted by extrasprinkle to Jigsawpuzzles [link] [comments]|
2021.10.24 01:13 Keratin_Brotherhood This is how GameStop will successfully bring NFTs to mainstream.
| Tl;dr: GameStop has been testing ways to introduce NFT tech to the 'layman'. The NFT contest posted by Ryan Kagy seems innocuous but he gathered valuable information about the customer education process. We apes are the BRDIGE that will let GameStop quickly and effortlessly "cross the chasm". We are both the early adopters & early majority. We are the ones who will teach the public how to use NFT tech and push it toward ubiquity. |
Ta;dr: DRS your shares so you can join the imminent NFT party.
This is all speculation and my opinions based on my experience in marketing and branding. Not financial advice and all that jazz.
Introduction After seeing the 6969 winner from Ryan Kagy's Twitter post about his experience with setting up the NFT wallet (if that's not the right term to call it, please correct me! I'm still an NFT infant.), it confirmed a few ideas I have about GameStop's revolutionary NFT play.
The Technology Adoption Lifecycle Any new tech company looking to break out of the early adopter stage and into the early majority stage, has to succeed in a major marketing hurdle. It's called the "crossing the chasm" and is the most difficult part of the Technology Adoption Lifecycle. Most tech startups fail in this stage because of poorly executed marketing strategies. Essentially, marketing to early adopters is very different from marketing to the early majority. As lagniappe, Steve Jobs and the iPhone is the all-time best example of how to perfectly cross the chasm. Convincing the world that a touch screen is superior to a panel of Blackberry buttons was no easy task!
For further information about this idea, I highly recommend reading "Crossing the Chasm" by Geoffrey Moore. But in lieu of reading that book, here is a quick summary of the two different stages:
These images aren't mine. I borrowed them from here.
As you can see in the images, there is a transition period between the early adopters and the early majority. This "chasm" requires a completely different marketing approach if the company hopes to reach mass market adoption.
Technology Adoption Lifecycle Case Study: America Online Let's think about the proliferation of the internet for a moment. If you want to skip the case study example of the Technology Adoption Lifecycle, scroll to the next section.
I was a freshman in high school when America Online (AOL) CDs were first being indiscriminately cluster-bombed in neighborhoods around the United States. Quite literally, one could expect a new AOL CD to arrive twice a week. For those of you who didn't grow up with that debacle, these CDs would give you AOL software for free. Actually, I believe they were trial subscriptions, but you could simply create a new account with each CD. So you never actually needed to pay.
Setting aside the fact that the superfluous amount of CDs was likely the single biggest contributor to plastic waste in the late 90s/early 2000s, they are one of the main reasons why the internet became ubiquitous.
Think about it: You have this new tech (the internet) and it only gets better the more people use it. Unfortunately, most Americans have no idea what the hell an 'internet' is, nor how works or how it fits into their lives. Until AOL, it was only known about in the early adopter crowd.
This was the chasm for the internet. Any company could've succeeded in getting America online (heh!), but only AOL did it. They realized that there was this gargantuan market share that was untapped and ripe for the picking.
How do you market to this group? You can't throw a bunch of tech mumbo-jumbo at them. Remember, these are essentially Boomers (completely tech-illiterate) and Gen X-ers (suspicious about anything and everything new).
Well, you make a simple, easy, and harmless way to introduce them to the internet.
In the case of AOL, my opinion is that they actually forced the early majority into becoming early adopters through ease of use and a streamlined onboarding process. Then relied on the network effect to grow AOL's market share. This was genius on the part of AOL, and many tech companies have implemented this same strategy (Netflix, Facebook, Amazon). Unfortunately for AOL, they are well past their twilight years and will disappear sooner than later. Thus is the circle of life for every company.
How does this relate to GameStop? So how does this idea relate to GameStop? Refer back to the definition of early adopter and early majority:
Whenever they find a strong match, early adopters are willing to base their buying decisions upon it. Because early adopters do not rely on well-established references in making these buying decisions, preferring instead to rely on their own intuition and vision, they are key to opening up any high-tech market segment.Early majority
They want to see well-established references before investing substantially. Because there are so many people in this segment—roughly one-third of the whole adoption life cycle-winning their business is key to any substantial profits and growth.In short, early adopters are the "trendsetters" and early majority are the "bandwagoners".
Have you DRSed your shares yet?
I believe GameStop will be the bridge that introduces the blockchain and NFT marketplace to the layman. This will make them one of the biggest (both in market cap and market share) blockchain tech companies in the world.
I made another post a month or so ago about why I think RC chose to invest in GameStop. It's nothing ground-breaking and neither is this post. But it's still worth talking about as we approach the heavily anticipated Q4 (looking at you Loopring!).
Creating the Network Effect If we apply the Technology Adoption principles to what we suppose RC is doing, apes would be an amalgamation of early adopters and the early majority. He proved this would work with the tenacity we all show when holding GME. We are willing to trust RC and the process and get jacked to the tits about every single thing the company is doing. We could be categorized as early adopters for GameStop NFT. But at the same time, we aren't early adopters because many of us don't even know the first thing about NFTs and blockchain.
Take myself as an example, I know shit about shinola when it comes to NFTs and blockchain. But if GameStop releases it in a way that is easy-to-understand, easy-to-use, and easy-to-integrate into my life, I sure as hell am going to get me a piece of that.
And apes talk about GameStop NFT. We are the one of the biggest grapevines this world has ever seen. Imagine the hype we feel when speculating about GameStop NFT on Superstonk. Realize too, that we know nothing about anything they're doing behind the scenes. Now imagine the word-of-mouth frenzy that'll ensue once GameStop announces what they've been building. Ridiculous. FOMO.
We hear a bunch of chatter recently about other companies purportedly developing their own NFT marketplaces. Coinbase immediately comes to mind and I recall hearing whispers about Jack Dorsey/Cent and Facebook doing something in the space as well.
Now before I smack down those companies attempts to do what only GameStop can do, read this about crossing the chasm:
In order to convince your target segment you’re selling a holistic, well-supported product with good references and establish yourself as the market leader, you have to strictly sell to only your target group. Source
What the early adopter is buying is some kind of change agent...They expect a radical discontinuity between the old ways and the new, and they are prepared to champion this cause against entrenched resistance. Being the first, they also are prepared to bear with the inevitable bugs and glitches that accompany any innovation just coming to market.
Firstly, who would Coinbase be targeting to? Current users? Good luck scaling. New users? Good luck getting them. Coinbase may have billions of dollars in valuation but they lack brand equity. Gamestop does not. The very word "GameStop" invokes emotions, memories, nostalgia, and passion. You CANNOT replicate that.
GameStop's target group — gamers — are the target for GameStop NFT. They're one-in-the-same! RC knows this and will leverage GameStops brand equity when they start marketing their NFT marketplace. AND they will be the first mainstream NFT marketplace. I didn't say the first NFT marketplace, but the first mainstream NFT marketplace. Remember, NFTs are not mainstream — yet.
Immutable Law of Marketing #3: Law of the Mind - It's not important to be first in the market but first in the mind of consumers.
Secondly, about that Wu-Tang Clan NFT album. If that actually becomes a dividend of some sort, then GameStop will have the beginnings proof of a properly working NFT marketplace that can integrate into existing tech base (hello Loopring!). The early majority need this if they are to adopt a new tech. In other words, RC could use an GameStop Wu-tang Clan album NFT dividend as early majority proof of product/service.
Ethereum logo on hoodie face??
This strategy would also "force" a mass enrollment into their new marketplace by way of apes looking to redeem their dividend (I'm actually not clear on how NFT dividends would be redeemed so anyone with more knowledge, please chime in). This would immediately create the necessary network effect that an NFT marketplace would need in order to work.
To quote the marketer, Seth Godin, think about the first person to use the fax machine. Who did they send a fax to? You need more fax machines to make them valuable. Right now, existing NFT marketplaces appear to lack substantial network effect. AOL, Facebook, Reddit — they all relied/rely on the network effect to scale their business. But getting the new signups, aka the early majority, costs a LOT of money in marketing. Word-of-mouth is the cheapest and most effective marketing channel, and giving apes a dividend would create it on a massive, global scale.
Basically, in one fell NFT dividend swoop, GameStop NFT will have crossed the chasm without even breaking a sweat. Thanks to apes signing up to redeem their dividend, spreading the word and getting their friends and families to enroll in the marketplace, precious market share will be gobbled up before fast followers like Coinbase, Cent, and Facebook have a opportunity to establish a beachhead. Their deep pockets and institutional investors wouldn't be able help them 'buy' GameStop's brand equity. They will have to settle for competing amongst themselves for 2nd place or create a smaller sub-niche to compete in.
Speculation paragraph: Circling back to Ryan Kagy's 6969 contest, they have probably been doing in-house testing of onboarding and customer service or technical support-related issues. They also have the advantage of having Loopring's onboarding expertise. I think the 6969 contest was a real-world case study of how enrolling a new person into NFT would look. If we see more of these contests over the next few weeks, then it'll lend more weight to my speculation.
This is game-changing, apes. We are all on the cusp of a generational disruptive technology and have front-row seats to the event! Just think, you could've been born in any time before or after today. This is all meant to be and I'm thrilled to be enjoying this journey with you!
Tl;dr: GameStop has been testing ways to introduce NFT tech to the 'layman'. The NFT contest posted by Ryan Kagy seems innocuous but he gathered valuable information about the customer education process. We apes are the BRDIGE that will let GameStop quickly and effortlessly "cross the chasm". We are both the early adopters & early majority. We are the ones who will teach the public how to use NFT tech and push it toward ubiquity.
Ta;dr: DRS your shares so you can join the imminent NFT party.
submitted by Keratin_Brotherhood to Superstonk [link] [comments]
2021.10.24 01:13 CH1LLDE I drew a screenshot in Sky as my art project!
|submitted by CH1LLDE to SkyGame [link] [comments]|
2021.10.24 01:13 TornadoJ88 Masjid Jamek allegedly turning away non-citizen worshippers
|submitted by TornadoJ88 to malaysia [link] [comments]|
2021.10.24 01:13 Apprehensive-Talk919 18 [M4F] Northside Houston
looking for someone 18-30 willing to take my virginty and use me however they want. honestly want to get this feeling of having sex over with, if anyone is willing to help me plz do!
submitted by Apprehensive-Talk919 to houstonr4r [link] [comments]
2021.10.24 01:13 lurdakopse eBay Coupon Yousaveten
Here is the eBay Coupon Yousaveten
Really good site if you are looking for coupon codes. You can find most stores deals, coupons, deals on there.
submitted by lurdakopse to eBayPromoCode [link] [comments]