1 x Application (83.26%) | 847ms |
1 x Booting (16.74%) | 170ms |
# 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` = 'de'
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 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
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 1
select 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` asc
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
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 1
select 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` asc
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
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 1
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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
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 1
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 1
select 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` asc
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 1
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 1
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 1
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 1
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 1
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 1
select 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 1
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 1
select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` asc
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 1
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 1
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 1
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 1
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 1
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 1
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 1
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 1
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 1
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 1
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 1
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 1
select 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 1
select count(*) as aggregate from `miki_pages` where `name` = ?
select * from `miki_pages` where `name` = ? limit 1
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 1
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 1
select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` asc
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 1
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 1
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 1
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 1
select 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 1
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 1
select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` asc
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 1
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 1
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 1
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 1
select 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 1
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 1
select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` asc
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 1
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 1
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 1
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 1
select 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 1
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 1
select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` asc
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 1
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 1
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 1
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 1
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 1
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 1
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 1
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 1
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 1
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 1
select 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 1
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 1
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 1
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 1
select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` asc
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 1
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 1
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 1
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 1
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 1
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 1
select 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 1
select * from `fsih_competitions` where `fsih_competitions`.`id` = ? limit 1
select count(*) as aggregate from `fsih_seasons` where `default` = ?
select * from `fsih_seasons` where `default` = ? limit 1
select `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` asc
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select 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
select 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
... 1516 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=156e779ab18074d2ee6e62afca02f341; XSRF-TOKEN=eyJpdiI6IjhwMHlRVGwzVzQ2Tnh1Nnp5VGw4ZHc9PSIsInZhbHVlIjoiMWtDdzN3Kys5WWJadU9rSFozRW5HcUZ5MDh4VGpFYm1qNXhpRUVMdFJ0UjNnU1N2UFdNbUw1OHZEeCs3VkdnSWxTbElvNEpGU0FLei9KS2VOdUdKZG1KUVdtYUVnTXkycWRVZy9Ja0YwbVQwNTJ6aE1WdXVyTWFDcGwzTjBaY0YiLCJtYWMiOiJlZDQ1NWE5NjQyMjdjMTM1MzdhNTQxMTEwMGYzZTZmYWU0OGQxN2Q0ZWE3N2Y3ZjY4MDMwZGUzMDhlMGIxY2YxIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6InFkaS9ZbmVKK2xOQzNKSGNqajlReVE9PSIsInZhbHVlIjoiakRldDUrN0xLdXMxaXo1S0xKOFRxSENoajByd25ZV2ZtOHU3YzZ2c1NTbCtzUWdYbGZwRWpFTHRPNVNCT2ZyZ2FNdndwekVMZnNReVV0RE1PYVZZbXl3RlZ5VzZFQzBMTmFXelMrQm1kclR1ai9zdDVZSHZVbTJjd0tlRTc4QjAiLCJtYWMiOiJhNzUzN2YxNDY1ZGIyODhjZjY1NTE4YzI5YWUyMDNjODY2YjBhMDM2M2E2NjJhMWEzYjIxMzg3YzhlMmY2ZmYzIiwidGFnIjoiIn0%3D ◀PHPSESSID=156e779ab18074d2ee6e62afca02f341; XSRF-TOKEN=eyJpdiI6IjhwMHlRVGwzVzQ2Tnh1Nnp5VGw4ZHc9PSIsInZhbHVlIjoiMWtDdzN3Kys5WWJadU9rSFozRW5HcUZ5MDh4VGpFYm1qNXhpR ▶" ] "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" => "b2EliPmVtPRs50F8r0SzIspues6PduT55qrvgz29" "laravel_session" => "hanOt4Yd3GTvDxy4vcUXWy1jWFJnRSHX8hxl2bYV" ]
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 => "Tue, 08 Jul 2025 06:48:09 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjFORzJsM1cycXprWmMzbEFLRlBHY2c9PSIsInZhbHVlIjoiUExuWlFuTFQwTThmb1FZRnQ5cnF0SFdLcGwxNmpqZlhIaDkrSTNlTUNINjcwbTRodTFhS1lFaHEwdmVJRUlnM1pmUzVRbjBRbk9TZkZNcm9JbzFJZUtFUXFudVVkUjFaQ3oxQ1JLb3o3U0pXMkJ2akFCYTlmcG51YnZlc3lTMEkiLCJtYWMiOiJjZDU3ZWFhODJkMzRlZTgzM2UwNGZmNWQ4YjE1ZDhiYjk0NTI0MjQ3NzMxYjRmYzVjOGZkZThmY2JmNzY3ZDY1IiwidGFnIjoiIn0%3D; expires=Tue, 08 Jul 2025 18:48:09 GMT; Max-Age=43200; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjFORzJsM1cycXprWmMzbEFLRlBHY2c9PSIsInZhbHVlIjoiUExuWlFuTFQwTThmb1FZRnQ5cnF0SFdLcGwxNmpqZlhIaDkrSTNlTUNINjcwbTRodTFhS1lFaHEwdmVJRUlnM1pmUzVRb ▶" 1 => "laravel_session=eyJpdiI6InZUQSs5djdVNXJ3SS9tUmVhT0IxUGc9PSIsInZhbHVlIjoiYlB2ZzlwSXVyNFpGdTFQUG9uUStXVTQ0clBJVkxrTlRBNVdPY01ReW1oM3JZU2h1WHNtMTl0aXVibzI3Mm4vYnVTdVRSUnpEdXBkV0UwRXB1WlBWTnB0RkpoRTV4UmNtL3NKakROcjNGbVNLZys2ZVFDZS90YXpQZkZKcjZkRTYiLCJtYWMiOiI2ZjI1MzU0ZGNiY2QyYTc1NGJhMzczYTM4MWVmZTQyZDU3MDNjMjZlOWQ1ODg1ZmJiODM2NTdmMGVlZDVhYjUzIiwidGFnIjoiIn0%3D; expires=Tue, 08 Jul 2025 18:48:09 GMT; Max-Age=43200; path=/; secure; httponly ◀laravel_session=eyJpdiI6InZUQSs5djdVNXJ3SS9tUmVhT0IxUGc9PSIsInZhbHVlIjoiYlB2ZzlwSXVyNFpGdTFQUG9uUStXVTQ0clBJVkxrTlRBNVdPY01ReW1oM3JZU2h1WHNtMTl0aXVibzI3Mm4vYnVT ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjFORzJsM1cycXprWmMzbEFLRlBHY2c9PSIsInZhbHVlIjoiUExuWlFuTFQwTThmb1FZRnQ5cnF0SFdLcGwxNmpqZlhIaDkrSTNlTUNINjcwbTRodTFhS1lFaHEwdmVJRUlnM1pmUzVRbjBRbk9TZkZNcm9JbzFJZUtFUXFudVVkUjFaQ3oxQ1JLb3o3U0pXMkJ2akFCYTlmcG51YnZlc3lTMEkiLCJtYWMiOiJjZDU3ZWFhODJkMzRlZTgzM2UwNGZmNWQ4YjE1ZDhiYjk0NTI0MjQ3NzMxYjRmYzVjOGZkZThmY2JmNzY3ZDY1IiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 18:48:09 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjFORzJsM1cycXprWmMzbEFLRlBHY2c9PSIsInZhbHVlIjoiUExuWlFuTFQwTThmb1FZRnQ5cnF0SFdLcGwxNmpqZlhIaDkrSTNlTUNINjcwbTRodTFhS1lFaHEwdmVJRUlnM1pmUzVRb ▶" 1 => "laravel_session=eyJpdiI6InZUQSs5djdVNXJ3SS9tUmVhT0IxUGc9PSIsInZhbHVlIjoiYlB2ZzlwSXVyNFpGdTFQUG9uUStXVTQ0clBJVkxrTlRBNVdPY01ReW1oM3JZU2h1WHNtMTl0aXVibzI3Mm4vYnVTdVRSUnpEdXBkV0UwRXB1WlBWTnB0RkpoRTV4UmNtL3NKakROcjNGbVNLZys2ZVFDZS90YXpQZkZKcjZkRTYiLCJtYWMiOiI2ZjI1MzU0ZGNiY2QyYTc1NGJhMzczYTM4MWVmZTQyZDU3MDNjMjZlOWQ1ODg1ZmJiODM2NTdmMGVlZDVhYjUzIiwidGFnIjoiIn0%3D; expires=Tue, 08-Jul-2025 18:48:09 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6InZUQSs5djdVNXJ3SS9tUmVhT0IxUGc9PSIsInZhbHVlIjoiYlB2ZzlwSXVyNFpGdTFQUG9uUStXVTQ0clBJVkxrTlRBNVdPY01ReW1oM3JZU2h1WHNtMTl0aXVibzI3Mm4vYnVT ▶" ] ]
0 of 0array:4 [▼ "_token" => "b2EliPmVtPRs50F8r0SzIspues6PduT55qrvgz29" "last_miki_page" => 33 "_previous" => array:1 [▶ "url" => "https://beta.inline-hockey.ch/statistiques-en/30" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]