千葉県のライブハウス一覧
Page 1 of 1, total 6
-
- 関東 千葉県
千葉LOOK
- 約 200 人
-
- 関東 千葉県
幕張メッセ国際展示場 9～11ホール
- 約 ---- 人
-
- 関東 千葉県
幕張メッセ国際展示場 1～8ホール
- 約 ---- 人
-
- 関東 千葉県
木更津GRAPH
- 約 280 人
-
- 関東 千葉県
柏 PALOOZA
- 約 500 人
-
- 関東 千葉県
柏ZaX
- 約 200 人
Page 1 of 1, total 6
Page 1 of 1, total 6
Page 1 of 1, total 6
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Region`.`id`, `Region`.`name` FROM `kuinazi_gorori`.`regions` AS `Region` WHERE 1 = 1 | 9 | 9 | 0 | |
| 2 | SELECT `Region`.`id`, `Region`.`name` FROM `kuinazi_gorori`.`regions` AS `Region` WHERE `Region`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| 3 | SELECT `Prefecture`.`id`, `Prefecture`.`name` FROM `kuinazi_gorori`.`prefectures` AS `Prefecture` WHERE `Prefecture`.`region_id` = 3 | 7 | 7 | 0 | |
| 4 | SELECT `Prefecture`.`id`, `Prefecture`.`region_id`, `Prefecture`.`name`, `Region`.`id`, `Region`.`name` FROM `kuinazi_gorori`.`prefectures` AS `Prefecture` LEFT JOIN `kuinazi_gorori`.`regions` AS `Region` ON (`Prefecture`.`region_id` = `Region`.`id`) WHERE `Prefecture`.`id` = 12 LIMIT 1 | 1 | 1 | 0 | |
| 5 | SELECT `Hall`.`id`, `Hall`.`name`, `Hall`.`capacity`, `Hall`.`prefecture_id`, `Hall`.`address`, `Hall`.`address2`, `Hall`.`tel`, `Hall`.`url`, `Hall`.`email`, `Hall`.`note`, `Hall`.`del_flg`, `Hall`.`created`, `Hall`.`modified`, `Prefecture`.`id`, `Prefecture`.`region_id`, `Prefecture`.`name` FROM `kuinazi_gorori`.`halls` AS `Hall` LEFT JOIN `kuinazi_gorori`.`prefectures` AS `Prefecture` ON (`Hall`.`prefecture_id` = `Prefecture`.`id`) WHERE `Hall`.`del_flg` = 0 AND `Prefecture`.`region_id` = 3 AND `Prefecture`.`id` = 12 ORDER BY `Hall`.`name` asc LIMIT 40 | 6 | 6 | 0 | |
| 6 | SELECT COUNT(*) AS `count` FROM `kuinazi_gorori`.`halls` AS `Hall` LEFT JOIN `kuinazi_gorori`.`prefectures` AS `Prefecture` ON (`Hall`.`prefecture_id` = `Prefecture`.`id`) WHERE `Hall`.`del_flg` = 0 AND `Prefecture`.`region_id` = 3 AND `Prefecture`.`id` = 12 | 1 | 1 | 0 |
