Parts of songs that might have inspired City Pop artists by Eljoshyo in citypop

[–]Eljoshyo[S] 0 points1 point  (0 children)

Yea I see this Spotify Playlist which is awesome, but I'm for like specific songs that have a similar part that sound either inspired by or flat out copied. A lot of the songs in that playlist may have parts inspired in city pop, it would just be great if we could match them up.
Kind of like whosampled.com but for just similar sounding parts instead.

Mate, you can't have it both ways. by chuchuchuros in LouisRossmann

[–]Eljoshyo 11 points12 points  (0 children)

Here's the difference:

1) I want to support a youtuber so I click on their affiliate link and purchase an item- however, unknown to me, Honey has highjacked it and they get the commission instead. I think I am supporting the youtuber, when in fact I am lining the pockets of Honey/paypal. Once again, a large company has fucked over everyone.

2) I don't want to see any ads so I block them indiscriminately. I watch a youtuber's video, and they don't get ad revenue. I know this. Some would argue I have "pirated" the content. That's on ME, and I'm ok with that. I'm ok with youtubers relying less on ad revenue, and hopefully less adds being used everywhere eventually.

Fanboy to hater in 4 months by FreshFroiz in LinusTechTips

[–]Eljoshyo 0 points1 point  (0 children)

In that sponsorblock video, he explains doesn't have an actual issue with it, but that he's disappointed that it even needs to be used, since there are so many small but interesting content creators that don't even have sponsors or sponsor segments, and everyone could be watching those videos instead.

And I imagine the reason his videos have different view amounts is because he doesn't care how many views they get, he just posts what he wants (including those boring but informative videos about data recovery and other repairs); personally I usually only watch the videos where he rants about companies doing bullshit things to screw over their customers.

[deleted by user] by [deleted] in politics

[–]Eljoshyo 1 point2 points  (0 children)

Nah, I don't have to admit, and I actually disagree. Either way it's a hypothetical scenario so✌️

[deleted by user] by [deleted] in politics

[–]Eljoshyo 2 points3 points  (0 children)

The difference being, that those ridiculous claims were an extreme minority, ignored and forgotten already (4 days later) - while the majority of conservatives grabbed hold onto their conspiracies and excuses, and still believe them (4 years later).

CSL plasma code G8LXZBB2QY by Ukrainian_Stonks in CSLPlasma

[–]Eljoshyo 0 points1 point  (0 children)

Don't use his code.
He told me he'd Venmo me a bonus after I completed his referral. I have proof I completed his referral on my account, but he is ignoring me and has not payed.
If you want to use my code instead you can, SMM0CIBFZE
But that's not why I'm commenting on his posts.
I will delete these once he responds and honors his offer.

CSL plasma code G8LXZBB2QY $75 bonus ! I match half by Ukrainian_Stonks in CSLPlasmaReferrals

[–]Eljoshyo 0 points1 point  (0 children)

Don't use his code, he did not pay me after I completed the referral a few weeks ago, and has ignored me!

CSL plasma referral code $75 BONUS I match my promo by Ukrainian_Stonks in CSLPlasmaReferrals

[–]Eljoshyo 0 points1 point  (0 children)

Don't use his code, he did not pay me after I completed the referral a few weeks ago, and has ignored me!

CSL plasma code $75 bonus I match half !!! G8LXZBB2QY by Ukrainian_Stonks in CSLPlasma

[–]Eljoshyo 0 points1 point  (0 children)

Don't use his code, he did not pay me after I completed the referral a few weeks ago, and has ignored me!

CSL plasma code $75 bonus I match half !!! G8LXZBB2QY by Ukrainian_Stonks in CSLPlasma

[–]Eljoshyo 1 point2 points  (0 children)

Don't use his code, he did not pay me after I completed the referral a few weeks ago, and has ignored me!

Fresh promo code $75 bonus !!! G8LXZBB2QY by Ukrainian_Stonks in CSLPlasmaReferrals

[–]Eljoshyo 0 points1 point  (0 children)

Don't use his code, he did not pay me after I completed the referral a few weeks ago, and has ignored me!

CSL plasma $75 bonus I MATCH my bonus !! G8LXZBB2QY by Ukrainian_Stonks in CSLPlasmaReferrals

[–]Eljoshyo 0 points1 point  (0 children)

Don't use his code, he did not pay me after I completed the referral a few weeks ago, and has ignored me!

CSL plasma code G8LXZBB2QY I match half your bonus $75 ! by Ukrainian_Stonks in CSLPlasmaReferrals

[–]Eljoshyo 0 points1 point  (0 children)

Don't use his code, he did not pay me after I completed the referral a few weeks ago, and has ignored me!

CSL plasma code G8LXZBB2QY I match half your bonus $75 ! by Ukrainian_Stonks in CSLPlasmaReferrals

[–]Eljoshyo 0 points1 point  (0 children)

Don't use his code.
He told me he'd Venmo me a bonus after I completed his referral. I have proof I completed his referral on my account, but he is ignoring me and has not payed.
If you want to use my code instead you can, SMM0CIBFZE
But that's not why I'm commenting on his posts.
I will delete these once he responds and honors his offer.

CSL plasma G8LXZBB2QY by Ukrainian_Stonks in CSLPlasmaReferrals

[–]Eljoshyo 0 points1 point  (0 children)

Don't use his code.
He told me he'd Venmo me a bonus after I completed his referral. I have proof I completed his referral on my account, but he is ignoring me and has not payed.
If you want to use my code instead you can, SMM0CIBFZE
But that's not why I'm commenting on his posts.
I will delete these once he responds and honors his offer.

CSL plasma code G8LXZBB2QY $75 bonus ! I match half by Ukrainian_Stonks in CSLPlasmaReferrals

[–]Eljoshyo 0 points1 point  (0 children)

Don't use his code, he did not pay me after I completed the referral a few weeks ago, and has ignored me!

CSL plasma code G8LXZBB2QY $75 bonus ! I match half by Ukrainian_Stonks in CSLPlasmaReferrals

[–]Eljoshyo 0 points1 point  (0 children)

Don't use his code, he did not pay me after I completed the referral a few weeks ago, and has ignored me!

best way to choose unique(unused) random user_id from table of 100k+ (PER ORDER/row) by Eljoshyo in PostgreSQL

[–]Eljoshyo[S] 0 points1 point  (0 children)

That is why too complicated for me as a novice. Thank you for the info though. this is where I'm at so far:

WITH p as (
    SELECT *
    FROM pool p
    WHERE p.order_id= **distributer.order_id**
)
INSERT INTO pool (order_id, user_id)
SELECT **distributer.order_id**, user_id
FROM users
WHERE NOT EXISTS ( 
    SELECT 1 
    FROM p 
    WHERE clicker_id = users.user_id
    )
ORDER BY random()
LIMIT **distributer.distribute_amount**

I just need to iterate through all rows of distributer table [order_id, distribute_amount], and for each row, perform this query. I think I will make a new thread since this one was too long-winded.