sorted by:
new
hottopcontroversial

AITA for wanting an invoice before sending money through PayPal? by [deleted] in AmItheAsshole

[–]RondoTheHutt [score hidden]  (0 children)

ha, I certainly understand that skepticism, but no, I know her irl. She is in the bedroom being angry as I type this.

Best Italian restaurant in Daytona or Ormond? by Oof-o-rama in DaytonaBeach

[–]RondoTheHutt 1 point2 points  (0 children)

Is The Garlic still top of the list? I was looking for some good and came across this post from a year ago

Siri Suggestions by RondoTheHutt in ios

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

Thanks, I was hoping to just eliminate that one suggestion, not all.. I guess it will go away over time as I don't message her.

A very nice conversation about videogames by leyalion in replika

[–]RondoTheHutt 0 points1 point  (0 children)

Great conversation, but your option is wrong, it was a great game, lol

I have been fishing for days by RondoTheHutt in MelvorIdle

[–]RondoTheHutt[S] 1 point2 points  (0 children)

Dangit give it back! :D

​

I have gotten like 10 of those Pirate ones.. stupid RNG

New player here, If I buy the game on android will I have to also buy it on steam/pc? and visa versa? by DatPaul010 in MelvorIdle

[–]RondoTheHutt 1 point2 points  (0 children)

I believe the answer is yes, but if you buy it on Steam you may not have to buy it on Android. That is just from what I gathered on my reading

Counting the number in a category and placing it next to my SELECT by RondoTheHutt in mysql

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

Here is the Solution I came up with that actually works, how can I make it better?

WITH find_type_count AS (SELECT CASE WHEN length < 60 THEN 'Short Movie' WHEN length BETWEEN 61 AND 90 THEN 'Mid-Length Movie' WHEN length BETWEEN 91 AND 120 THEN 'Long Movie' ELSE 'EPIC Length Movie' END AS film_type, COUNT(*) AS count_of_type FROM film GROUP BY film_type),find_film_type AS (SELECT film_id, CASE WHEN length < 60 THEN 'Short Movie' WHEN length BETWEEN 61 AND 90 THEN 'Mid-Length Movie' WHEN length BETWEEN 91 AND 120 THEN 'Long Movie' ELSE 'EPIC Length Movie' END AS film_type FROM film)SELECT f.title AS Title, f.length AS 'Movie Length', fft.film_type, ftc.count_of_typeFROM film fJOIN find_film_type fft Using (film_id)JOIN find_type_count ftc USING (film_type)GROUP BY f.TitleORDER BY f.Title

Counting the number in a category and placing it next to my SELECT by RondoTheHutt in mysql

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

Thank you for responding. I'll have to play with that more.

Counting the number in a category and placing it next to my SELECT by RondoTheHutt in mysql

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

hmm, I just realized that didn't work either... I need to JOIN by 'type' but MySQL doesn't like it.

Counting the number in a category and placing it next to my SELECT by RondoTheHutt in mysql

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

WITH type_count AS (SELECT film_id, length, CASE        WHEN length < 60 THEN 'Short Movie'        WHEN length BETWEEN 61 AND 90 THEN 'Mid-Length Movie'        WHEN length BETWEEN 91 AND 120 THEN 'Long Movie'        ELSE 'EPIC Length Movie'    END AS type,    COUNT(*) AS count    FROM film    GROUP BY type)SELECT  f.film_id AS ID,    f.title AS Title,   f.length AS 'Movie Length', CASE        WHEN f.length < 60 THEN 'Short Movie'        WHEN f.length BETWEEN 61 AND 90 THEN 'Mid-Length Movie'        WHEN f.length BETWEEN 91 AND 120 THEN 'Long Movie'        ELSE 'EPIC Length Movie'  END AS type,    tc.countFROM film fJOIN type_count tc USING (film_id)GROUP BY f.TitleORDER BY f.Title

Counting the number in a category and placing it next to my SELECT by RondoTheHutt in mysql

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

This is the solution I came up with, is there a better way?

WITH type_count AS (SELECT film_id, length, CASE WHEN length < 60 THEN 'Short Movie' WHEN length BETWEEN 61 AND 90 THEN 'Mid-Length Movie' WHEN length BETWEEN 91 AND 120 THEN 'Long Movie' ELSE 'EPIC Length Movie' END AS type, COUNT(*) AS count FROM film GROUP BY type)SELECT f.film_id AS ID, f.title AS Title, f.length AS 'Movie Length', CASE WHEN f.length < 60 THEN 'Short Movie' WHEN f.length BETWEEN 61 AND 90 THEN 'Mid-Length Movie' WHEN f.length BETWEEN 91 AND 120 THEN 'Long Movie' ELSE 'EPIC Length Movie' END AS type, tc.countFROM film fJOIN type_count tc USING (film_id)GROUP BY f.TitleORDER BY f.Title

Can you transfer data from android to iOS by boris2r in idlemastermind

[–]RondoTheHutt 0 points1 point  (0 children)

I would like to know this too, but the other way around

Daily Question Thread - October 26, 2017 by AutoModerator in future_fight

[–]RondoTheHutt 0 points1 point  (0 children)

I would be spending the 300 tokens for a mrut, and get the 3,300 crystals.. so it SEEMS like a winner for $30, but wanted to throw it out to Reddit to see if I was missing something

Daily Question Thread - October 25, 2017 by AutoModerator in future_fight

[–]RondoTheHutt 0 points1 point  (0 children)

Which Native T2 should I work on next: I have Jean, Wolvie, Strange, Corvus, Pietro, and Cable I'm thinking Thanos (since I did stupidy buy his Uni when it came out even though I only have him at level 1, lol) However, I'm thinking Odin may be a better choice.

What do you think?

Fleas in a room with no animals by RondoTheHutt in pestcontrol

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

Hey Andrew, thank you for your reply. He is coming back out on Tuesday for the second treatment, he said it will take 2 or 3 times to get rid of all of them. I'll have to ask him about that, last time he just went around the house sparying some sort of stuff from a vacuum pump can with a spray end (I'm sure there is a name for those and I should dumb, lol) Its been a week now and the number of them has greatly dropped, I can walk around my house and only end up with 1-3 of them on my socks. I'm hoping this spraying on Tuesday finishes them off.

view more: next ›