Can You Start Dating While You Are Separated? Futeral ...
South Carolina Dating, Singles and Personals Match.com®
South Carolina free dating site - online dating in South ...
Gay Dating by Location - AllMale
Dating Singles In Greenville, SC - Greenville Personals In ...
100% Free Online Dating in Summerville, SC - Mingle2
11 Best “Rich Men” Dating Sites — (That Are 100% Free)
Spartanburg Singles & Personals: Free Online Dating & Chat ...
Free Gay Dating . Gay Online Dating By Location View profiles from all over the world or look for a specific location. AllMale brings men from all over together in new ways. Browse local guys below or select a region you wish to view. Register for free, share as much or as little as you'd like and become part of a quickly growing online community. Here's where you can meet singles in Spartanburg, South Carolina. Our Spartanburg County singles are in the 864 area code, and might live in these or other zip codes: 29306, 29301, 29319, 29302, 29304, 29305, 29307, or 29303 personals. There are thousands of active singles on DateHookup.dating looking to chat right now. Dating South Carolina is an online dating site created for single people in South Carolina. Simply join for free and begin using the site to date, meet new friends, date and find love - all local to you. The best dating sites offer their services to help all kinds of people find love and Dating South Carolina does exactly that, so join for free ... Summerville's best FREE dating site! 100% Free Online Dating for Summerville Singles at Mingle2.com. Our free personal ads are full of single women and men in Summerville looking for serious relationships, a little online flirtation, or new friends to go out with. Start meeting singles in Summerville today with our free online personals and free Summerville chat! A popular dating site for rich men, as well as an app, Luxy has a lot to offer the elite single community — including 100% free registration, advanced swiping technology, and a history of more than 21 million matches. Luxy’s user base is made up of businessmen and women, lawyers, and investors from all over the world who’ve achieved a ... South Carolina Dating is a local dating site for people looking to find love and friendship online in South Carolina. With online dating now cementing itself as a proven method for single people to meet, date and form new significant relationships we thought it would be beneficial to list some advantages of using dating sites like South ... South Carolina Dating: Browse South Carolina Singles & Personals. Palmetto State of South Carolina. We are a South Carolina personals site making your online dating experience the best. Want to know how Harry met Sally? She found him in a personals ad on Match.com's South Carolina personals website. South Carolina free dating site for singles in United States! Join one of the best online dating site among other 100% free dating sites and meet single men and women in South Carolina (United States). Meeting members at our dating service is totally free. Just add your profile, browse other personals of peple seeking like you for online dating, love and romance. Free Dating In Greenville, SC - Greenville Singles In South Carolina. Welcome to LetsHangOut.com! Meet dating singles in Greenville, SC and areas nearby (50 miles). View and chat with local dating profiles and personals on our 100% free Greenville dating site or use the links below to view nearby single men and women elsewhere in South Carolina. In South Carolina, adultery is considered to be “marital misconduct” and can negatively affect your divorce in many ways including: Dating’s Impact on Alimony – If a spouse commits adultery before (1) the formal signing of a written property or marital settlement agreement or (2) the entry of a permanent order of separate maintenance ...
2013.03.04 20:36 splattypusAskreddit's Think-Tank
Please submit ideas for askreddit to the askreddit mods directly by messaging the mods. Thanks!
2020.09.19 01:20 subpolarbearInsurance has failed to act. Should we seek legal action? South Carolina
My girlfriend owns a couple of properties in SC and recently ran into an issue. She wants to file a complaint with the BBB in order to inspire action. I’m trying to convince her that won’t do much. Does she have any legal ground to stand on? Should we contact a lawyer? Below is the email she is planning on sending that should outline the situation in full: Hello, My name is (name) and I filed my claim (claim #) on 6/4/2020 for issues with my air conditioning unit at my property at (address) A few days after submitting the claim I reached out to the technician because I hadn’t heard anything and was able to schedule an appointment for the following week with a service fee of $100. He then determined that the unit needed to be replaced. HWA finally approved the replacement on 6/23/2020 and gave me the option to take cash to replace the unit, $1950 or have them replace it and pay for the additional non-covered charges, $700. I responded on 6/25/2020 that I did not want the cash out option and I would accept the non-covered charges. Since then I have not received any information from HWA on progressing the claim and have called at least ten times over the last four months. Below is a list of call dates and minutes. Note that I do not have any June call information as my phone records did not go back that far. I would estimate two or three calls in June. Call Date - minutes 9-Jul - 15 min 14-Jul - 6 min 17-Jul - 12 min 28-Jul - 13 min 6-Aug - 17 min 11-Aug - 15 min 13-Aug - 8 min 20-Aug - 10 min 31-Aug - 16 min 16-Sep - 122 min I am very disappointed in how HWA handled this claim and especially as a rental property investor, I like the idea of having a reliable home warranty on every home I purchase. However when the warranty company takes almost four months to replace an air conditioning unit in one of my rental properties, it is unacceptable. This happened in the peak Summer months of South Carolina where we consistently had temperatures in the high 90s, so of course in addition to discounting rent for a total of $1100 over the past four months, I had to spend $1000 for two portable AC units for my tenants. I will also have the HWA non-covered charges of $700 to pay when/if the unit actually gets installed. I am not normally a person who complains about anything, but based on my experience with HWA, I feel like I am forced to submit a review and complaint with the Better Business Bureau. Throughout these past four months, HWA has given me no indication that they intend on replacing my HVAC unit in a timely manner. Lately I’ve been seriously questioning whether or not it will be replaced at all. The first good news I’ve heard was when I called HWA on 9/16 and confirmed that the unit had finally been ordered and needed to be picked up by the service provider. But besides this good news, my experience with HWA has been overwhelmingly negative and has cost me a fortune in lost rental income and other expenses. So based on all the reasons above, I request that HWA reimburse me for the following expenses including: the loss of rental income, the cost of the portable HVAC units, the non-covered costs of the claim and the service charge for a total of $1100+$1000+$700+$100 = $2900. Additionally, I expect the HVAC unit to be installed by October 9th. This is the last chance I am giving HWA to respond before I submit my review and complaint to the Better Business Bureau on September 25th and subsequently pursue legal action. Hope to hear back soon.
Hey guys, Selling two components of my current PC. Looking to upgrade over the next few months to some of the newer tech and thought I'd sell these now as I am currently not playing any games on PC. Both parts were purchased directly from a retailer, and I've included the receipts with the original purchase date.
Neither part was used for mining / crypto. They've been used mainly to play PC games and as my work computer. I am local to Houston, TX. If you are willing to meet up locally I'll be willing to take a lower price. Please message below before PM, thanks! Edit: Please DMs only, no chats.
This update has been a little bit tricky, because it's hard to update a filter with SO many new items, without ever playing the league. Expect adjustments to the filters within the first day, once we get to know the league a little bit. That being said, it still contains a LOT of other improvements, such as the vastly improved rare tiering and some improvements to identified item tiering and I'm also working on a MASSIVE 8.0 update. More on that during the next weeks. Please note that if the servers will be overloaded (because there's 10k people on the site trying to do things at the same time), ease down and try again soon! Ladder filters will be updated in 10-20 minutes, still building. https://filterblade.xyz/ - is of course also updated! Want to watch me code/poe, get live updates or support the project?: [PATREON] [TWITTER] [DISCORD] [TWITCH] [GITHUB] [FAQ]
Recommended way of downloading the filter. Has support for all strictness, styles and economy versions! Includes overview, explanations and a loot simulator. Experienced users can also edit filters there comfortably and merge their changes into new versions. Always up-to-date!
Mostly for developers: you can also get the filters from GitHub! There's a SC, HC and stable/static branch
The Filter changelogs can always be found here: CHANGELOGS The FilterBlade changelogs can be found on the FilterBlade discord: DISCORD
Filter and Styleversions
Higher strictnesses filter more items. The general rule is that: the faster you are, the less you want to pick up, because in the time you'd take care of a higher quantity of items, you can kill more monsters and get a higher chance at expensive loot and experience. You can start with RegulaSemi-Strict first (great for new players and leagues) and simply up the strictness from the option menu, once you feel like you want to see less.
Shows too much. Includes low crafting bases, magic jewellery in the endgame. Not recommended for regular gameplay.
Shows a lot. Recommended for beginners, new leagues and slow-clearing gameplay. Shows all rares. Good for chaos recipes.
Healthy balance. Great for new leagues and beginners and medium-speed endgame gameplay. Hides the worst rares. Good for chaos recipes.
Hides bad-base rares and scrolls in the endgame. Disables most recipes. Recommended endgame strictness.
Hides most rares, scrolls, augments, armourers. Good for the endgame and for farming once your character is well equipped.
Hides all low currencies and rares. Great for speed-farming, once you have a highly optimized build and atlas! Hides maps of tier 10 and lower.
Shows too little. Sterile screen. Hides all kind of stuff, including mediocre divination cards, all kind of crafting material etc. Recommended for high-speed clearing, once your character is top tier geared, your atlas complete and optimized and you're breezing through maps very fast! Hides maps of tier 13 and lower.
Styles have no effect on how strict the filter is, but change the visual and audio configuration. Find one that pleases your eye most or make your own on https://www.filterblade.xyz . FilterBlade also comes with a preview comparison/feature for styles and strictnesses.
Special thanks to...
Tobnac and Haggis - the 2 others minds behind filterblade + great friends
A special thank you to all the Patreons! A special thanks goes to: Ryndaar, Phegan, Matt O.,Henry G., Reilly M!
New Batch is starting for M.A / M.Sc Psychology Entrance Coaching. Batch commencement date: 25th September 2020 We are also offering free 1 month Workshops with this MA / MSc Psychology Entrance preparation 2021. Enroll Yourself till 23rd September and Get Extra Benefits. Contact us for more details: UPS Education Ph: 9990717772 Web: www.upseducation.in
Apparently this contest is supposed to be super fun, but we just use it to identify which one of you sucks more than the other and award him a title of shame. People actually believe that this contest is a fun way to guess the outcome of games before they take place by answering shitty questions. Points get added up, you get to lose and see us win. No real prizes are awarded, but it does help identify who sucks the least in the subreddit. Please read the rules if you have not already. They are similar to the rules from 2019 but have a few changes. Lucky Guess threads will be put up before each game, usually the night before. Trash talking in the comments is permitted (encouraged), however excessive bitching and complaining may result in a system failure that somehow lost all of your points. If you have any questions, leave them in the comments and someone might answer. You can also PM one of the gamemasters: KevPat23. Good luck jerks!
Due to the shortened season we will only have one leaderboard! Remember to continue to look for the Lucky Guess Thread before the game, subscribe to our /BJLG subreddit or sign-up for the mailing list!
2020.09.18 13:49 caucafinousvehicle[WTS] new HESCO 4401 set of 2 2020 man. date $300 shipped (SC)
Had these sold to a buddy but he had to back out so selling my Hesco 4401 set brand new 02jun2020 manufacture date never left the house, dropped, or wet. Get em while they're hot. $300 shipped TODAY paypal ff with low flair you pay g&s otherwise. Sold https://imgur.com/a/aneG1Vn ignore the other stuff it's another post. Back side https://imgur.com/a/lKBMnCt
2020.09.18 13:09 PiggySVW14 currently active Munich-born footballers have received a call up to a national team. None of those was from Germany. Here are their stories.
While searching some stuff on Transfermarkt, I discovered that there are 14 currently active football players who were born in Munich and have been called up for at least one senior national team fixture. Funnily, not a single one of those 14 players was called up to the German Nationalmannschaft. I decided to take a closer look at their respective careers. There are some more obvious paths like Germans of Turkish descent who went on to play in and for Turkey but also some pretty obscure careers. I begin with the most capped player and work my way down the list to the players who only got a call up without getting any game time. I sincerely hope you enjoy this read, it was pretty fun to write down!
Age: 32 Position: Left Winger Current team: - National team: USA (57 matches, 2 goals) The most-capped player in this list is American international Fabian Johnson. He was born in 1987 in München-Giesing and started his footballing career playing for Sportfreunde München before making the switch to 1860 where he spent 13 years. In 2009, he began his career in the 1. Bundesliga with Wolfsburg. Until today he made over 200 appearances in Germany's top flight for the Wolves, Hoffenheim and Gladbach. Currently he's without a club as Borussia didn't want to extend his contract. The defensive-minded winger played for all the DFB youth teams and even won the under-21 Euros in 2009 alongside players like Mesut Özil, Mats Hummels or Manuel Neuer. However, Johnson - son of a German mother and an American father - stated that he "always felt quite American", so it's no wonder that he accepted the invitation when USMNT coach Jürgen Klinsmann called him up to the US squad in 2011. Since then he participated in the World Cup 2014, the Copa América 2016 and several Gold Cups. His last international game to date was in September 2017.
Age: 28 Position: Central Midfielder Current team: United City F.C. National team: Philippines (51 matches, 4 goals) "Manny" Ott also represented 1860 München during his youth career before eventually ending up at FC Ingolstadt's academy in 2009. He spent five year's in the Audi city before going to his mother's home country to play for Ceres-La Salle FC, who are now called United City F.C. He won several titles with the Filipino powerhouse and in fact returned to them in February 2020 after a wasted year in Thailand where he only managed to play one single game for Ratchaburi Mitr Phol F.C. due to a tibia fracture. Ott played his first senior game for the Philippines on 16 January 2010 at only 17 years of age. A scout had been sent out to find players in Europe who are eligible for the Filipino team. The midfielder's first goal followed in a 3-0 win over Cambodia in 2014.
Age: 25 Position: Attacking Midfielder Current team: United City F.C. National team: Philippines (21 matches, 3 goals) Another one? Yes! Mike Ott followed his big brother's footsteps and also graduated from 1860's youth system before joining Nürnberg in 2014. He was unable to impress in the first team and instead played for Nürnberg's under-23 team in the fourth tier. After three seasons, he decided to start on an adventure in Asia instead, so he made the switch to Angthong F.C. in Thai League 2. He had a decent stint in Thailand which made his brother's club Ceres offer him a contract in 2018. The new owners changed the team's name but re-signed both brothers in this summer. What are the Otts? Mike was part of the Filipino national team for the first time in 2013 but didn't get to enter the pitch. His debut actually only came in October 2016 against Bahrain and he even scored the goal in his team's 1:3 loss.
Age: 30 Position: Attacking Midfielder Current team: - National team: Turkey (12 matches, 0 goals) "Memo" Ekici began playing football for former Bundesliga outfit SpVgg Unterhaching, but he quickly became a member of FC Bayern's youth system. He made it onto Bayern's bench in 2009/10 but never played a minute for Bayern's senior squad. For the following season he was loaned out to fellow Bundesliga team Nürnberg where the young talent impressed alongside fellow German Turk Ilkay Gündogan. While the latter was bought by Borussia Dortmund, Ekici went to Werder Bremen. He never really broke through in the Hanseatic city and was eventually sold to Trabzonspor in 2014. In his first season he scored 9 goals and assisted another 11, but he couldn't replicate those numbers afterwards. In early 2017 he was suspended by Trabzonspor because he insisted on a transfer to Fenerbahce instead of Besiktas which Trabzonspor preferred. When his contract ran out after the season he finally joined Fener and played there until last season, albeit with mediocre success. Ekici played for the German youth national teams before the Turkish FA convinced him to play for them after his strong start to the 2010/11 season. He debuted against the Netherlands in November 2010 but never managed to play a major part in the Crescent-Stars' team. His last appearance to date was in 2015.
Age: 32 Position: Defensive Midfielder Current team: Alanyaspor National team: Turkey (6 matches, 0 goals) Gülselam spent the 1994/95 season at mighty Gartenstadt Trudering before spending 8 years in FC Bayern's junior teams. In 2006 he went to Unterhaching where he experienced his first games in 2. Bundesliga. They were relegated, but Gülselam still stayed for another season. He seems to have impressed some Turkish scouts as Trabzonspor decided to pick him up in 2008. Since then he has been playing for several teams in the Süper Lig with his current employer being Alanyaspor. Between 2014 and 2016 he spent two seasons in the Bundesliga at Hannover 96, he scored his only Bundesliga goal in a match against Leverkusen in November 2014. Gülselam made his debut for the Turkish national team in March 2008, when coach Fatih Terim called him up for a friendly against Belarus. His last match took place nearly 11 years ago, he assisted a goal and was sent off shortly afterwards against Armenia.
Age: 29 Position: Right Back Current team: Adana Demirspor National team: Turkey (6 matches, 1 goal) Camdal spent most of his footballing youth in Ingolstadt, playing 8 years for Türkgücü Ingolstadt before going to MTV Ingolstadt at 13 years of age. When they played against 1860 Munich's youth team, the Lions' people in charge were so impressed that they offered Camdal a transfer right after the game. In 2009 he made his debut in the 2. Bundesliga and made several apperances in the senior team until 2011. For the season 2011/12 Süper Lig team Eskisehirspor decided to bring him to Turkey. He spent 3 seasons in Eskisehir before going to Galatasaray where he even got to play in the Champions League. He was loaned back to Eskisehir in 2016/17 but the loan didn't really help him with establishing himself at Gala. After several quarrels his contract was terminated in early 2019 and he went to Antalyaspor for the remainder of the season. Today he plays for Adana Demirspor in the second tier. Camdal played for DFB's under-19 team but later decided to kick the ball for Turkey. His first of six call-ups to the national team was in November 2013 after a strong start of the season with Eskisehirspor. His last match followed about one year later. During his time in the national team he scored one goal in a friendly against Ireland.
Age: 27 Position: Left Midfielder Current team: USV Eschen-Mauren National team: Liechtenstein (5 matches, 0 goals) Ospelt is yet another graduate of FC Bayern's youth where he played up to the under-19s. In 2010 he went to play for FC Buchs and later Young Fellows Juventus in Switzerland's lower leagues. In January 2012 he transferred to USV Eschen-Mauren, a team from Liechtenstein that - like all the outfits from the tiny country - play in the Swiss league system. Liechtenstein's only competition is the Liechtenstein Cup, which Ospelt and his colleagues went on to win in 2012. In 2013 he was picked up by Liechtenstein's best team FC Vaduz where he played until 2018 - with the exception of a short stint at WSG Wattens in Austria in 2016. After taking a short break, Ospelt returned to football in early 2019. He now plays for Eschen-Mauren again, currently in the fourth tier of Swiss football. Ospelt's record for the national team is very weird. His first match was in 2012 against Lithuania, his second and third followed in 2016 and the fourth in 2017. His last appearance to date was last week, when Liechtenstein won 2:0 against powerhouse San Marino. However, Ospelt never started a match, in fact his longest appearance was three minutes long. If you add up all his minutes since he was first called up 8 years ago, you get a whopping NINE minutes of time on the pitch.
Age: 29 Position: Left Winger Current team: FC Bologna National team: Italy (3 matches, 0 goals) Nicola Sansone's career began in Eastern Munich, at SV Neuperlach. He then played for FC Bayern from 2002 until 2011. He made his debut for Bayern's under-23 team in February 2010 when he came on as a substitute for none other than David Alaba. In October 2010 he got to spend 90 minutes on the bench of the Bundesliga squad in a match against Freiburg. From 2011 on he was a Parma player, although he spent his first season on loan at Crotone. He had a decent spell both there and later in Parma which made Sassuolo buy him in early 2014. After two and a half very successful seasons Sansone was picked up by Villareal who paid 13 million € for the German Italian attacker. He had two pretty good seasons in La Liga, however things didn't work any more in 2018/19 which made Bologna loan Sansone during the winter transfer window. He is a key player in their squad ever since as the team from Emilia-Romagna decided to make the deal permanent in the following summer. Sansone never really considered to play for Germany as he played for the Italian junior teams from under-17s up until the under-21s. Thanks to an impressive time at Sassuolo, coach Antonio Conte called Sansone up to the senior team in 2015, when he made his debut as a subsitute against Portugal. He was able to add two more matches to his tally in 2016, the last one being against his country of birth - Germany.
Age: 26 Position: Central Midfielder Current team: SpVgg Unterhaching National team: Georgia (2 matches, 0 goals) Hufnagel's first team was TSV Milbertshofen in the north of Munich. In 2001 he was picked up by FC Bayern where he spent ten years of his early footballing career. In 2011 he went to FC Ingolstadt only to transfer to SpVgg Unterhaching one year later. He slowly established himself as a key player in Unterhaching's senior team which made SC Freiburg sign him for their 2015/16 2. Bundesliga campaign. He got quite a bit of game time, but that changed after Freiburg's promotion in 2016. Hufnagel was demoted to the second team and consequently loaned out to Nürnberg in January 2017. However he failed to leave a real mark there as well and finally returned to Unterhaching in 2018 to play in the 3. Liga. He is a staple in their squad, having played well over 2000 minutes in both of the last two league seasons. Hufnagel never had a real chance to become a German international however he was eligible for Georgia as well because of his Georgian mother. He made his debut in 2015 against Estonia and played another 4 minutes against Serbia in 2017. Before his senior debut he already played some games for the country's junior teams.
Age: 25 Position: Right Back Current team: 1. FC Köln National team: Nigeria (0 matches, 0 goals) Ehizibue was born in Munich to Nigerian parents. When he was two years old, the family moved to Zwolle in the Netherlands. He played for local club CSV '28 before joining PEC Zwolle's youth system from which he later graduated. He made his professional debut in October 2014 in a cup game and played his first Eredivisie game two months later against Willem II. Since 2016 he was a permanent member of the first team and managed to become a key player. In 2019, after their promotion to the Bundesliga, 1. FC Köln picked him up and gave him a chance to shine in the country of his birth. He instantly became Cologne's starting right-back and played in 31 out of 34 possible league games. Ehizibue played one match for the Dutch under-21s in 2016, which remains his only international experience to date. However, Nigeria's coach Gernot Rohr called him up to the Super Eagles' AFCON qualifier against Sierra Leone back in March. But due to the pandemic the fixture is yet to be played.
Age: 28 Position: Right Back Current team: Fatih Karagümrük National team: Turkey (0 matches, 0 goals) Altintay's career began at SC Fürstenfeldbruck, where he stayed until he was 19 years old. After one squeezed in year at FC Bayern under-23s, 2. Bundesliga team Jahn Regensburg picked him up in 2012. He left the Jahn again in 2013 in order to play for Caykur Rizespor in the Süper Lig. He was a regular starter for them and managed to impress the scouts of Osmanlispor who signed him in 2016. He played some matches for the Ankara-based outfit, including one Europa League group fixture, but ultimately failed to establish himself. As a consequence he returned to Rizespor in early 2018 to help them to get back into the Süper Lig after their recent relegation. They indeed clinched promotion but Altintay failed to prove himself again in the following 2018/19 campaign. In September 2019 he joined Fatih Karagümrük and was an important part of their successful 1. Lig campaign. Altintay scored a goal in the promotion play-off semi-finals, Karagümrük went on to win the final in a thrilling penalty shoot-out and get back into Süper Lig after 36 years of absence. After a strong start in 2013 with Caykur Rizespor, Fatih Terim let him join the Turkish national team for two friendlies against Northern Ireland and Belarus in November. However, he didn't get any time on the pitch and was never nominated again.
Age: 26 Position: Goalkeeper Current team: FC Juárez National team: Peru (0 matches, 0 goals) There's not much information about Alejandro Duarte's youth on the internet. With his full name being Alejandro Christoph Duarte Preuss, I reckon that he probably has a German mother. However, he spent his first years as a goalkeeper at the FRAMA football academy in Lima before joining Esther Grande de Bentin, a semi-professional club from the suburbs of the Peruvian capital. In 2010, he returned to Germany to play for Bayer Leverkusen's under 17 team. He left the Werkself again in 2011 and continued to play for Juan Aurich's junior team in Peru before breaking into their senior squad. He made his first league debut in 2013 in a 1:1 draw against Inti Gas. He went on to join Club Cienciano in 2015 and later Deportivo Municipal in 2016 but didn't get much game time at either club. This changed when Duarte was signed by USM Porres in 2017. Duarte finally got to play more games between the sticks which secured him move to Mexico in 2018 when Lobos BUAP decided to sign him. After an unsuccessful stint at the team from Puebla, the keeper joined FC Juárez but was immediately loaned out to Club Atlético Zacapetec in the second league. He was their main goalkeeper, however the club was dissolved and he recently returned to Juárez. Duarte was called up for Peru's friendlies against Croatia and Iceland in March 2018. He wasn't granted any game time however. Thus, his three matches for Peru's under-19s remain his only international appearances.
Age: 23 Position: Goalkeeper Current team: LA Galaxy National team: USA (0 matches, 0 goals) Klinsmann junior was born during his father Jürgen's time at FC Bayern. His mother is an American model. Jonathan shortly lived in Genoa when Jürgen played for Sampdoria before the family moved to California after Jürgen's career. Jonathan started his career as a striker for FC Blades 96 and Irving Lasers. In 2008 he followed his father - who accepted a job as FC Bayern head coach - back to Germany and was retrained into a goalkeeper by FC Bayern's academy. After his return to California, Klinsmann played for Pateadores and Strikers FC in the US Soccer Development Academy. He also represented his high school between 2011 and 2014 and later played for the California Golden Bears, Berkeley university's college team. During the summer of 2017, Klinsmann had several trials at European teams like VfB Stuttgart, West Ham and Everton. After another trial at Hertha BSC, the capital city club signed the American. He played one match for Hertha's senior team - a Europa League fixture against Östersunds FK - and he even saved a penalty. He joined St. Gallen in 2019 where he became the goalkeeper for the Swiss Cup matches. However, he got red carded in the second round and the team got knocked out by FC Winterthur. In August 2020 Klinsmann joined the LA Galaxy. Klinsmann played for various US youth teams before being called up to the senior USMNT in November 2018. He was an injury replacement for Zack Steffen for the team's friendlies against England and Italy but ultimately stayed on the bench.
Age: 20 Position: Central Midfielder Current team: Bregalnica Stip National team: North Macedonia (0 matches, 0 goals) Osmanoski played for 1860 München until he was 13 years old. He then transferred to SpVgg Unterhaching's youth teams and stayed at the club until 2019 when he decided to move to his parents' home country North Macedonia. He now plays for Bregalnica Stip in the Eastern group of the Macedonian second division. They finished the season in second place, barely missing out on promotion. To be honest, I can't tell you much more about his career as he's still very young and there's not that much information on the second tier of Macedonian football. Osmanoski played for several junior national teams of his country and is in fact a current member of the under-20 team. However, he was called up for a friendly of the senior national team in 2017 when he was just 17 years old. Macedonia - back then still without the "North" - won 2:0 against Norway but little Osmanoski did not get any minutes on the pitch with the big guys.
2020.09.18 11:02 autotldr‘Insidious attempt to vilify Muslims’ — SC stops Sudarshan News from airing ‘UPSC Jihad’ show
This is the best tl;dr I could make, original reduced by 89%. (I'm a bot)
"As a Supreme Court of the nation, we cannot allow you to say that Muslims are infiltrating civil services. You cannot say that a journalist has absolute freedom doing this," a bench of Justices D.Y. Chandrachud, Indu Malhotra and K.M. Joseph observed verbally, brushing aside arguments of Sudarshan News. "The SC said in its order:"There will be no telecast of the show in continuation of the shows already telecasted either under the same or a different caption. Also read: Not just stay, need action against Sudarshan News for 'UPSC jihad' show, say ex-civil servants. The SC, which on 28 August - the first date of hearing - refused to impose a pre-telecast ban on the show, had issued notices to the channel, Press Council of India and News Broadcasters Association. The Delhi High Court, which had originally stayed the telecast on 28 August, had later asked Sudarshan News. Before the top court, Divan resisted the pre-broadcast injunction, saying there was no case to interfere based on the slides of the show presented by the petitioner.
2020.09.18 07:07 Substantial-Rock-513CERB "Reduced Hour" for Part-Timer
Really sorry if this was answered before but my situation is , well, situational and really confusing for me and I did some digging but no sure answer. I applied for CERB for Aug 30 - Sept 26 with CRA. My boss finally decided to rehire me on Sep 12. How does the "Reduced Hours Due to COVID" clause work? I didn't make any money or work from Aug 30 - Sep 12 since I was still temporarily laid off due to COVID. For sure I will not be making $1000 by September 26. Back then I would make just a bit over $1000 every month. My hours have been reduced this week. Whereas I was working 26 hours or more a week back then, I only got 16 hours a week since I started. But starting next week, I might be getting similar hours before my layoff from COVID. Does the reduced hours have to be for every single week/day or does it count the whole period and how do I know it's due to COVID? Is there a way to verify this or something? Like if I worked a Friday shift from 5pm - 11pm now and a Pre-Covid Friday shift back then from 5:30pm - 11pm but my overall paycheque for this week is lower than pre-Covid does that void the whole reduced hour thing because my Friday shift was higher? Like, could they have made this anymore confusing lol. I mean I have to pay my bills this month and I am so screwed if I have to return it since I had no way of making money from Aug 30 - Sept 12 since I was temp laid off. Seriously!!!! Why does it have to be an Einstein project. People's livelihoods are at stake and they decide to be vague about this. In all seriousness, though, help would be appreciated and sorry if this question is commonplace. To summarise:
I was still Temp Laid Off from Aug 30 - Sep 12. Applied for CERB for Aug 30 - Sept 26 not knowing I was going to be rehired
Rehired on Sept 12 and worked reduced hours from Sept 12 - Sept 19
Work somewhat normal hours from Sept 20 - 26
Making like $574 Gross Income this period as opposed to my usual >1000 monthly pay and I don't even get $350 of it until October 2. So in total, I'm only getting paid $224 From Aug 30 - Sept 26 from my job before taxes. (Does it count only your Gross for the Period or Hours worked?)
CRA doesn't have any way to report anything. And finally, do I have to return it? Am I screwed just because I got called back to work unexpectedly. Thanks in advance, Substanial-Rock-513 Edit: I've phoned CRA and Service Canada and told them my situation. They looked into my situation in detail and they both said I was entitled to it. Also asked them a few questions and got some answers. All of this occurred on September 18, 2020 at around 11am. Here are the things I found out when talking to both of them about the matter:
The "reduced hour clause" applied to full-timers or people working for more than 35 hours per week and have had their hours reduced. Both CRA and Service Canada have mentioned this. In particular, they both mentioned 35 hours. I asked them what it meant for Part-timers who worked less hours and if the reduced hour applied to us and they said that it did not and basically we just have to make less than $1000 at the period we are applying for. Sounds flawed but it gives a LOT of leeway for people working part-time if that's the case. Unfortunately, I forgot to delve into the specifics like what if someone worked one week for 35 hours and the rest less. You'll have to phone them yourself and get confirmation.
Since I was rehired after sending an application 2 weeks prior while still laid off and have made less than a $1000 for the last 2 weeks, I was entitled. When you get rehired you can still apply/keep the CERB as a part-timer as long as you are making less than $1000 for that period. You must have also already been on CERB for the previous period and have met all requirements for that previous period. For instance, if you applied for CERB and got rehired at a later date during the same period you applied for CERB, you are still entitled so long as you are making less than $1000 until the end of that period and if you've already received CERB for the previous period. Whether or not you work reduced hours as a part-timer doesn't matter according to CRA. In my case, I was collecting CERB from May until now. I was still in a state of being laid off for the first 2 weeks for this period and only had the opportunity to work for 2 weeks out of the 4 weeks. However, as long as I make less than $1000 during those last 2 weeks that I did work, I qualify.
And a nice tidbit they gave me was that if you pass the $1000 by a little ($1050-1100) they won't audit you. This is Gross Income, by the way. They give a little leeway so it looks like they're not totally strict. I'm sure they're going to check if someone went intentionally over 1000 or not and see if those were little errors. Still risky but it's nice to know that small mistakes might be reconciled. I wouldn't risk it, though
Hope this helps and Thank you. Also, please don't completely take my word for this as these were the exact things that CRA and SC have told me (was typing it while they were on the call lol.) Always follow up and call before applying! They won't bite.
I’m on maternity leave for a year which basically means my social life is park dates, pram walks, and brunch. It’s a tough life! What are your casual outfit go-tos to honour your SC lines? I tend to live in active wear or skinny jeans with a tucked in T. It’s not particularly exciting, so please hit me with inspiration, I beg you! Sincerely, a tired mama that wants out of maternity wear and to feel at least semi put together, some of the time! ETA: Bonus points for any go-to brands that are available in Australia!
2020.09.18 03:45 ajninomi(Spoilers Published) Byron and Morgarth
Alright, this is a long one and it might sound kinda far-fetched AT FIRST but bear with me here. There's a lot foofevidence and I haven't seen this theory anywhere before, but I think I've figured out the identities of the two hedge knights who appear with Shadrich in service to Littlefinger at the end of AFFC. Personally, I believe that Ser Shadrich of the Shady Glen is Howland Reed, come to rescue Sansa Stark, but that isn't necessary to understanding the main idea here, although it adds some supporting evidence. These twolinks, by u/theRockefellers and u/M_Tootles will get you acquainted with that theory if you aren't already. I don't agree with everything they say, but I do think Howland=Shadrich; and I have some new insights to add but everyone is tired to death of HR=? theories so I'll put my thoughts at the end of this post. Again, Howland=Shadrich isn't necessary to agreeing with the central idea of THIS post which is; Edric Dayne, Lord of Starfall and Pello of Tyrosh aka Greenbeard have assumed the names Byron the Beautiful and Morgarth the Merry while they search for Arya and Sansa Stark. EDRIC DAYNE Last seen in POV: pissing Arya off by bringing up a possible love interest of Eddard Stark (Ashara Dayne). Arya runs off into the arms of the Hound later that day and is never recaptured by the BWB, although they later will hear she was alive with the Hound at the Inn of the Crossroads before 'the Hound' commits the atrocity known as the Rape of the Saltpans (where Arya was last seen heading). Last probable location: by Beric Dondarrion's side when he gave his life to Catelyn Stark/Tully and raised her from the dead. I don't think he would've left Beric before he died (Edric is Beric's squire), but he has left Lady Stoneheart's group by the time we see them in Merrett's epilogue in ASOS. I doubt Beric kissed Catelyn without knowing he was going to die, and so he probably said some last words and/or did a final action (like knighting his squire?) before his death. The point of Edric's potential knighting/Beric's final death is that it frees Edric Dayne, the young Lord of Starfall, to leave the main group of the BWB. This might be his first chance to choose his own path. And, if he doesn't just leave on his own, the BWB/Lady Stoneheart and Edric's motivation's might align. It seems clear that Areo Hotah will be the reader's first person POV of Starfall (Gerold Dayne is heading there, with Hotah and crew following), so Edric's story will probably continue somewhere else. Motivation Given that he feels guilty over angering Arya (he apologizes profusely but Arya doesn't want to hear it), logically he might go looking for her (or failing at that, another Stark daughter). This is supported by the fact that when Lady Stoneheart captures Merrett Frey, the BWB is looking for the Hound and Arya. Edric Dayne (newly made knight?) could easily have volunteered to go on one of these BWB missions, or he could set out on his own adventure with the same goal. His motivation could be guilt over his interaction with Arya, loyalty to the BWB, loyalty to his namesake's troubled family, questions about that family, a crush on Sansa, his desire to be a hero, he wants to give Lady Stoneheart peace, or all of the above. There are a lot of reasons to suspect that he could looking for a Stark. So the motivation is there, but why do I think he is Byron the Beautiful? Character Description They physically and temperamentally match. Byron is young, tall, elegant, has long blonde hair, is capable of dancing (Alayne I TWOW), and his eyes are never mentioned. He only says three words to Alayne, but waited all night to see her, and he kissed her wrist before leaving. Edric Dayne is 'shy, good-natured, and very polite', he has a crush on Sansa (see below), and he's a trained squire/knight (ASOIAF Wiki). Edric can also likely dance, read, and write (he is a lord and has been the heir for his whole life while being fostered at Blackhaven). Both Byron and Edric are young knights (or squires who could fake it), both have blonde hair of the same length. Byron's thick blonde hair hangs "well past his shoulders" (ASOIAF Wiki), while Edric Dayne's blonde hair is long enough that when talking about his helm off he says:
"But when I take it off, my hair gets soaked and sticks to my helm and in my mouth" (Arya VIII ASOS)
By the end of AFFC, Edric Dayne's hair would've grown to beyond his shoulders, he could have grown another inch or two, and he still matches Byron's description. Additionally, Sansa has "vivid blue" eyes, and so Edric/Byron's "dark blue" eyes might not register enough to be described in her POV (contrasted with to his striking hair). GRRM could also be omitting certain distinguishing details in his description (where it makes sense) to hide identities. This fits with my parallel hypotheses; Howland Reed is Ser Shadrich, crannogmen generally have orange/red hair, Bowen Marsh is a crannogman (Ole Pomegranate), and Jojen's hair color is never mentioned (unlike Meera's) because it is similar to Bran's (auburn). Finally, all members of House Dayne who are described in the story are attractive, tall, and have long hair. Ashara is tall and beautiful, with 'long dark hair tumbling around her shoulders' (The Kingbreaker ADWD). Gerold 'Darkstar' Dayne is 'handsome' with collar length, silver hair (ASOIAF Wiki). His height is never mentioned but he carries a longsword, which means he's at least not really short. Also, Arianne thinks he is attractive, and she seems to like tall guys (Arys Oakheart, Daemon Sand). Arthur Dayne, Sword of the Morning, beloved by all, was almost automatically not short and ugly. Look at how other ugly people are treated in this story; they are distrusted, and looked down at by the nobility. Think Brienne, Tyrion, Tyland Lannister after the Dance of Dragons. It makes sense that Arthur Dayne, the most famous knight of the last 100 years, was the perfect image of knighthood; tall, attractive, strong and noble. Edric Dayne is most likely tall and attractive even though Arya doesn't mention it. Again I think GRRM is hiding distinguishing details here in a reasonable way, Arya isn't super interested in boys at the time she's with Edric, and the whole sharing a name with her recently-executed father might be distracting. We actually see this when Edric Dayne is first seen during the Hound's trial and Arya is thrown when hearing Beric call out "Ned". So why is GRRM being coy with Edric's hair length, attractiveness, and height? Might those details make Edric's identity just a little too obvious for the reader (Daynes are already mysterious) if Edric is going to go undercover at some point? Byron the Beautiful's "thick blond mane cascaded down well past his shoulders" (Alayne II AFFC). Similar phrasing with Ashara's hair and Byron's...and:
"The three knights bowed and withdrew, though the tall one with the blond hair kissed her hand before taking his leave." (Alayne II AFFC)
The tall, blonde, long-haired, young, elegant, attractive knight says very little. Yet he kisses Sansa's wrist immediately after meeting her, after waiting most of the night with LF and his companions for Sansa to make her way down the Giant's Lance. And then he takes his leave with no other words. Byron's kiss of Sansa's hand, when compared to his few spoken words ('Dutiful and beautiful' is literally all he says) have always struck me as either very shy, overly polite, or a secret signal to his fellow 'hedge knights'. Funnily enough, Edric Dayne (polite, shy, crushing on Sansa, and can recognize her) makes sense for all three reasons. Here's what he says to Arya, describing the Hand's tourney:
"Were you at the tourney? I saw your sister there. Ser Loras Tyrell gave her a rose" (Arya VIII ASOS)
So Edric knows what Sansa (and Arya) look like, has a reason to search out Stark girls, has recently disappeared in the Riverlands, and doesn't need to return to his castle for the reader to see Starfall in a POV. Someone who looks like him recently appeared in the company of Sansa, by way of Gulltown (port) and Littlefinger. How would Edric know to search out Littlefinger? Someone on his team could've told him, or he could've had an epiphany himself... Edric mentions to Arya that he saw Loras give Sansa a rose, but why bring this up? Is Edric a little jealous of Loras? That makes sense, Sansa is cute, they are the same age, he remembers the rose, and Daynes and Starks have some interesting history. But there's another reason that GRRM brings this moment back to the our minds. Immediately after Loras hands Sansa that rose, Littlefinger talks to her for the first time. He's clearly been standing there for a hot second or two when Sansa notices him. Edric already mentioned that he saw the rose being handed over, could he have seen the creep standing behind Sansa right after and noticed their odd conversation? Maybe that means nothing at the time but pops back into his head when he hears about that same creep marrying Sansa's aunt, that same aunt immediately dying, and Littlefinger then being named Lord Protector of the Vale of Arryn. Edric doesn't even need to hear that Littlefinger has a bastard daughter until later down the line, he knows that Littlefinger is suspicious, he was creeping on Sansa, and he has a lot of power in the Vale. Thats a good place to look for a Stark daughter after the Arya trail goes dead in Saltpans... Why the secrecy He is accompanied by two 'other louts/gallant knights', and they are friendly with each other (a team?). So who are his teammates? And why are they hiding their identities? Littlefinger would absolutely be suspicious if the Lord of Starfall rolls into the Vale of Arryn for 'no reason', especially when he's accompanied by a random Tyroshi (see below). I also suspect he is accompanied by the mysterious Lord of Greywater Watch, an obvious Stark ally (see below below) which would certainly not help. But, would Littlefinger recognize Edric? Edric Dayne was not at court in King's Landing for very long and the squire of a Marcher Lord is not someone Littlefinger is sure to recognize, especially with all the people there at the time, and after all the growth (physically and mentally) Edric has done with the BWB. But Littlefinger knows that Beric was the leader of the BWB for a while and if he were to make the connection between his hedge knights and the the outlaw group, or Beric's squire he would have turned them away or worse. But Littlefinger hired them, so their plan worked. It makes sense that Edric would be under an assumed name if he were in the Vale. Now, remember the line where Byron/Edric kisses Alayne's hand to mark her as Sansa for his companions:
"..though the tall one with the blond hair kissed her hand being taking his leave." (Alayne II AFFC)
On top of marking Alayne as Sansa for his team, the other interesting thing about this line is that it implies another tall man in the room (otherwise why specify the hair color of Byron). Who is the other tall man? PELLO OF TYROSH, aka GREENBEARD If you'll permit me to get meta for a moment, the most important thing to notice about Greenbeard is that George RR Martin forgot about him before. While a somewhat comical note, I'm very confident that GRRM would make a point not to do this again, especially after introducing a 'replacement' Tyroshi sellsword character that he spends time developing in ASOS. Greenbeard is a prominent member of the BWB when Arya is traveling with them. He is the leader of the group before they reconnect with Beric. Greenbeard is the boss over such distinguished members as Lem Lemoncloak(Richard Lonmouth), Harwin, Tom O'Sevens, and Anguy the Archer. This character isn't just going to disappear. Last seen in POV Greenbeard (Pello of Tyrosh) and the Mad Huntsman of Stoney Sept are given a the Hound's gold and sent on a mission 'South of the Mander' to feed the famine starved people of Stoney Sept. They seemingly leave right after the Hound's trial. Last probable location After obtaining food somewhere south, where war hasn't annihilated crops and livestock, Greenbeard and the Mad Huntsman would return to the Stoney Sept area to give food out to the commonfolk. More than enough time has passed since Greenbeard and the Huntsman were sent by Beric for them to get food, bring it to Stoney Sept, and distribute. The Mad Huntsman was not a main part of the BWB, as since he is responsible for that town, I think he would just stay in Stoney Sept, where he and Greenbeard maybe hear news of Lady Stoneheart. Point is, the Mad Huntsman and Greenbeard probably split ways after the food mission, and Greenbeard can now do whatever he wants, rejoin with the BWB, stumble across/go find Edric Dayne, search for a Stark girl. He's unaccounted for somewhere in the Riverlands last we can reasonably guess and that time is somewhere in the beginning/middle of AFFC The journey that Greenbeard and the Mad Huntsmen go on 'south of the Mander' isn't even necessarily where they are heading, Beric says this to the Hound and he could be lying to protect his allies. Greenbeard just needs to get to a place with food for sale, and then bring it back to Stoney Sept where the Mad Huntsman will presumably be in charge of distribution (it is his town). Thats a lot of responsibility, but the timeline is long enough that Pello can leave with the Hound's gold, come back with food, get to the Riverlands, meet Edric, and take a boat to Gulltown (probably from Dunskendale or Maidenpool(?)). There are weeks to spare, and if you want to explore this for yourself, the ASOIAF timeline is what I used. Dates are estimates but the timeline gives you a good basis. Motivation So Greenbeard definitely has had time to get back to the Riverlands. He is also a ex-member of the BWB and we know the BWB is searching for the Hound and the Stark girls. He has shown a proclivity to help the common people, and he dislikes Lannisters and the Hound. So his prior goals are similar to the current BWB goals, why has he left? Maybe he doesn't agree with the extreme violence, wanton cruelty, and vengeance-driven actions of Lady Stoneheart. He's likely to have similar goals but probably doesn't agree with the means. Suppose on his way back from Stoney Sept, or after leaving the BWB Greenbeard hears about the Rape of the Saltpans by 'the Hound' and started heading that direction where he runs into Edric Dayne at the Inn of the Crossroads, or Saltpans itself. Or Edric went looking, couldn't find Arya or the Hound, returned to the Inn at the Crossroads, or the hollow hill at the same time as Greenbeard, and they set off together. There are lots of reasons/possibilities for these two friends/former teammates to join up together. These two characters are two of the top three listed under Beric's old band in the appendix of AFFC, it makes sense they might team up on a mission (The Mad Huntsman clearly prioritizes Stoney Sept above all else). I also think Pello might want to protect Edric, who just lost his foster father and knight. But could this Tyroshi named Pello aka Greenbeard really be Morgarth the Merry? Remember that Edric is still only 12 or 13 years old, and only just maybe became a knight. Even though he's lord of an ancient house, or maybe because of that, I don't think Edric Dayne is alone on his quest, nor would the BWB be that pleased with him setting off alone. I don't know if Greenbeard is back by the time Catelyn is raised, but at some point Greenbeard separates himself from the main BWB group (evidenced by appendices) and goes his own way. But these two ex-BWB characters have similar goals, are in the same general place, and could be drawn together by the same clue; rumors of the Hound and Arya and the atrocity at Saltpans. I've already stated why I think he won't be forgotten, but it makes sense for him to join up with another prominent ex-BWB member (Edric Dayne) and reappear in one Stark girl's storyline, just like they disappeared from another. So Greenbeard's motivation seems to be; help the commonfolk and or the downtrodden (food for Stoney Sept), maybe protect the newly 'orphaned' Edric Dayne (the old BWB members like him), maybe find a Stark girl and get her to her family (Arya escaped last time after her dropped her with Beric). He and Edric could also want to give Lady Stoneheart peace by bringing her a daughter so Catelyn can crown her daughter and let go of life (hence LS playing with Robb's crown). All sorts of reasonable, logical, possibilities for two prominent ex-BWB members whose whereabouts are unknown and who have similar goals to join forces. Greenbeard might even be along for the ride because rescuing Sansa is what Edric wants to do, who knows? But thats not all! Character Description Greenbeard is also physically and temperamental match for Morgarth the Merry. Pello of Tyrosh was familiar with Arya Stark, constantly joking with her, calling her a 'golden squirrel', and tickling her under the chin. Seems like a pretty jolly, or merry, fellow. He seems to be well regarded by the BWB (he's a leader), just like Edric Dayne (Anguy says he's a good due). Greenbeard is a formidable fighter and a large man, being described as taller and bigger than Lem Lemoncloak, another experienced soldier and Big Dude (ASOIAF Wiki). Greenbeard has also been in Westeros for some time, as remarked by Tansy (the brothelkeeper of the Peach in Stoney Sept):
'"Greenbeard, is it? Or Greybeard? Mother take mercy, when did you get so old?" (Arya V ASOS)
These line both identifies Pello's beard as green and grey (salt and pepper minus the dye), and it tells us that Pello has been soldiering in Westeros for enough time that his beard has begun to noticeably grey. He might not be a knight, but he's definitely interacted with knights long enough to pass for one. Especially one rough around the edges like a hedge knight named 'Morgarth the Merry'. Greenbeard has a thick green and grey beard, and he could easily disguise his identity as a Tyroshi by washing out the dye, giving him a salt and pepper beard:
"Greenbeard stroked his thick grey-and-green whiskers..." (Arya III ASOS)
In Sam's Oldtown AFFC chapter, we hear about some Ironborn reavers trying to disguise themselves as Tyroshi sailors by dying their beards, but none of the Ironborn speak Tyroshi. Perhaps this is an allusion to how easy it would be for a Tyroshi who was familiar enough with Westeros and Westerosi to do the opposite and blend in? Greenbeard isn't mentioned to have an accent and he's very familiar with Westeros. Another note; Greenbeard (like most of the BWB and other soldiers) drinks commonly in Arya's chapters, especially while hanging out at the Peach, and what is a common characteristic of drinkers? A red, broken-veined, nose.
"Morgarth is burly with a thick salt-and-pepper beard. He has a red, bulbous nose with broken veins and large, gnarled hands
Morgarth is a burly (large) man, with big, gnarled (well-worn) hands, a black and grey beard, and a drinker's nose. Sounds similar to Greenbeard? Big dudes have big hands, and the implication of another tall man in the room when Sansa meets the hedge knights can mean Morgarth. Littlefinger and Shadrich, are short and Byron don't make sense in context. Drinking reddens your nose, and a Tyroshi who had spent a lot of time in Westeros could wash the dye out of his beard (making it salt and pepper rather than grey and green) and pretend to be a Westerosi hedge knight. If the dye doesn't come out, he could just cut the green ends. Thick beard doesn't mean long. Also there is a theme in Sansa/Alayne chapters regarding dye as a disguise, and then that dye running out. How poetic would it be for a Tyroshi to blend in by washing out his dye to help rescue Sansa? Pello of Tyrosh is already friends with Edric Dayne, would have a reason to search for Arya (BWB member, hates the Hound, wants to help Edric), and he in missing in the Riverlands. He fits the physical description and he a joking, laughing dude. Just the sort to be called 'the Merry' Other than the physical description, MorGARTH the Merry brings to mind Garth the Green (or Garth Greenhand). Pello of Tyrosh, the Greenbeard, journeys to the Mander (the land of Garth the Green) and now returns with a name symbolizing Garth; Mor(e)-Garth. Garth the Green is also related to the Isle of Faces (his oldest descriptions match the greenmen on the Isle of Faces), and this also connects to the idea that Howland Reed is Ser Shadrich, as Howland is the only known living visitor to the Isle of Faces. But again, Howland=Shadrich is not required to believe Edric=Byron and Pello=Morgarth. That said, Howland Reed being the third member of the crew fits with everyone's motivations, explains how they were sure Sansa was in the Vale (if HR came from the IOF), and potentially explains the cooperation between the BWB under Lady Stoneheart and crannogmen that Danwell Frey mentions late in AFFC (Jaime IV AFFC). Wrapping up Byron and Morgarth Alright so Byron the Beautiful is Edric Dayne and Pello of Tyrosh aka Greenbeard is Morgarth the Merry. These two ex-BWB members have separated from the main BWB group, are prominent characters that wouldn't be forgotten, and have reasons to search out the Stark daughters. Edric recognizes Sansa, and his kiss marks her for his teammate(s). Both characters fit the physical descriptions and temperamental descriptions of the two mystery hedge knights (Byron and Morgarth) and Edric might have reason to suspect Littlefinger in Sansa's disappearance (creepy Littlefinger at the Hand's tourney). You can stop reading now or, if you aren't tired of this idea, I have some hopefully new idea about Howland Reed=Shadrich, why I'm sure HR isn't in the neck, and the timeline around the trio of hedge knights. HOWLAND REED I strongly believe Howland Reed is Ser Shadrich of the Shady Glen. The arguments laid out in the earlier links should be read if you want a full understanding on the likelihood of this secret identity, but in a few notes, Howland Reed is known to be:
a crannogman (short, slim)
strong, clever, brave, and adventurous (see Meera's KOTL story)
not a jousting/tourney knight (KOTL story)
old god worshipper (North/crannogman, Jojen and Meera's religious preferences)
fought at Tower of Joy and in Robert's Rebellion
was at Tourney of Harrenhal
Ser Shadrich of the Shady Glen:
obviously a made up name, probably just to serve until Shadrich reaches Duskendale/Hollard castle (Dusken=Shady, Dale=Glen)
short, wiry(=strong+slim), orange hair*, fox face (indicates cleverness?)
"the mad mouse seeks out danger" different from your usual 'mouse'
won't fight in joust, will fight in melee
old god symbolism with his sigil (white mouse and red eyes)
cocky enough to be good at fighting, 'long leagues' in his eyes and face, old scar behind ear
mentions how hard it is to fight with your off-hand (referencing Gerold Hightower at the Tower of Joy?)
mentions 'a mouse with wings' being a silly sight (mouse with wings=bat, bat is sigil of house Whent of Harrenhal, and the Shella Whent has supposedly just died)
The earlier posts by u/M_Tootles and u/theRockefellers do a better job explaining the link between crannogmen and red hair than I can in this space, but I think its important to remember that crannogmen are discriminated against, and their height cannot be the only distinguishing factor, there are too many other short groups for that to be the major distinguishing factor. I think having crannogmen often be gingers matches well with their discrimination, being called 'bog DEVILS' by the ironborn, being closer to the old gods and COTF (touched by fire, like the wildings), and the only non-Reed crannogman we've met is Bowen Marsh, the dude always described as a red pomegranate, and not just for his red face. Timeline I think Howland Reed left Greywater Watch for King's Landing at the same time he sent Jojen and Meera to Bran and Rickon. He got to King's Landing, where he stayed for a while, perhaps creating a subtle, but potentially recognizable (to a Northerner) hedge knight identity. He was almost certainly trying to get access to Sansa, but she's a 'guest' in the Red Keep. After Sansa's disappearance, Howland is finally able to access the Red Keep with the flood of other people to watch Tyrion's trial by combat. Once in the Red Keep, he can get to the godwood's heart tree to "talk to the tree" and see that Sansa meet with Dontos Hollard. He would also see Ned's conversation with Cersei. Here is Meera's story about her father for proof this is possible:
"...he could breathe mud and run on leaves, and change earth to water and water to earth with no more than a whispered word. He could talk to trees and weave words and make castles appear and disappear." (Bran II ASOS)
So Howland 'talks to the tree', and hears or sees those conversations had in front of the heart tree. He recognizes, or is able to puzzle the identity of Dontos Hollard, and the former location of house Hollard, outside Duskendale. Lo and behold, there's Shadrich, on the road to Duskendale. Shadrich/Howland warns Brienne about the danger of people like Ser Creighton Longbough and Ser Illifer the Penniless (who rip apart a silver trout(!) for dinner) and are lying about their pasts. Unfortunately for Howland, the Duskendale/Hollard idea is a dead end, but the most likely place to discover additional knowledge, the Isle of Faces, is nearby for the first time since Howland came back from Robert's Rebellion. Howland has been there before, and he has time to go back again before reappearing in the Vale. This could be where Shadrich/Howland Reed discovers the location of Sansa Stark. Maybe at the Isle of Faces he can look through the weirwood moon door and see Littlefinger and Alayne during the Lysa moondoor scene? There would probably be something useful he learns at the IOF. Edric could give a basic description of Sansa to Howland, he recognizes her from his tree-TV, they both know of Littlefinger's creepiness, and the trio might feel thats a pretty good lead to track down. How does the team come together Howland is brave enough and daring enough (he went to the IOF before) to attempt this rescue mission on his own, and we do see him basically on his own along the road to Duskendale. But by the time we see him as Shadrich in Sansa's company, he's had to hear about the fall of Winterfell, the deaths(?) of Bran and Rickon, the disappearance of his children, the Red Wedding, and don't forget the death of his liege lord, war friend, and fellow secret keeper. What else could encourage Howland to get find allies? Probably losing the trail, and the best place to pick it back up with be the Isle of Faces. The last time Howland visited the Isle of Faces, he rowed his boat back to intersect with the Stark's at the tourney of Harrenhal. This happened right after he left the Isle of Faces and he stumbled into a band of allies and the most important political event of the last 100 years. Suppose something similar happens again? GRRM loves parallel stories from different points in hostory. Edric Dayne, Lord of Starfall, and Pello of Tyrosh are camping on the banks of the God's Eye and looking for a Stark girl. Howland Reed paddles up from the Isle of Faces, and just so happens to know where a Stark girl is, needs allies if he wants to best Littlefinger, and he might know something secret about House Dayne from his interactions with Arthur Dayne and Ashara Dayne at the Tower of Joy and Starfall. Personally I think Howland married Ashara, but thats for another post, though that fact could have significance if/when Howland convinces Edric and Pello to join him. So Howland Reed, Edric Dayne, and Pello of Tyrosh meet on the shores of the God's Eye, head to a port with fake identities (odd throuple), hop a boat to Gulltown, and get themselves hired by Littlefinger and transported to Sansa Stark. Why do I think Howland Reed isn't at Greywater Watch? Howland, not home Why do I think Howland Reed has left the neck? Well when Jojen and Meera are talking to Bran in the godswood at Winterfell and trying to get Bran to talk about his dreams, there is a curious line from Jojen:
'"You are the winged wolf, Bran," said Jojen. "I wasn't sure when we first came, but now I am. The crow sent us here to break your chains."' (Bran IV ACOK)
and then this one from Meera:
'Meera Reed hung the net from her belt. "When Jojen told our lord father what he'd dreamed, he sent us to Winterfell."' (Bran IV ACOK)
While Meera and Jojen were sent by Howland to Winterfell to find and help the winged wolf, they didn't know who the wolf was. This is important because the options at Winterfell are only Bran and Rickon, but there is another potential winged wolf in chains, Sansa, and she's in Kings' Landing. Arya is missing, Robb has an army around him, and Jon is beyond the Wall. Howland would probably prefer to send his kids to the supposedly safer location, Winterfell, and go try to find and help Sansa himself. If Jojen didn't know who the winged wolf was, how did he know where the winged wolf was? Howland is the one who sends them to Winterfell, is Howland getting greendreams too? No, Meera pointedly says he doesn't have that power. So Howland is probably making an educated guess where the winged wolf could be, based on the Stark sigil and the location of the Stark kids. It's is important to note that Howland sends his kids away for an unknowable amount of time, where they could potentially journey beyond the Wall and be exposed to a ton of danger. He's not just twiddling his thumbs in the Neck waiting for Meera and Jojen to solve the mystery of the chained, winged wolf, or for someone to come to him and ask for all his secrets. Howland Reed is doing the logical, brave, and helpful thing and is going to help Sansa, who is obviously in danger, after his son has a greendream of a chained wolf. There is another clue indicating Howland isn't in Greywater Watch. Again, in that scene where Jojen is asking Bran about his dreams in the godswood, Bran tries to change the subject by asking Meera about lizard-lions. Here's the exchange between Bran, Meera, and Jojen:
"Bran made a nervous smile. "I'm tired of talking about crows. Let's talk about wolves. Or lizard-lions. Have you ever hunted one, Meera? We don't have them here." Meera plucked her frog spear out of the bushes. "They live in the water. In slow streams and deep swamps— Her brother interrupted. "Did you dream of a lizard-lion?" "No," said Bran. "I told you..." (Bran IV ACOK)
This is the only time in the entire story that Jojen interrupts Meera (and I'm pretty sure the only time he ever interrupts anyone), so why does he do this? Why does he need to know if Bran dreamed of a lizard-lion? Well Bran's dreams clearly have meaning, and Jojen seems worried that Bran saw a lizard-lion in his dream, could Jojen be worried Bran had a greendream about a lizard-lion? Jojen and Meera are currently safe at Winterfell and Jojen is never worried about his own mortality, so it only makes sense he would be worried about another Reed, his father or mother. I don't think he would be worried if they were safe in the Neck, so maybe one of them has left the Neck and Jojen is worried for their safety. Jojen calms right back down when Bran says he hasn't dreamed of a lizard-lion so the whole interaction seems inconsequential, but I think it was a hint HR has left the Neck. It's likely Howland is the one who left, as he's been known to do that before and it makes sense for him to be gone looking for Sansa if he sent his kids north. I also want to note that Meera says lizard-lions (Reeds) live in 'streams' and 'swamps' which are blue and brown, the same colors forming the background of Ser Shadrich's shield. I always wondered why there was brown not green representing the lands Shadrich says he's crossed. I think his sigil is supposed to catch Sansa's attention and make her think 'old gods/the Neck' but that hasn't happened yet. Meera also says she learned her fishing from her father, and she multiple times catches silver trout, the Tully sigil (Bran ASOS). Could her father be hunting down the most Tully-like Stark, Sansa? But what do you guys think? Are Byron the Beautiful and Morgarth the Merry really Edric Dayne and Pello of Tyrosh? Is Ser Shadrich of the Shady Glen actually Howland Reed? I want to hear your questions and debate this! Thanks for reading
2020.09.18 01:25 TheNOOBIFIER1337Do We Wait 10 more years?
https://youtu.be/syGdpvMM_o0 TLDR This is a video script and its title will perhaps initially seem negative, but my goal isn't to troll or meme CIG, or the development process. There is already an overabundance of that and I'm sure if you are a regular here, you will know that's not my style. The goal today is to follow up with what Chris said in a reply in Spectrum, and explore what that might mean to the project. There was a new thread started at 6am today with Chris looking for questions. I have that linked for you and it’s a great idea that might address a bad trend. https://robertsspaceindustries.com/spectrum/community/SC/forum/50259/thread/ask-the-chairman/3380142 I will also look at the current achievements against the features promised. This might give a better indication of how much longer we might be in development. I’ll say it now before you say it in chat, I think we are all aware that Star Citizen is proposing the concept of a soft launch and the idea of a minimum viable release. We can start our investigation with what Chris Said is spectrum. Chris posted that he will finish what he promised over the years and that we will not be waiting 10 or 20 more years. I believe we all believe he will exhaust all avenues to achieve what was pitched plus the creep. “I can promise you the gameplay I described is not a pipe dream, nor will it take 10 to 20 years to deliver. He said it wouldn’t take another 10 or 20 years like the critics, jokers and haters say in social media. This is where I am conflicted. We know Chris plans to deliver but Chris also has a track record of underestimating the work and scale when estimating timelines. It’s like when I budget for a construction project, take the number and double it.. Along with his statement about development timelines, Chris also proclaimed that even what was currently in the PU would be considered as more ambitious than anything currently on the market. “Star Citizen already has the main gameloops of a space sim; cargo hauling, commodity trading, mercenary, pirate, bounty hunting and mining. Just spending time refining and finishing out these would make Star Citizen with all it's detail and fidelity more engrossing than any "finished" space sim you can play today.” I believe if patch 3.11 were polished to a release state, what we would have would be a good proof of concept that grossly falls short of its potential. We are here at this stage now because as more money poured in, the scope and scale expanded. It’s a relic we inherited from the way the game was funded combined with Chris’s desire to blow people's minds. He won't back down from a challenge, He has a complete vision for star citizen and over the past 8 years we have had many opportunities to get an idea of how interwoven the vision is. I hope the new roadmap will make mention of everything Chris plans to include with the PU. Adding all known and unknowns to the list will better define what the company sees as minimum viable. We as a community are sensitive to creep. Caves were both exciting but met with confusion, because it was just sort of announced out of the blue. Prison was announced in the same way. It's clear that these features were previously planned long ago, but from our position, it seemed like effort spent on poofing stuff bigger instead of locking down. If the roadmap were to include all of these features, at least we would have a defined END STATE and a target which I believe would help with transparency. I will end by presenting a list of features currently in the PU and another list of features expected to be added to the PU. I have tried to be complete but I fully expect you to post others that I may have missed, from you my valuable community members. This is just an exercise to get some sort of estimate and I would love you to comment your comments in the comments. We are waiting for SQ42 and have had minimal news on progress since March of this year. It was due to be in BETA now and releasing shortly, I believe it's unlikely however there is hope. We know once that project is done, a broad deliberate focus will swing towards completing the PU. As much as I want to see SQ42, what really excites me will be to see what progress CIG can accomplish when all hands are on deck and focus is on the PU. The current PU offers, in no particular order. Stanton, a single large system populated by planets, moons, stations and points of interest. We have a space flight model that has had a very rocky development, but I am an optimist at heart so I hope it continues to show promise. We have an growing atmospheric flight model whose desired feature list and proposed scope could be its own video. That atmospheric flight model is tied directly to the rooms system, which is tied to the player actor status system, which is tied to hunger, thrust, injury… the whole deal is one big link of connected features. 99% of the ships have guns, and weapon balance is in an ever evolving state. Missiles currently make no sense but we are assured, work is being done. . We have the most basic framework of AI function. There is no indication that they currently incorporate subsumption. Mining is actually very well fleshed out as a game mechanic at numerous levels plus refining gameplay is coming soon. Mining by hand, by buggy and by ship, on the surface, below the surface and in orbit. Scanning works but it is still seen as rudimentary compared to the proposed exploration and science gameplay. The Growing list of missions is getting better but game breaking bugs are common. The UI and Ship HUD are improving with hologram input panels and building block tech. Matchmaking is lightyears from two years ago but we face a huge unknown in the form of the future of server meshing and population caps. Cargo Running is about to get a boost with 3.11 and the cargo decks but it’s still simplistic compared to the desired end start. We have had no loading screens since 2.0, We have a seamless transition from physics grids since 2.0, We have seamless scalar planetary bodies who look great from a distance all the way to millimetric scrutiny since 3.0. We have a basic law system and our expanding prison game loop. All of this as Chris pointed out is Quite a substantial base and frame to build on, but we are at year 8 years since kickstarting, We are still lacking, meshed servers which is critical for the First M in MMO Meshed servers were mentioned as the feature holding up many others. We lack Subsumption, We lack the Quanta driven Dynamic Economy, e lack Crafting and tuning We lack all of the other features Quanta will bring such as inter faction gameplay, proportional security, and others. We lack Ship Modularity, We lack Ship Docking, We lack Land Mechanics We lack Base building, We lack Maintenance gameplay, to include wear, repair, and upgrades. We lack procedural damage that will impact our internal components. We lack internal components, Fuel Collection and Distribution isn't implemented. There is no Salvage loop, no crafting, no farming, no VIP gameplay, no passenger transport, no science play, no hospital play, and no data running, Exploration is just sightseeing and is basic, The idea of player to player trade is basic. We lack Jump points to a second system and I’m sure there are a couple I missed. So now you say. Noobifier, what was the point of spelling all that out and why are we still reading. Despite having many foundational systems mostly in place, there is a huge delta between what we need and what we have. I understand that we are waiting for some core back end to be done before the major loops are added. This year has already set funding records so money won’t be the problem. Transparency and passage of information has been declining resulting in the most volatile outpouring of citizens wanting answers. I’m sure none of us expect SQ42 this year, but it would be lovely for CIG to break the silence on where we are. It's been a month since we were promised a roadmap to a road map, and its been since MARCH since we had an update on the project. Do we need the info in a roadmap form? No, I don't even need graphics or charts. A simple stand and deliver update like was done in the past sooner than later would help. A Pillar talk or even simply a new target date would be lovely to have. The project was built on transparency which has become more opaque and hard to come by. You can argue that i'm trying to sensationalize the actual pulse of the community, but as a content developer I do track my comments, spectrum and reddit for indicators. It was all in my head, Chris wouldn't have had anything to reply to last week. I feel the takeaway is, the community supports the project and believes. I would love the new roadmap to include absolutely everything that is being planned to be added for release and the future. This way, we can follow along with a better understanding of what is coming and how it all fits together in the master plan. We come to the end and it's your time to post in the comments. If you were to look at the list of what we have against what we know still needs to be done, what is the percentage you feel is done. I think we are 25% done with another 8 years to go. Comment in the Comments. Thank you very much for spending your time with me. I hope you got something out of the discussion and it would be nice if CIG continues to make an effort through this more proactive trend in spectrum. Fly safe and I'll see you in the verse.
Question in advance: how can I dream with him again? I just have to get this out of my system or I'll go crazy. so: my twin flame and I have known each other since we were children. he lived in the same street as me, when I grew up. when I was 13 we moved to another, newer part of town. he and his parents moved near our new home at the same time. a few years later (I was 17) we met again at a mutual friend's house party. since then we messaged each other now and then. At some point we went on a date together and from then on it was clear that we were into each other. However, we both had our different problems with ourselves at the time. I had the feeling that he could hurt me the most, that I am not good enough for him, that I cannot show myself, cannot show who I really am. he also had his own problems but I won't bring them up now. We were together for two months. it was intense and for me incomparable to the other relationships I’ve had. he said things like "I've never felt anything like this for anyone before". we saw each other almost every day. on the one hand it was him who asked me if we wanted to be together - on the other hand he distanced himself more and more from me - and then he ghosted me. After I messaged him enough to get an answer of him he finally broke up with me over WhatsApp. I was devastated. even in my last (4 years) relationship and my first (3 months) relationship when I was 16, I never cried as much as I did when this relationship ended. a few days later he wrote me that he would like to stay friends with me. I told him that would never happen and since then I haven’t heard of him ... But, well ... At the beginning of this year my awakening happened. I was still together with a soulmate of mine. (Well I think it’s a soulmate, everything speaks for it) I dreamed of him, my twin flame. I have never dreamed of him until then. The dream went like this: he chased me, but I knew, he wouldn’t hurt me. But he wanted that I show my true feelings, that I stand up for myself - not for him but for me, for my greater good. I woke up and since then he was on my mind. Constantly. It wasn’t even a romantic dream. It was a wake up call somehow. My relationship then didn’t run that good as I wanted it to, I really loved this guy but he was just taking and taking and I was giving too much of me. My twin somehow wanted to tell me that I need to stand up for myself, that I could use a little bit of his confidence. One month later: Somehow I managed to sleep in the afternoon, I had the weirdest dream ever. The second dream with him. I was walking along the street while he was driving by with an good looking, expensive, old car. He didn’t see me but I saw him. My destination seemed to be a crime scene, the police had already arrived. This apparently was the work of a serial killer, who concentrated only on young women. The room was pretty weird: there was an big eye painted over one wall, and it constantly moved, somehow looked at everything that I was looking at, nobody seemed to recognise this painting and it’s strange behaviour - but me. And everytime I looked at it, it would intensely stare back at me. (It was brown btw, his eye colour) the serial killer also left a note of a prophecy: when him & I would come together, we would be king and queen, side by side, a powerful couple, a bond that would benefit the both of our families. There would be no other connection for him or for me that would be so good as this one. I woke up. And of course I thought “wtf”. The next day I was walking along the street, and at the crossroad in front of me stood a good looking, expensive car, Mercedes to be exact. Someone in the car leaned over to my side, looked at me, smiled at me and waved. I didn’t see him in 4 years. I didn’t recognise him in the first seconds. I couldn’t wave back, I was just too confused about this. He drove off and I stood there, puzzled because I finally had recognised him & and that my dream I had yesterday somehow turned out true. One month later my boyfriend and I split up. It just didn’t work out anymore. He didn’t contact me. I was wishing for it so much. 3 months later I needed to prepare for my exams. I was learning when he wrote me over Instagram. He deleted his message before I could look at it. I only knew then, that someone wanted to message me but deleted it, I didn’t know it was him. One month later after my exams I finally decided to message him. (Then I saw that he has been the one who had wanted to message me.) I asked how he has been. He wanted to connect with me over Snapchat, but our conversation over sc was very short. Now I know, that he has a girlfriend, that they live together. I also know through friends that they split up and came back together again last year. (my soulmate ex and I had something like that, 2 months in 2019 in separation) I was healing from my past relationship, learned to be more independent, to also be a little bit more selfish, something that I have lacked of in the past. I grew, got my mind off things, concentrated on me and my friends, and I have never felt so good in years, for real. But I also had those phases, where I would think of him very strongly. Sometimes I noticed what he was feeling: lust, sadness, a hole in the chest, grieving, lack of appetite. sometimes the feelings would come so unexpected and suddenly. The third dream with him was 2 months ago: I was standing in his kitchen of his apartment. We were talking, catching up. It felt like an astral journey. He told me that I would visit him soon. The fourth dream is almost 2 months ago: it felt like a normal dream, at first. I bought some things in town for my mother. I drove a Mercedes SUV. After that, I met him in town, we were sitting in a cafe, talking and laughing together. we were happy. my white dress was cut in a strange way and was very flared, but he liked it. then I woke up. but I wasn't really awake, my body was sleeping and I tried to sit up in my bed, which was very difficult for me. My phone laid on the left side of the bed. someone called, but I couldn't answer it because I couldn't move anymore. then I felt a figure in my room, it was invisible but I wasn't afraid of it. the figure reached out to me and put it’s hand on my shoulder. I suddenly really woke up. the feeling of the hand still lingered on my shoulder. I am sure, that it was him, who stood in my room. But why didn’t he show himself to me? One thing for sure: This part of the dream was an astral journey too, I’m sure of it. I always feel very heavy at first when an astral journey starts. In the last few months I've gotten into tarot more and more. the term “twin flame” was new to me. It wasn't until I started looking at the concept two weeks ago that I noticed all the similarities. I've never had these phases where I miss someone so much as him, where I suddenly feel their feelings myself or where I had dreams like these. I am sure - he is the one, my twin flame. I also feel his heartache more and more. Will he and his girlfriend break up? I dont know. I can only wait and focus on my life like I did before. But these phases break my heart. maybe soon it will no longer be a phase but be a constant feeling. but I know in any case, the universe wanted to tell me with the first dream that we should both pull ourselves together, communicate again. without this first dream I would not have thought of him as I do now, and I wouldn’t have gotten so much into tarot and astral journeys and stuff. I also believe now, in pantheism. Before that I was an atheist. The universe wants to tell me something. Thank you for reading all of this. If you have any thoughts on all of this pls share it with me. I don’t know what I am supposed to do next. I’m stuck and I hope that I maybe have another dream, but that’s it, more I can’t do.
2020.09.17 16:20 toni_inotPivot not allowing more than 12 columns? Possibly related to date format for column headings
Trying to pivot data based on a column with dates in, and it will pivot up to the 12th of the month but not 13th.
SELECT * FROM ( SELECT DISTINCT(o.id) ,CONVERT(date,o.et,103) as 'EDate' ,p.sc FROM o WITH (NOLOCK) INNER JOIN p on p.id=o.id WHERE CONVERT(date,o.et,103) BETWEEN '01/03/2019' AND '12/03/2019' AND o.oc = 'SINGLE' AND o.f = 'STARTED' ) t PIVOT( COUNT(t.id) FOR EDate IN ( [01/03/2019],[02/03/2019],[03/03/2019],[04/03/2019],[05/03/2019],[06/03/2019],[07/03/2019],[08/03/2019],[09/03/2019],[10/03/2019],[11/03/2019],[12/03/2019]) ) AS pivot_table ORDER BY sc ASC
Works absolutely fine.
SELECT * FROM ( SELECT DISTINCT(o.id) ,CONVERT(date,o.et,103) as 'EDate' ,p.sc FROM o WITH (NOLOCK) INNER JOIN p on p.id=o.id WHERE CONVERT(date,o.et,103) BETWEEN '01/03/2019' AND '13/03/2019' AND o.oc = 'SINGLE' AND o.f = 'STARTED' ) t PIVOT( COUNT(t.id) FOR EDate IN ( [01/03/2019],[02/03/2019],[03/03/2019],[04/03/2019],[05/03/2019],[06/03/2019],[07/03/2019],[08/03/2019],[09/03/2019],[10/03/2019],[11/03/2019],[12/03/2019],[13/09/2020]) ) AS pivot_table ORDER BY sc ASC
Doesn't work at all.
Msg 8114, Level 16, State 1, Line 1 Error converting data type nvarchar to date. The incorrect value "13/09/2020" is supplied in the PIVOT operator.
I wondered if it was the date format with 13 being a likely place for it to stop working, but I'm sure that '103' is dd/mm/yyyy? Does anybody have any ideas what's going on here?
2020.09.17 06:28 chonkierPosting on reddit until I get a girlfriend #178
Day 1: I know this isn’t the most creative thing to do here, but I have never been in any sort of relationship and hoped I could get some advice from you redditors. This might take over a year or more to do before I either get one or give up, but good luck future me I guess... Day 2: No Day 3: Any tips on how I should hit up my crush? Day 4: Thinking about messaging her and saying hey to get a conversation started but I have to work up the nerves to do it Day 5: Love it when I have no internet for online school Day 6: Beep Boop Day 7: I think I might wait to try anything until this whole global pandemic thing slows down. It’s been a week and Ill Ive done is realize how boring I am with these posts lol. Probably wouldnt be thinking about this so much if soccer season wasnt cancelled... Anyway, beep boop bye boys. That was a lot of writing... Day 8: I DID IT GUYS! I TALKED TO A GIRL! Jk no I didnt lol Day 9: Yes this is day 9. Day 10: After 10 days, my preditction for how long this will go on is... idk fucking forever Day 11: I tried starting a conversation with my crush on snapchat and she didnt even open it :( Day 12: Last night she responded to my snap message from 2 days ago and now we might have a streak Day 13: I am bored today no news lads Day 14: We dont talk about day 14 Day 15: I have acquired a 4 day streak with my crush and I rly want to talk to her but my scaredness is overtaking my temptation Day 16: Nothing happened today Day 17: When you cant stop thinking about a person is not an epic gamer moment, especially cuz we’re stuck at home and cant do anything about it. i want this to be over already so i can try to talk to her. Day 18: Hi again guys and gals Day 19: Dont worry Im just passin’ by you sorting by new Day 20: Woohoo day 20! I tried to talk to her... i snapped her and said hey but she didnt even open it i guess she dont care. that was last night too. Day 21: Now beginning to realize that this has the potential to take years Day 22: Just passing by your feed for the day hope you guys are doing well :) Day 23: Hello Day 24: Hello #2 Day 25: How are you guys doing today? Day 26: If I was a news network, I would be bankrupt because I have no news Day 27: Helloooo Day 28: I want someone to talk to lol Day 29: Hello #3 Day 30: Hooray day 30 only like 2 more years to go Day 31: Im pretty much giving up on talking to girls online so im gonna wait until school starts in the fall and start trying there, so the minimum for this chain of posts in probably like 150. Day 32: I officially give up... for now Day 33: 333333 Day 34: technically its actually day ((9(4)+8)/2)+(3(4)) Day 35: Life huh Day 36: So glad I finally have someone to talk to here on reddit Day 37: Today’s date is April 28th Day 38: I almost have 20 followers from doing this like what Day 39: Its getting harder to remember to post Day 40: A new milestone aha Day 41: shit wack Day 42: Bing bong your opinion is wrong Day 43: What videogames do you guys play Day 44: Badabadabada babaaa badabadaba badabaaaaaaaa Day 45: Whats ur favorite color Day 46: Day 40 feels like yesterday wth Day 47: Ice cream yum yum Day 48: Im posting this at 4:20 Day 49: Ok, so like, um, haha, maybe? Day 50: Ah, day fifty. You know, I heard that a girl doesn’t want you if they don’t text you first. And guess what happened today.... Nobody texted me I don’t think a girl has ever texted me first now that I think about it Day 51: I looked at the mirror today and I was like damn i look sexy ahahaha Day 52: egg Day 53: Tomorrow’s my last day of online school yerrrrrrr - Also I have somehow now gained 32 reddit followers from doing this shit Day 54: Shablam shazam Day 55: Dos rosquillas por favor Day 56: Is it just me or do the colors purple and turquoise go perfectly together Day 57: Hangin out with my friend shut up stupid i dont care Day 58: Day 59: B Day 60: I Day 61: N Day 62: G Day 63: Day 64: The days are beginning to feel shorter and faster... Day 65: holy hell Day 66: But you gotta fall back from doing all that extra Why you dancin wit the devil Day 67: Im the definition of a bandit Day 68: Idk why bro but i cant get over her even though i only barely ever see her on sc... today was her birthday and i said happy birthday she said thank you.. im ranting but tomorrow eh? nice. Day 69: Self explanatory joke please leave your laughs in the comments. Day 70: I accidentally flushed one of my airpods down the toilet when it fell off so now I only have one airpod. it sucks and im sad and then im even more sad bc i realize that having one airpod is this big of a problem to me Day 71: big sad? Day 72: Hooga Badooga Googa Day 73: The internet ruined me Day 74: I dont want my depression to come back but today I felt it for the first time in a while... Day 75: Nononononono I changed this one Day 76: Summer is cool and all, looking at snapchat stories of all the people you know hanging out with each other while sitting in bed alone Day 77: Hung out with friends today, UNO reverse card ()()() Day 78: Bliggle ba giggle diggle Day 79: Have you ever put butter on a poptart... It’s so frickin good... Have you ever put butter on a poptart... If you haven’t then I think you should Day 80: •_• Day 81: He just gon’ throw shots at you before he throw subliminals Day 82: mBeebopmSkeetleebebopmDopm Day 83: You a lame, you aint gang, so I cant hang with ya Day 84: He haw he haw Day 85: I have 78 followers because of this. 78. Day 86: RipCity? Day 87: Salmon, rice, mango Day 88: Yall ever just E E E E Day 89: xue hua piao piao bei feng xiao xiao Day 90: Just mixed the Bape with the Simons, my bad Day 91: There are two types of lonely people. Those that are lonely by choice, and those that are lonely due to circumstances. And I don’t know which one I am. Day 92: I want to kill myself. I hate my family I hate everyone nothing is good I want to die Day 93: I think Im bipolar. I either feel very happy or very sad and I think these posts are kinda proof of that. I try my best to stay happy but its hard a lot of the time. Anyway, IgotblackIgotwhitewatchuwant Day 94: Im gonna start rating my day out of ten on here. Today was a 9/10 Day 95: 4/10 Day 96: 8/10 Day 97: 8/10 Day 98: hmmmm 7/10 Day 99: 9/10 also tomorrow is a big day for this series of posts Day 100: Wow um okay that went fast. I feel like for today I should give some sort of little update or speech kinda thing. So basically, I kind of have a crush right now but I dont know if I want to pursue her its complicated. Right now its summer break so imma wait til school starts again to try for real again. I can actually talk to girls in person cuz they dont talk to me online lol. I dont know how long this series will go but I will try to post every day until it happens. As of right now my confidence in finding a girlfriend is very low. I dont know how long this is gonna take but probably quite awhile. All I want is for someone to love me for me and a girl that I can share my feelings with, since right now I dont have a person to do that with. I want to lose my virginity, but before that I want to have my first real kiss, or before that even, I want to hold hands or hug a girl. I live a lonely life. Dont be me. Day 101: Egg penis Day 102: hooga badooga gag Day 103: Gooba Day 104: I havent had a conversation with a girl online or in person since March. (•_•) Day 105: Blippa blop i guess but like its the 4th of July i guess Day 106: My copy is ready for pasta Day 107: Do I even want a girlfriend tho Day 108: I mean like kinda Day 109: You dont want no problems at ur party dont invite me ahahaaahaha jk i dont get invited to things ahahaa Day 110: just another post for my 120 followers to enjoy Day 111: 111 111 111 111 111 111 111 111 Day 112: I am on vacation u^ Days 113: Yeah going on vacation is cool but have you guys tried sex? ... me neither Day 114: I dont understand how like literally the ugliest people can be in relationships but like Ive never been close to having one Day 115: Today I went on a 7.5 mile hike up to the top of a mountain and it was really cool Day 116: Last day of vacation :( 10 hour drive back tomorrow so sad so saddd Day 117: Sad pony Day 118: Stop telling me this wont work its not supposed to work its just something fun to do until I get a girlfriend Day 119: So da salamilid aint gon fit (wont fit) and the salami (lami lid) wont fit like dat Day 120: Ive been doing this for 4 months now Day 121: Im posting this at 3:20 am cuz why not lol Day 122: I am sad right now Day 123: Looolalooloooladeedadaloodaleeleeda Day 124: IMPORTANT READ THIS - So a lot of you guys are telling me that posting on reddit wont get me a girlfriend. Obviously it wont. If I do ever get a girlfriend I would want it to be a girl at my high school that I know, not some random girl I meet on reddit. Remember, I am doing this for fun, I am not even close to getting a girlfriend. I dont have a crush, and I dont really have any friends that are girls. So... with all that said, The salami lid aint gon fit like dat. Day 125: I am 62.5% of the way to 200 days Day 126: If any of you are wondering if Ive ever tried to ask a girl out before, I kinda have. The summer before my freshman year I confessed to my crush who I had talked to a lot over about a year and a half. I got friendzoned pretty badly, and kinda gave up with girls for like at least 2 years until I started this Day 127: Hello to my 144 followers Day 128: Drop yo Xbox names and what games you play Day 129: Happytime Day 130: I dont know what to say its 4 am Day 131: Dont fire me plz Day 132: z Day 133: z Day 134: z Day 135: z Day 136: Confusion Day 137: Abandonment Day 138: There is no way Im getting a girlfriend in the next year Day 139: Why do people like me get created what even are we supposed to do Day 140: Ahhhhhhhhhhhh whyyyyyyyyyyyyy Day 141: Wrist keep spinnin like a fuckin rotisserie Day 142: Bruh i literally have to go to school tomorrow ughhhhhhhhhh Day 143: It felt good to be back at school it felt like I had a purpose finally and I got to see a lot of people for the first time in a while :) Anyway this one girl... jk theres no girl i lied Day 144: How many of yall are virgins Day 145: I dont want to be horny anymore... I want a girl I can text until 3 am and cuddle with while watching NBA games :( Day 146: Would post Juice WRLD lyrics here but I cant relate to any of them cuz im too lonely Day 147: I had a great day today. I hung out with people, was very social, told jokes that made people laugh, my team won, I had fun. Its important to recognize these days that are good Day 148: Goodbye free time and enjoyment, I have to go to school now. Day 149: eenanashe kabikabi wam dadesh kabikabi dee bruh bruh bruh bruh bruh Day 150: Wow 150. Another landmark. Pretty cool huh. But anyway since schools started ive been talking to girls that i know more Day 151: Dopdopdopdopdododododop Day 152: fuck the system Day 153: Secrets are hard to keep but Im good at lying Day 154: I have to write a 400 word descriptive story about my first ever date for English class... now i havent exactly ever been on a date so yall wna give me ideas Day 155: Please stop commenting stuff like “We will watch your career with great interest” or “This is some dedication” everybody always says it Day 156: blam blam Day 157: Posting on reddit until I get a girlfriend #157 Day 158: gotalottanewshit Day 159: Yo can like 3 more people follow me so I get to 200 followers that would be pretty cool Day 160: I am not enjoying this whole thing much right now Day 161: I wonder if you know Day 162: How they live in Tokyo Day 163: If you see them and you mean it Day 164: Then you know you have to go Day 165: Its so nice talking to girls again mow that school is back Day 166: If you are reading this dm me and tell me ur favorite food cuz im bored Day 167: Why do I find like 75% of girls attravtive bruh Day 168: fuck... fuck... fuck fuck fuck FUCK FUCK FUUUUUUUUUUCKKKKKKKK Day 169: We have officially reached funny number + 100 Day 170: Drove that pack from Houston, OKC, I feel like Chris Paul ~_~ Day 171: Hassan Whiteside Day 172: Almost forgot today Day 173: :371 yaD Day 174: How did day 173 get three awards bruh Day 175: Yall be saying this is pathetic but like how is it pathetic Day 176: I feel like a zombie sometimes Day 177: I dont even want a girlfriend Day 178: I am ending this sometime soon probably
On August 15, 2020, about 1600 eastern daylight time, a McSwain PA30 Superstol, N146BB, was substantially damaged when it was involved in an accident at a private airstrip near Clover, South Carolina. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal Regulations Part 91 personal flight. The pilot reported that he landed at a private, grass airstrip during the flight from York Airport (01SC), York, South Carolina to Gastonia Municipal Airport (AKH), Gastonia, North Carolina. He landed uneventfully and taxied for a takeoff to the northwest. During the initial climb, he noted that the airplane was not climbing as he expected. He maneuvered to avoid some trees; however, the airplane contacted the trees and he was unable to maintain control. The airplane crashed in a wooded area and he was met by first responders. An inspector with the Federal Aviation Administration responded to the accident site and examined the wreckage. He reported that there was structural damage to the wings, fuselage, and empennage. There was no fire. The wreckage was retained for further examination.
2020.09.17 03:21 geist7204Confused on annual benes letter
I’ll try to give the quick version. SC 70% since 2013 w TDIU @ 100%. Last exam was 2016. Have always done my part and followed the guidance of the VA and continue to do so....appts, forms filled completely and returned on time, etc. This year has been a CF especially getting in person MH appts which are invaluable to me. The PT, TBI and other stuff in person is easy to get. I digress. The meat: My letter this year basically said that I was not going to get any better on any front, that my conditions were now considered “static.” My combined rating of 70% is now permanent. However, the TDIU part appears to be going away in the #2 explanation which makes sense sense bc it’s “temporary.” The confusing part is this. Nowhere in this letter does it outline my benefit amounts other than saying it’s continued, just no further exams required. In ebenefits, nothing is noted there either, EXCEPT in the letters section. When I generate the full letter, it’s states in the “date at which you became totally and permanently disabled...” is 27 AUG 2020 which matches up with the date on the physical letter that I just received. On the same said letter, it also continues to state that “you are being paid at the 100% rate because you are unemployable...” I initially had an attorney help me with this claim in Florida, but am hesitant to contact them in case they want more $$$. I contacted my current POA of record in my state and they said I was fine. I am just checking all of my bases. I do not like surprises. Thanks brothers and sisters. G~
2020.09.17 02:18 JaketheAlmighty[H] Skaven AoS army [W] army swaps Blood Angels, Primaris Marines, Ad Mech [Loc] Canada
ahoy! barely play AoS these days so odds of me finishing this army are low. Some painted, some unpainted, some need assembly or are on sprue. I'm attaching my timestamp pics from a previous listing, but have also done a couple quick shots today with the bigger lot to prove I still have it. I can send an up to date timestamp of any model requested before we ship anything. I am NOT a skaven expert so if anything is mislabeled I apologise. They all look like rats. approx. list of skaven models sept16 timestamp older pics with shots of everything hoping to manage a trade all as one lot, or at most a few lots broken up to keep the shipping costs down. I am looking for any of the following in any combination. Prefer unpainted or NOS, but nothing is off limits.
Blood Angels (mainly primaris and SG, DC, etc)
Primaris marines in general. (Indomitus and otherwise. Bladeguard Veterans are a big want)
AdMech vehicles (except Dunecrawler), other new stuff as of Engine War.
assortment of bits - Incursor bits (to go with the SC infiltrators), Jump Packs (SG and DC, etc), thunder hammers & power fists, Sector Mechanicus ladder bits. also need a single of that circular end piece that goes on the exhaust of the SG jump pack.
wings from Drukhari Scourges and Stormcast Prosecutors. the entire model/sprue is fine too if you don't want to split it up.
Also paying cash for the FW Sanguinius model with the special limited scenic base that is no longer available. Hit me with a price. hope we can work something out! thanks
The map chosen by draw for the eighth leg is Africa by PizzaGuy. If you want to practice the map or understand the areas of the world covered and the number and distribution of locs click here
You can also find this map and others featured in this tournament in a link further down below
Difficulty will be  - Zooming/rotating allowed. Moving and External assistance prohibited, with a 1min timer in the whole preliminary stage including this game
If you want to formally accuse your opponent of breaking the rules, you'll have to provide solid proof. If you think a certain guess was suspicious, you can ask your opponent to clarify how he managed a score on a certain round, but he is under no obligation to comply (although it would be a nice thing to do)
If you can't play the round within the time limit let me know at least 24h before the deadline. Otherwise the round will be counted as 0 points.
Everybody will play the same seed(s), so you must wait till the deadline to upload videos or post spoilers.
Notify me if there is any problem with the seed(s)
Please post your score on this thread if you risk not being in the top 100 in this seed. Otherwise, it is not obligatory to do so.
The standings for the preliminary stage and knockout stage, as well as the maps used and the scheduled dates can be found here
Can You Start Dating While You Are Separated? Futeral ...
Dispatch’s Dating Sc★ndal List (From 2008 To 2018)
Roblox SCP is dating me now - YouTube
SC Episode 18 - Dating Hell - YouTube
7 BETWEEN the SHEETS THINGS WHITE men LOVE doing to BLACK ...
Southern Charm: Advice for Dating in South Carolina (Season 3) Bravo
SC First Official Dating Site Pee Dee Singles (Dating In SC)
Reason Why People DON’T MOVE To Myrtle Beach, SC? - YouTube
Speed Dating Colombian Women Medellin Colombia VLOG ...
How to meet a crossdresser? This is a great way. - YouTube
Dating Over 40. Joe DeVito - YouTube
Yoda expresses his thoughts about SC's First Official Dating Site www.peedeesingles.com and wishes the force be with you The Charmers give their best tips for dating in South Carolina. Subscribe for More: http://bravo.ly/Subscribe Visit the Official Site: http://bravo.ly/... Dispatch’s Dating Sc★ndal reveals from 2008 ~ 2018…Kai ♥ Jennie are 33rd c0uple on the list. #KpopNews #ABIZ #Jennie #Kai Subscribe to our channel https://goo.gl/6hDmWU Other Videos you ... Sexy Colombian women pack local banquet halls several times per year to attend private speed dating events, also known as romance tours. These speed dating e... Dating over 40 Can be difficult. For all sorts of dating advice after 40 watch 'First Of All...' By Joe DeVito only at http://www.drybarcomedy.com/joed Yes, you can have so much fun with my gurls. Why not join my Little Black Book and start chatting, Skyping and connecting with some of these great gurls. htt... Today I play Roblox SCP games and wow man didn't think SCP had a crush on me wow teehee Listen to my daughter Taylor, my new Co-Host, talk about her dating hell! NOTICE: I no longer upload to this channel and I no longer respond to messages concerning the content here, whether they are questions, comments, or otherwis... In this episode I describe why people do not end up moving to Myrtle Beach South Carolina. Here are the top two reasons why people decide to not move to the ...