HOME > ライブハウス

ライブハウス一覧

Page 6 of 8, total 284

Page 6 of 8, total 284

12345678
(default) 3 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Region`.`id`, `Region`.`name` FROM `kuinazi_gorori`.`regions` AS `Region` WHERE 1 = 1990
2SELECT `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 ORDER BY `Prefecture`.`region_id` asc, `Prefecture`.`id` asc, `Hall`.`name` asc LIMIT 200, 4040402
3SELECT 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` = 0110