Entries this day: Hack My_hugest_mySQL_query_so_far dang nin

Hack

11:34am JST Thursday 17 January 2008 (day 13812)

Very interesting. I've set up a bit of a hack to let me edit files locally with Emacs and have Cyberduck ssh them to my site. Okay; here goes my first test save.

crap. I couldn't do it.

I was trying to let cyberduck "edit with SubEthaEdit" and then edit that file with Emacs, but SubEthaEdit seems to not revert to the version I save with Emacs.

My hugest mySQL query so far

4:35pm JST Thursday 17 January 2008 (day 13812)

My biggest, meanest, hairiest, scariest mySQL so far (with some table names changed to imrove security):

(SELECT up.uid, up.status, up.request_date, up.expect_date, up.amount
 FROM (SELECT r_recs.uid, r_recs.status, r_recs.request_date, r_recs.expect_date, sum(r_recs.amount1) as amount
       FROM   (
	SELECT up.uid, ur.status, ur.request_date, ur.expect_date, (ur.amount + ur.bonus_amount) AS amount1
	     FROM Upper_Remun AS ur
	     LEFT JOIN User_Publish AS up ON ur.publish_id = up.publish_id
	     WHERE ur.status =4
	     AND up.uid =5 
       UNION ALL SELECT
	      fo.blogger1_uid as uid
	      ,fp.status
	      ,fp.request_date
	      ,fp.expect_date
	      ,fp.amount as amount1
	      FROM
	      Find_Peyton as fp 
	      LEFT JOIN
	      First_Off as fo
	      USING (firstoff_id)
	      WHERE fp.status = 4 
	     AND fo.b1_uid =5 
       ) AS r_recs 
       GROUP BY r_recs.uid, r_recs.status, r_recs.request_date, r_recs.expect_date
 ) AS up)
    UNION (
    SELECT uid,
    STATUS , request_date, expect_date, amounts AS amount
    FROM Upper_Peyton
    WHERE uid =5
    )

Before I started messing with it, it already had the second union. It took me a while to add the second select to top via the UNION ALL, but now that I've done it, I can call my project complete; just need to fill in Japanese where I have English.

5:43pm JST

中谷さん helped me with about 80% of the Japanese translations, but then had to go do other stuff. I'm left to play online! I think I'll work on one of *my* websites.

dang

8:04pm JST Thursday 17 January 2008 (day 13812)

Man this is weak. I can't figure out where is the "proper" place to make changes to the main menu on my new website featuring FreakAuthLight on code_igniter.

The documentation is full of misspellings and doesn't really make a lot of sense to me. Gah. I may have to ditch it and find a different PHP framework.

nin

8:12pm JST Thursday 17 January 2008 (day 13812)

Now I'm going to go home and sleep while listening to NIN,

                      or

I'm going to continue messing with my remix for NIN.