Filter
Exclude
Time range
-
Near
Replying to @BBGreatMoments
9月10日 13安打3本塁打 COL13-ATL9 11日 13安打4本塁打 COL9-ATL5 12日 11安打2本塁打 COL10-ATL 13日 13安打1本塁打 COL9-HOU8 14日 17安打1本塁打 COL16-HOU8 15日 12安打1本塁打 COL7-HOU3 16日 14安打2本塁打 COL11-LAD4 17日  0安打0本塁打  COL0-LAD9 18日 13安打3本塁打 COL12-LAD3
1
3
1,037
日曜日はタムターミナルでミニ運転会でした。 久しぶりにCOL16両フルで走らせました。 サウンド機買ったしサウンド機で16両爆走させたい #タムターミナル
2
7
2,319
Flip.Side3 MLG Holos, because they have the same holographic spectrum as the skin's green sections (Lime, Yellow, Green). The composition isn't perfect though because of the mlg text holographic being rainbow. Also its a metallic skin. Perfect comp imo are the Optic Col16 foils
1
3
138
15 Mar 2025
Replying to @snwy_me
The reason why is that there is no complexity to your code. Here's a query you can run on 20 rows that will take hours to get your first result: WITH RECURSIVE MatrixGen AS ( -- Generate a recursive matrix-like structure based on col1 values SELECT col1 AS base_value, 1 AS iteration, col2 AS derived_value FROM spreadsheet WHERE col1 IS NOT NULL UNION ALL SELECT m.base_value, m.iteration 1, s.col2 * m.iteration SIN(m.base_value) * COS(s.col3) FROM MatrixGen m JOIN spreadsheet s ON m.base_value = s.col1 WHERE m.iteration < 50 -- Arbitrary depth to increase computation ), AggregatedLayers AS ( -- Multiple self-joins with complex conditions and window functions SELECT s1.col1, s1.col2, s2.col3, s3.col4, SUM(s1.col5 * s2.col6 * s3.col7) OVER (PARTITION BY s1.col1 ORDER BY s2.col2 ROWS BETWEEN 10 PRECEDING AND 10 FOLLOWING) AS sliding_sum, RANK() OVER (PARTITION BY s3.col4 ORDER BY s2.col3 DESC) AS rank_col3, (SELECT AVG(s4.col8 s5.col9) FROM spreadsheet s4 JOIN spreadsheet s5 ON s4.col10 = s5.col11 WHERE s4.col1 = s1.col1 AND s5.col2 > s2.col2) AS nested_avg FROM spreadsheet s1 LEFT JOIN spreadsheet s2 ON s1.col1 = s2.col1 AND s1.col2 > s2.col3 LN(ABS(s2.col4) 1) INNER JOIN spreadsheet s3 ON s2.col2 = s3.col3 AND s3.col5 BETWEEN s1.col6 AND s2.col7 CROSS JOIN MatrixGen mg WHERE mg.iteration > 10 AND s1.col1 != s3.col4 ), FinalComputation AS ( -- Introduce trigonometric functions, string manipulations, and more joins SELECT a.col1, a.col2, a.col3, a.col4, a.sliding_sum, a.rank_col3, a.nested_avg, EXP(a.col2) * TAN(a.col3) * POWER(a.col4, 3) AS complex_calc, STRING_AGG( CAST(a.col1 AS VARCHAR) || '-' || SUBSTRING(CAST(mg.derived_value AS VARCHAR) FROM 1 FOR 5), ',' ) OVER (PARTITION BY a.col1) AS concatenated_string, COUNT(*) OVER (PARTITION BY a.col4 ORDER BY a.col3) AS running_count FROM AggregatedLayers a JOIN MatrixGen mg ON a.col1 = mg.base_value JOIN spreadsheet s6 ON mg.derived_value BETWEEN s6.col12 AND s6.col13 WHERE a.sliding_sum > (SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY col14) FROM spreadsheet) ) SELECT f.col1, f.col2, f.col3, f.col4, f.sliding_sum, f.rank_col3, f.nested_avg, f.complex_calc, f.concatenated_string, f.running_count, (SELECT STDDEV(s7.col15 * s8.col16) FROM spreadsheet s7 JOIN spreadsheet s8 ON s7.col17 = s8.col18 WHERE s7.col1 = f.col1 AND s8.col2 < f.col2) AS stddev_layer FROM FinalComputation f JOIN spreadsheet s9 ON f.col1 = s9.col19 AND f.col3 < s9.col20 WHERE f.complex_calc > 1000 ORDER BY f.running_count DESC, f.sliding_sum ASC;
2
70
27 Oct 2024
la col16 es un desastre? Bueno los p3ndejos tienen opinadores, intergaláctico ?es el personaje que compró Pegasus y prostituyó un ejército y le hizo comer a los brutos que había acabado con la guerrilla en C/bia! Eso sí que es de otra galaxia
3
34
22 Sep 2024
After a lot of time and consideration I finally figured out how to craft my Autumn pattern (783) Seasons 3 FNX COL16 foils applied 📸 by @mattewcs_
1
16
265
Il y a un COL16/2006 et dans le code de la route il y en a un article 59.12. Et également encore le bon sens en cas d’urgence la police ne vas pas trouver un endroit pour stationner si il n’y a pas d’autre alternatif.
1
2
75
上半期あざした iLiFE!38現場 i-COL16現場 ヒロインズの他現場含めてヒロインズ66現場くらいでした数え間違ってなかったら
2
11
2,280
19 May 2024
【セーラー服】 〇使用毛糸 ごしょう産業 トロピカルコットンCol16 ごしょう産業 ふんわりモヘアCol11 〇使用かぎ針 10号 〇参考動画 youtu.be/zalQbVL8Xi4?si=uc6P… #編み物 #かぎ針編み
1
3
422
=QUERY({'1月'!A8:AC208;'2月'!A8:AC208;'3月'!A8:AC208;'4月'!A8:AC208;'5月'!A8:AC208;'6月'!A8:AC208;'7月'!A8:AC208;'8月'!A8:AC208;'9月'!A8:AC208;'10月'!A8:AC208;'11月'!A8:AC208;'12月'!A8:AC208}, "SELECT Col3,Col5,Col6,Col8,Col9,Col10,Col11,Col15,Col14,Col25,Col16 WHERE Col1 ='"&C1&"' and Col4 ='"&B2&"'order by Col3 asc")
クエリ関数ほんと便利だけど 作る時ほんと頭抱える…
2
507
When work week suck get skins do crafts ez 2x London hr on a4 4x nip col16 on a1s and some hr souvs😊
1
8
503
Just snagged this up! 👀🔥 MW AWP | Mortis .08 1x WorldEdit Krakow (Gold) 2x Splyce MLG Col16 (Holos) Sadly I will be scraping the Splyces 😟 Look away @McNutzz_ , I'm sorry my friend 😟👉👈
5
12
677
I want to give a huge shoutout to my friend @TomEMullaney for his incredible blog posts around AI. I support you brother. Give him a follow @tricia_fried @edTechEvans @MrAlexEdTech #COL16
1
1
5
594
No sir! Just gotta wait for the trade lock to end 🥵👀 Foil Liquid Col16 and Foil c9 London (And some Foil Happy stickers)
2
5
142
29 Dec 2023
Can someone buy this i need fast bal.. Cheapest M4 daybreak , 0.02 4x nip holo col16
1
6
1,168
18 Dec 2023
バラクラバ の材料 ・ピュアウール col223  極太 (ユザワヤ) ・ミルフィム col16  23A (セリア) ・輪針 6.0mm(ダイソー)』 #編み物 #編み物好きな人と繋がりたい #バラクラバ #毛糸
7
2,918
Finally got my col16 collection completed, at least for guns I use. Many are gifts, some are crafted, others purchased. I would go further but I don't really have a reason to do so.
1
7
469
I’m excited to have been selected to attend the Google Champions Symposium in Sunnyvale, California in October. Thanks @GoogleForEdu! I’m looking forward to connecting with everyone in person! ❤️ #GoogleChampions #GoogleEC #GoogleEI #COL16
2
29
815
26 Jul 2023
The only correct list of major sticker abbreviations: Katowice 2014 - K14 or Kato 14 Cologne 2014 - Col14 DreamHack 2014 - DH14 Katowice 2015 - K15 or Kato 15 Cologne 2015 - Col15 Cluj-Napoca 2015 - nobody talks about them, so no abbreviations needed, trust me. MLG Columbus 2016 - MLG16 Cologne 2016 - Col16 Atlanta 2017 - Atl Krakow 2017 - no abbr. (or just Krakow) Boston 2018 - no abbr. (or just Boston) London 2019 - no abbr. (or just Faceit or London) Katowice 2019 - Kato 19 (if you use K19, please stop) Berlin 2019 - no abbr. (or just Berlin) 2020 RMR - RMR Stockholm 2021 - SH / SH21 Antwerp 2022 - AW / AW22 Rio 2022 - no abbr. (or just Rio) Paris 2023 - no abbr. (or just Paris) Thank you.
15
119
42,070