Array
(
    [0] => Array
        (
            [file] => /home/koima/html/lib/db_mysql.class.html
            [line] => 32
            [function] => calleeInfo
            [args] => Array
                (
                )

        )

    [1] => Array
        (
            [file] => /home/koima/html/modules/koima_price/koima_price_sub.html
            [line] => 252
            [function] => query
            [class] => DB
            [type] => ->
            [object] => DB Object
                (
                    [conn] => Resource id #43
                    [db] => koima
                    [result] => Array
                        (
                            [0] => Resource id #68
                            [1] => Resource id #69
                            [2] => 
                            [11] => Resource id #70
                            [5] => Resource id #71
                        )

                )

            [args] => Array
                (
                    [0] => SELECT
M.main_item_name										AS main_item_name
,S.sub_item_name										AS sub_item_name
,S.sub_item_unit										AS sub_item_unit
,S.sub_item_market										AS sub_item_market
,IF(S.sub_item_spot_future = 'S', '현물', '선물')		AS sub_item_spot_future
,(
	SELECT price_price
	FROM koima_price_price
	WHERE price_date = (
		SELECT price_date
		FROM koima_price_price
		WHERE price_date <= DATE_SUB('2013-05-23', INTERVAL 1 MONTH)
		AND main_item_no = 79
		AND sub_item_no = 40
		ORDER BY price_date DESC
		LIMIT 0, 1
	)
	AND main_item_no = 79
	AND sub_item_no = 40
) AS last_month_price
,(
	SELECT price_price
	FROM koima_price_price
	WHERE price_date = (
		SELECT price_date
		FROM koima_price_price
		WHERE price_date <= DATE_SUB('2013-05-23', INTERVAL 1 DAY)
		AND main_item_no = 79
		AND sub_item_no = 40
		ORDER BY price_date DESC
		LIMIT 0, 1
	)
	AND main_item_no = 79
	AND sub_item_no = 40
) AS yesterday_price
#연평균 필요하면 주석 풀고 사용
#기준일자 기준 년평균
#,ROUND(
#	(SELECT AVG(price_price)
#	FROM koima_price_price
#	WHERE sub_item_no = 40
#	AND price_date BETWEEN DATE_SUB('2013-05-23', INTERVAL 1 YEAR) AND '2013-05-23'
#	), 2) AS average_year_by_date
#현재날자 기준 년평균
#,ROUND(
#	(SELECT AVG(price_price)
#	FROM koima_price_price
#	WHERE sub_item_no = 40
#	AND price_date BETWEEN DATE_SUB(NOW(), INTERVAL 1 YEAR) AND NOW()
#	), 2) AS average_year_by_now
FROM
koima_price_sub_item AS S
LEFT JOIN
koima_price_main_item AS M
ON S.main_item_no = M.main_item_no
WHERE
S.sub_item_no = 40
                    [1] => 2
                )

        )

)