DELIMITER $$
DROP PROCEDURE IF EXISTS `sp_get_blog_options` $$
CREATE PROCEDURE `sp_get_blog_options`(
IN db_name varchar(100),
IN option_value varchar(100),
IN summary_flag int
)
BEGIN
DECLARE not_found int DEFAULT 0;
DECLARE _blog_id bigint(20);
DECLARE _table_name varchar(100);
DECLARE _get_table_name varchar(100);
DECLARE cur CURSOR FOR SELECT blog_id FROM wp_blogs WHERE spam <> 1;
DECLARE cur2 CURSOR FOR SELECT table_name FROM `information_schema`.`tables` WHERE `table_name` = _table_name AND `table_schema` = db_name;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET not_found = 1;
DROP TABLE IF EXISTS `tmp_options`;
CREATE TEMPORARY TABLE `tmp_options` (`blog_id` bigint(20), `option_value` varchar(50));
OPEN cur;
loop1: LOOP
FETCH cur INTO _blog_id;
IF not_found THEN
CLOSE cur;
LEAVE loop1;
END IF;
OPEN cur2;
SET _table_name = CONCAT('wp_', _blog_id, '_options');
FETCH cur2 INTO _get_table_name;
IF not_found THEN
SET not_found = 0;
ELSE
SET @s = CONCAT('SELECT option_value INTO @option_value FROM `wp_', _blog_id, '_options` WHERE option_name=?');
PREPARE stmt FROM @s;
SET @val = option_value;
EXECUTE stmt USING @val;
DEALLOCATE PREPARE stmt;
INSERT INTO tmp_options VALUES (_blog_id, @option_value);
END IF;
CLOSE cur2;
END LOOP;
IF summary_flag THEN
SELECT tmp_options.option_value, count(tmp_options.option_value) AS counter FROM tmp_options GROUP BY tmp_options.option_value ORDER BY count(tmp_options.option_value);
ELSE
SELECT * FROM tmp_options;
END IF;
END $$
DELIMITER ;
|
|
|
@ini_set('memory_limit', '128M');[PS3]--(Optical)--[Recon3D]-+--(USB)--[PC]
+--(LINE)--[DR-GA200]
|
スクウェア・エニックス
￥ 6,180 (2011-11-17) |
|
クリエイティブ・メディア
￥ 11,635 (2011-10-29) |
|
|
|
| 定価 | 59,800 |
| AV13%OFF + AV5%OFF | -10,764 |
| ソニーカード3%OFF | -1,471 |
| 購入価格 | 47,565 |
|
|
ソニー・コンピュータエンタテインメント
￥ 8,076 (2011-12-17) |
|
TUNEWEAR
￥ 1,782 (2011-10-14) |
|
パワーサポート
￥ 1,290 (2010-07-08) |
|
