| 1 x Booting (52.22%) | 934ms |
| 1 x Application (47.78%) | 854ms |
# Query soft and hard limit for Debugbar are reached. Only the first 100 queries show details. Queries after the first 500 are ignored. Limits can be raised in the config (debugbar.options.db.soft/hard_limit).select count(*) as aggregate from `languages` where `code` = 'it'| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_page_contents` where `alias` = 'statistiques-en' and `page_id` is not null| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `alias` = 'statistiques-en' and `page_id` is not null order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `miki_pages`.`id` = 33 limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_page_contents` where `miki_page_contents`.`page_id` = 33 and `miki_page_contents`.`page_id` is not null and `created_at` > '2018-04-20 09:55:39' and `language_code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_theme_templates` where `miki_theme_templates`.`id` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_themes` where `miki_themes`.`id` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `languages`| Backtrace |
|
select `user_groups`.*, `has_user_groups`.`has_user_group_id` as `pivot_has_user_group_id`, `has_user_groups`.`user_group_id` as `pivot_user_group_id`, `has_user_groups`.`has_user_group_type` as `pivot_has_user_group_type` from `user_groups` inner join `has_user_groups` on `user_groups`.`id` = `has_user_groups`.`user_group_id` where `has_user_groups`.`has_user_group_id` = 33 and `has_user_groups`.`has_user_group_type` = 'App\\MikiPage'| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `default` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 3 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `languages` where `main_language` = 1 limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_boxes` where `name` = 'main_sponsor_left'| Bindings |
|
| Backtrace |
|
select * from `miki_boxes` where `name` = 'main_sponsor_left' limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_box_contents` where `miki_box_contents`.`box_id` = 15 and `miki_box_contents`.`box_id` is not null and `language_code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_box_contents` where `miki_box_contents`.`box_id` = 15 and `miki_box_contents`.`box_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_boxes` where `name` = 'main_sponsor_right'| Bindings |
|
| Backtrace |
|
select * from `miki_boxes` where `name` = 'main_sponsor_right' limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_box_contents` where `miki_box_contents`.`box_id` = 16 and `miki_box_contents`.`box_id` is not null and `language_code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_box_contents` where `miki_box_contents`.`box_id` = 16 and `miki_box_contents`.`box_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `languages`| Backtrace |
|
select * from `miki_places` where `category_id` = 24 and `state` = 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 7 and `pictures`.`has_images_id` is not null| Bindings |
|
| Backtrace |
|
select * from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 7 and `pictures`.`has_images_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 9 and `pictures`.`has_images_id` is not null| Bindings |
|
| Backtrace |
|
select * from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 9 and `pictures`.`has_images_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 14 and `pictures`.`has_images_id` is not null| Bindings |
|
| Backtrace |
|
select * from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 14 and `pictures`.`has_images_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_places` where `category_id` = 22 and `state` = 1| Bindings |
|
| Backtrace |
|
select * from `miki_places` where `category_id` = 23 and `state` = 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 1 and `pictures`.`has_images_id` is not null| Bindings |
|
| Backtrace |
|
select * from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 1 and `pictures`.`has_images_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 2 and `pictures`.`has_images_id` is not null| Bindings |
|
| Backtrace |
|
select * from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 2 and `pictures`.`has_images_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 11 and `pictures`.`has_images_id` is not null| Bindings |
|
| Backtrace |
|
select * from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 11 and `pictures`.`has_images_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_boxes` where `name` = 'sponsors-top'| Bindings |
|
| Backtrace |
|
select * from `miki_boxes` where `name` = 'sponsors-top' limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_box_contents` where `miki_box_contents`.`box_id` = 11 and `miki_box_contents`.`box_id` is not null and `language_code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_box_contents` where `miki_box_contents`.`box_id` = 11 and `miki_box_contents`.`box_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `state` = 1 and `menu` = 1 and `parent_id` is null order by `position` asc| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `parent_id` = 3 and `menu` = '1' and `state` > 0| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 3 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `languages` where `main_language` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 3 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `parent_id` = 32 and `menu` = '1' and `state` > 0| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 32 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = 'calendar'| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `name` = 'calendar' limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 1 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 32 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `parent_id` = 32 and `state` > 0 and `menu` = '1' order by `position` asc| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 1 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 1 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `parent_id` = 1 and `menu` = '1' and `state` > 0| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `parent_id` = 1 and `state` > 0 and `menu` = '1' order by `position` asc| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 48 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = 'competitions-list'| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `name` = 'competitions-list' limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 40 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 48 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 49 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = 'competitions-list'| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `name` = 'competitions-list' limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 40 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 49 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 50 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = 'competitions-list'| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `name` = 'competitions-list' limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 40 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 50 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 51 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = 'competitions-list'| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `name` = 'competitions-list' limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 40 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 51 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 52 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = 'competitions-list'| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `name` = 'competitions-list' limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 40 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 52 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 53 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = 'competitions-list'| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `name` = 'competitions-list' limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 40 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 53 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 54 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `fsih_competitions` where `fsih_competitions`.`id` = ? limit 1select count(*) as aggregate from `fsih_seasons` where `default` = ?select * from `fsih_seasons` where `default` = ? limit 1select `fsih_players`.`id` as `id`, `fsih_game_fsih_player`.`team_id` as `team_id`, COUNT(fsih_games.id) as nb_games from `fsih_players` inner join `fsih_game_fsih_player` on `fsih_game_fsih_player`.`fsih_player_id` = `fsih_players`.`id` inner join `fsih_games` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` where `fsih_players`.`licence` is not null and `fsih_game_fsih_player`.`team_id` is not null and `fsih_games`.`season_id` = ? and `fsih_games`.`competition_id` = ? and `fsih_game_fsih_player`.`role` like ? group by `fsih_players`.`id`, `fsih_game_fsih_player`.`fsih_player_id` having COUNT(fsih_games.id) > 0 order by `fsih_players`.`id` ascselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1select count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_games`.`competition_id` = ?) and `fsih_stats`.`deleted_at` is null... 1501 additional queries are executed but now shown because of Debugbar query limits. Limits can be raised in the config (debugbar.options.db.soft/hard_limit)200
[]
[]
0 of 0array:17 [▼ "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "cookie" => array:1 [▶ 0 => "PHPSESSID=cae6bb371b8ac9eb16b1df34107923f7; XSRF-TOKEN=eyJpdiI6IlFXckh0WTBHeUZzN0VUNXdscE9aSlE9PSIsInZhbHVlIjoieWgxUFluS2tsejAxaHJnU2hyWkNYZ0M0dmhDT1djL1ZOTklQeEJQNm8vSXF0VEswVmpJTDROOTdwb2ZOZ3ZnOGxwRlltdHhQOWVTSURlS2dEZzlEUlp3RUQ3alZXNkg3dTF5Y2IzMG9JZ3pSb2NrZy9nUDQxUjc4U0p6cWVYS24iLCJtYWMiOiI2OTM0MTg2ZWM4ZTYxNjcwZjdjY2FmZDcyYWJjOWRkMjRjMTdhM2Q0ZTJjNjNlNTY5M2FjYWQ4ZTEzMDg5OWQ1IiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6InZZVVQwanNPUXA5dXFtRUUySUsrQUE9PSIsInZhbHVlIjoiay9nVUlrZW5iRFdxekFUTk5XUC9jeE41bnExdlppRVV1d1VVZGZ2TTBFVHZzaVgvRmtDb2UwRjVsTWhNRmhoblo2OUtjcXR6NTZva2hRY1k4Q1ZXZHU5aWtYUWpMTnZ2SFZKNmtkNG5VY3R0WTA2cEJJclZYUlE4bHJ6azY5Q08iLCJtYWMiOiI3MGRkM2RlZWUwYTcyMjMzYmY5YTc0MDUxY2UyYmYyYTc0NDUzMjA2YWNmNzVkNDY0MzMzN2RkMGVkOGM1ZmJlIiwidGFnIjoiIn0%3D ◀PHPSESSID=cae6bb371b8ac9eb16b1df34107923f7; XSRF-TOKEN=eyJpdiI6IlFXckh0WTBHeUZzN0VUNXdscE9aSlE9PSIsInZhbHVlIjoieWgxUFluS2tsejAxaHJnU2hyWkNYZ0M0dmhDT1djL1ZOTklQe ▶" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "host" => array:1 [▶ 0 => "beta.inline-hockey.ch" ] ]
0 of 0array:3 [▼ "PHPSESSID" => null "XSRF-TOKEN" => "bjGe0hcGgzEUMF7MmMx6R7Y1mC1b8LOp5VID3abS" "laravel_session" => "PD4Y7Dsm7gFcv7hvDnV3RTO6ZTkua02iYOVkzIpp" ]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sun, 27 Jul 2025 17:21:16 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjJiTmx1RExaTnhaMkNPaFRIVkVQMWc9PSIsInZhbHVlIjoiYllRVThaQlF2ZS9jSkdoM1RCNHpGNDdWc09hVUI0SExJOVYwTXN3UnpPeTJpZ01QSy9DNzdYVkJVaFd4WjQrYWo2VjRmT0Jkek5La3VacnF1eFlkYnNHRFhVbzA3NUkyMkc1clE4Z1ZXZHFyVHArbHd2bDltNmZ1a2NFZFIwQksiLCJtYWMiOiIxYjZkMTM0NDA1ODg1YWEwYjliZmFjZDZkOGI0Y2YxZGNhZDJiMmIwYzNmNmY0M2U1M2JkZjU0OGJjOWYwOTIwIiwidGFnIjoiIn0%3D; expires=Mon, 28 Jul 2025 05:21:16 GMT; Max-Age=43200; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjJiTmx1RExaTnhaMkNPaFRIVkVQMWc9PSIsInZhbHVlIjoiYllRVThaQlF2ZS9jSkdoM1RCNHpGNDdWc09hVUI0SExJOVYwTXN3UnpPeTJpZ01QSy9DNzdYVkJVaFd4WjQrYWo2VjRmT ▶" 1 => "laravel_session=eyJpdiI6ImFsMDljWWk1RVYwVlhIVG1mTTlwZEE9PSIsInZhbHVlIjoiZWtua0FTVTcwUkNycVlwMklqemRvTUJDTHplcXV6eFNLZC9zT3JTNkZKTXQwVUZCdnZCRjUrZmdoMDVlOUZMZ1RiYWNDeTBZeFBFRVFpSWhCNkRVVFJIRzhVVERCS1IxblgvOTZkUUtWcE1vV2oydkQ4VDVLYWpRT3YvMTMrbU0iLCJtYWMiOiJkMTlkNDZjMWIxYWJkMDBlOWQzYmQ1MWVjZTc4MmU3NmE0MjVkZWRiOWNkMTFkOTc5NjVjZTE5YjlkYTIwNDBhIiwidGFnIjoiIn0%3D; expires=Mon, 28 Jul 2025 05:21:16 GMT; Max-Age=43200; path=/; secure; httponly ◀laravel_session=eyJpdiI6ImFsMDljWWk1RVYwVlhIVG1mTTlwZEE9PSIsInZhbHVlIjoiZWtua0FTVTcwUkNycVlwMklqemRvTUJDTHplcXV6eFNLZC9zT3JTNkZKTXQwVUZCdnZCRjUrZmdoMDVlOUZMZ1Ri ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjJiTmx1RExaTnhaMkNPaFRIVkVQMWc9PSIsInZhbHVlIjoiYllRVThaQlF2ZS9jSkdoM1RCNHpGNDdWc09hVUI0SExJOVYwTXN3UnpPeTJpZ01QSy9DNzdYVkJVaFd4WjQrYWo2VjRmT0Jkek5La3VacnF1eFlkYnNHRFhVbzA3NUkyMkc1clE4Z1ZXZHFyVHArbHd2bDltNmZ1a2NFZFIwQksiLCJtYWMiOiIxYjZkMTM0NDA1ODg1YWEwYjliZmFjZDZkOGI0Y2YxZGNhZDJiMmIwYzNmNmY0M2U1M2JkZjU0OGJjOWYwOTIwIiwidGFnIjoiIn0%3D; expires=Mon, 28-Jul-2025 05:21:16 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjJiTmx1RExaTnhaMkNPaFRIVkVQMWc9PSIsInZhbHVlIjoiYllRVThaQlF2ZS9jSkdoM1RCNHpGNDdWc09hVUI0SExJOVYwTXN3UnpPeTJpZ01QSy9DNzdYVkJVaFd4WjQrYWo2VjRmT ▶" 1 => "laravel_session=eyJpdiI6ImFsMDljWWk1RVYwVlhIVG1mTTlwZEE9PSIsInZhbHVlIjoiZWtua0FTVTcwUkNycVlwMklqemRvTUJDTHplcXV6eFNLZC9zT3JTNkZKTXQwVUZCdnZCRjUrZmdoMDVlOUZMZ1RiYWNDeTBZeFBFRVFpSWhCNkRVVFJIRzhVVERCS1IxblgvOTZkUUtWcE1vV2oydkQ4VDVLYWpRT3YvMTMrbU0iLCJtYWMiOiJkMTlkNDZjMWIxYWJkMDBlOWQzYmQ1MWVjZTc4MmU3NmE0MjVkZWRiOWNkMTFkOTc5NjVjZTE5YjlkYTIwNDBhIiwidGFnIjoiIn0%3D; expires=Mon, 28-Jul-2025 05:21:16 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6ImFsMDljWWk1RVYwVlhIVG1mTTlwZEE9PSIsInZhbHVlIjoiZWtua0FTVTcwUkNycVlwMklqemRvTUJDTHplcXV6eFNLZC9zT3JTNkZKTXQwVUZCdnZCRjUrZmdoMDVlOUZMZ1Ri ▶" ] ]
0 of 0array:4 [▼ "_token" => "bjGe0hcGgzEUMF7MmMx6R7Y1mC1b8LOp5VID3abS" "last_miki_page" => 33 "_previous" => array:1 [▶ "url" => "https://beta.inline-hockey.ch/statistiques-en/100" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]