2010 March
-
@switchfollows pili ka ng rk post cards na ipapasign natin :p Is the prerelease Avatar of Woe by him?
-
@wrongwaygoback where in HK? It's hard to find MTG there, the only store I found was in Mongkok and it was literally a hole in the wall
-
RT @zeichen95: Scott Pilgrim vs. the World https://www.youtube.com/watch?v=WtKAfoIllbo&feature=player_embedded
-
The first challenger was soundly defeated! Any other takers? Thanks for the game Jaime :D
-
@switchfollows why are you in indonesia? PS msg me on ym/fb/whatever.
-
Open challenge! Anyone want to start a scrabble game with me? Just start a 2-player game with me, use a 1-day time limit (para pwede asynchronous)
-
Eto yung proof na tumakbo talaga ako. Pero feeling ko sa may start pa ito, parang marami pa kong energy based sa facial expression :D
(Click photos to view full-size)
-
Played my first constructed #MTG tournament in more than half a year. Jund is awesome, but am still too rusty esp. w/ sb plans, went 3-3
-
@pluish @rocketkeis kaya nyo yan! too bad nde ako kasama sa earth run :p
-
araw-araw kaya kami may earth hour. usually nga more than one hour! kaso tulog kami parati sa time na yun
-
dumilim!
-
The farewell gift from CICS teammates. :D
(Click photos to view full-size)
-
@aleksfelipe you should try to figure out why you're generating so many perms.
-
Commuting is too stressful. Also, please don't vote for any candidate that causes traffic jams with his motorcade.
-
I heard there was an earthquake. I didn't feel it.
-
Dick Gordon for President!
Quoted Maoi Arroyo's Facebook post:Got this comparative table of the major presidentiable candidates via Twitter and Plurk. Don't know who the author is or if this is even accurate, but IF it's true, then I know who I'm voting for. 😃
(Click photos to view full-size)
-
@rocketkeis guppy!
-
MINUS is the same as saying "get all the rows of the first query, then from that set remove the rows that are also in the second query", so you could like load the results from the first query into an array in-memory, then loop through the second query results and check them one-by-one against the first query results and remove them if they exist.
I'm not sure that will actually perform better though (depends on a lot of things). You might also want to consider using NOT EXISTS instead and check that performance, i.e.
SELECT RTRIM(LTRIM(A.HEAD)), A.EFFECTIVE_DATE, FROM TABLE_1 A WHERE A.TYPE_OF_ACTION='6' AND A.EFFECTIVE_DATE >= ADD_MONTHS(SYSDATE,-15) AND NOT EXISTS ( SELECT 1 fFROM TABLE_2 B WHERE RTRIM(LTRIM(A.HEAD)) = RTRIM(LTRIM(B.HEAD)) AND A.EFFECTIVE_DATE = B.EFFECTIVE_DATE )Some functional indexing may also be needed on RTRIM(LTRIM(A.HEAD))
-
it seems that I lost almost 200 rep on stackoverflow for no reason, as if it was never there
-
♻ @chrisguillebeau: It takes courage to believe in yourself. (via @conversationage)
