Prénom | Olivier |
Nom | Gigon |
Tél privé | |
Tél professionnel | |
Tél portable | 079 692 61 29 |
o.gigon@bluewin.ch |
Ligue | Date | Début | Home | Away | Date | Équipes | Détails |
---|---|---|---|---|---|---|---|
SNR | 28.08.2025 | 20:00 | La Neuveville | Rossemaison | 28.08.2025 20:00 |
![]() ![]() |
Ligue | Date | Début | Home | Away | Date | Équipes | Rés. | Résultats | Tiers-temps | Détails |
---|---|---|---|---|---|---|---|---|---|---|
SNR | 18.06.2025 | 20:30 | Givisiez | Rossemaison | 18.06.2025 20:30 |
![]() ![]() |
||||
SNR | 18.05.2025 | 15:30 | Rossemaison | Bienne | 18.05.2025 15:30 |
![]() ![]() |
17:7 | 17:7 | 6:0 | 5:3 | 6:4 | |
SNR | 13.04.2025 | 11:00 | Rossemaison | Rolling Aventicum | 13.04.2025 11:00 |
![]() ![]() |
30:3 | 30:3 | 10:0 | 4:2 | 16:1 |
Nom | Prénom | Matchs | Goals | Assists | Points |
---|---|---|---|---|---|
KOULMEY | Sébastien | 2 | 11 | 8 | 19 |
MORILLO | Frédéric | 2 | 6 | 9 | 15 |
JACQUEMAI | Patrice | 2 | 6 | 3 | 9 |
CHETELAT | Michael | 2 | 5 | 3 | 8 |
GIGON | Olivier | 2 | 4 | 2 | 6 |
KOULMEY | Grégory | 1 | 4 | 1 | 5 |
BRON | Mathias | 1 | 4 | 1 | 5 |
WEISS | Emmanuel | 2 | 0 | 5 | 5 |
MATTIONI | Sébastien | 1 | 3 | 1 | 4 |
COMMENT | Gaël | 1 | 0 | 3 | 3 |
PETEUT | Michael | 1 | 0 | 3 | 3 |
BROQUET | Raphaël | 1 | 1 | 1 | 2 |
PERRIN | Lionel | 1 | 1 | 1 | 2 |
VUILLEUMIER | Joël | 1 | 1 | 1 | 2 |
MEMBREZ | Fabrice | 1 | 1 | 0 | 1 |
EHMANN | Yann | 1 | 0 | 1 | 1 |
FRIDEZ | Stéphane | 2 | 0 | 0 | 0 |
SCHORI | Marc | 2 | 0 | 0 | 0 |
Pour iOS et MAC :
S'abonner au calendrier
https://beta.inline-hockey.ch/games/exportiCal/t/1935
1 x Application (75.03%) | 490ms |
1 x Booting (24.97%) | 163ms |
# 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` = 'en'
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `miki_page_contents` where `alias` = 'team-it' and `page_id` is not null
Bindings |
|
Backtrace |
|
select * from `miki_page_contents` where `alias` = 'team-it' and `page_id` is not null order by `created_at` desc limit 1
Bindings |
|
Backtrace |
|
select * from `miki_pages` where `miki_pages`.`id` = 8 limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `miki_page_contents` where `miki_page_contents`.`page_id` = 8 and `miki_page_contents`.`page_id` is not null and `created_at` > '2018-11-22 15:15:19' and `language_code` = 'it'
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` = 8 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` = 'it' 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` = 'it'
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` = 'it'
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` = 'it' order by `created_at` desc limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'it'
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` = 'it'
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` = 'it' 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` = 'it'
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` = 'it'
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` = 'it' 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` = 'it'
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` = 'it' 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` = 'it' 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` = 'it'
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` = 'it' 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` = 'it' 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` = 'it' 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` = 'it'
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` = 'it' 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` = 'it' 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` = 'it'
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` = 'it' 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` = 'it' 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` = 'it' order by `created_at` desc limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'it'
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` = 'it' 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` = 'it' 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` = 'it' order by `created_at` desc limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'it'
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` = 'it' 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` = 'it' 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` = 'it' order by `created_at` desc limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'it'
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` = 'it' 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` = 'it' 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` = 'it' order by `created_at` desc limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'it'
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` = 'it' 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` = 'it' 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` = 'it' order by `created_at` desc limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'it'
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` = 'it' 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` = 'it' 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` = 'it' order by `created_at` desc limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'it'
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` = 'it' 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 count(*) as aggregate from `fsih_seasons` where `default` = ?
select * from `fsih_seasons` where `default` = ? limit 1
select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1
select `fsih_players`.* from `fsih_players` inner join `fsih_game_fsih_player` on `fsih_game_fsih_player`.`fsih_player_id` = `fsih_players`.`id` where `fsih_game_fsih_player`.`team_id` = ? and `fsih_game_fsih_player`.`role` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `fsih_players`.`licence` is not null and `fsih_players`.`deleted_at` is null group by `fsih_game_fsih_player`.`fsih_player_id`
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) 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` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `fsih_competition_types`.`code` in (?, ?, ?, ?)) and `fsih_stats`.`deleted_at` is null
select count(distinct `fsih_games`.`id`) as aggregate from `fsih_games` inner join `fsih_game_fsih_player` on `fsih_games`.`id` = `fsih_game_fsih_player`.`fsih_game_id` inner join `fsih_competitions` on `fsih_competitions`.`id` = `fsih_games`.`competition_id` inner join `fsih_competition_types` on `fsih_competition_types`.`id` = `fsih_competitions`.`competition_type_id` where `fsih_game_fsih_player`.`fsih_player_id` = ? and `fsih_games`.`season_id` = ? and (`fsih_games`.`team1_id` = ? or `fsih_games`.`team2_id` = ?) and `fsih_competition_types`.`code` in (?, ?, ?, ?)
select count(*) as aggregate from `fsih_leagues` where `fsih_leagues`.`id` = ?
select * from `fsih_leagues` where `fsih_leagues`.`id` = ? limit 1
select * from `languages` where `main_language` = ? limit 1
select count(*) as aggregate from `fsih_league_titles` where `fsih_league_titles`.`league_id` = ? and `fsih_league_titles`.`league_id` is not null and `language_code` = ?
select * from `fsih_league_titles` where `fsih_league_titles`.`league_id` = ? and `fsih_league_titles`.`league_id` is not null and `language_code` = ? limit 1
select * from `fsih_league_titles` where `fsih_league_titles`.`league_id` = ? and `fsih_league_titles`.`league_id` is not null and `language_code` = ? limit 1
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null and `position` = ?
select * from `fsih_clubs` where `fsih_clubs`.`id` = ? limit 1
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null
select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null limit 1
select count(*) as aggregate from `fsih_clubs` where `fsih_clubs`.`id` is null
select count(*) as aggregate from `fsih_clubs` where `fsih_clubs`.`id` is null
select * from `fsih_seasons`
select count(*) as aggregate from `people` where `people`.`id` = ? and `people`.`deleted_at` is null
select count(*) as aggregate from `people` where `people`.`id` = ? and `people`.`deleted_at` is null
select * from `people` where `people`.`id` = ? and `people`.`deleted_at` is null limit 1
select count(*) as aggregate from `people` where `people`.`id` = ? and `people`.`deleted_at` is null
select * from `people` where `people`.`id` = ? and `people`.`deleted_at` is null limit 1
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null and `position` = ?
select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null and `position` = ? limit 1
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null and `position` = ?
select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null and `position` = ? limit 1
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null and `position` = ?
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null and `position` = ?
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null and `position` = ?
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null and `position` = ?
select count(*) as aggregate from `fsih_games` where `team1_id` is not null and `team2_id` is not null and date_time >= NOW() and (`team1_id` = ? or `team2_id` = ?) and `season_id` = ?
select count(*) as aggregate from `fsih_games` where `team1_id` is not null and `team2_id` is not null and date_time >= NOW() and (`team1_id` = ? or `team2_id` = ?) and `season_id` = ?
select * from `fsih_games` where `team1_id` is not null and `team2_id` is not null and date_time >= NOW() and (`team1_id` = ? or `team2_id` = ?) and `season_id` = ? order by `date_time` asc
select * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is null
select * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` in (?, ?) and `fsih_stats`.`deleted_at` is null
select * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is null
select * from `fsih_competitions` where `fsih_competitions`.`id` = ? limit 1
select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1
select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1
select * from `fsih_leagues` where `fsih_leagues`.`id` = ? limit 1
select * from `fsih_clubs` where `fsih_clubs`.`id` = ? limit 1
select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null
select * from `fsih_clubs` where `fsih_clubs`.`id` = ? limit 1
select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null
select count(*) as aggregate from `fsih_games` where `team1_id` is not null and `team2_id` is not null and date_time < NOW() and (`team1_id` = ? or `team2_id` = ?) and `season_id` = ?
select count(*) as aggregate from `fsih_games` where `team1_id` is not null and `team2_id` is not null and date_time < NOW() and (`team1_id` = ? or `team2_id` = ?) and `season_id` = ?
select * from `fsih_games` where `team1_id` is not null and `team2_id` is not null and date_time < NOW() and (`team1_id` = ? or `team2_id` = ?) and `season_id` = ? order by `date_time` desc
select * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is null
select * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` in (?, ?) and `fsih_stats`.`deleted_at` is null
select * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is null
select * from `fsih_competitions` where `fsih_competitions`.`id` = ? limit 1
select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1
select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1
select * from `fsih_leagues` where `fsih_leagues`.`id` = ? limit 1
select * from `fsih_clubs` where `fsih_clubs`.`id` = ? limit 1
select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null
select * from `fsih_clubs` where `fsih_clubs`.`id` = ? limit 1
select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null
select * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is null
select * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` in (?, ?) and `fsih_stats`.`deleted_at` is null
select * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is null
select * from `fsih_competitions` where `fsih_competitions`.`id` = ? limit 1
select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1
select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1
select * from `fsih_leagues` where `fsih_leagues`.`id` = ? limit 1
select * from `fsih_clubs` where `fsih_clubs`.`id` = ? limit 1
select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null
select * from `fsih_clubs` where `fsih_clubs`.`id` = ? limit 1
select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null
select * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is null
select * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` in (?, ?) and `fsih_stats`.`deleted_at` is null
select * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is null
select * from `fsih_competitions` where `fsih_competitions`.`id` = ? limit 1
select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1
select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1
select * from `fsih_leagues` where `fsih_leagues`.`id` = ? limit 1
select * from `fsih_clubs` where `fsih_clubs`.`id` = ? limit 1
select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null
select * from `fsih_clubs` where `fsih_clubs`.`id` = ? limit 1
select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null
select * from `fsih_players` where `fsih_players`.`id` = ? and `fsih_players`.`deleted_at` is null limit 1
select * from `people` where `people`.`id` = ? and `people`.`deleted_at` is null limit 1
... 205 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:16 [▼ "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "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:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sat, 28 Jun 2025 11:41:58 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Im9ybDNtb1ZZQ1dkejVGVjBMTzdydkE9PSIsInZhbHVlIjoiaVEzMURiUGlOZjk1SkVXajdqRXhzaG5lZHROL1QyOGZOMEZ0dDhLcDdEMTlNdGpOVmNKZ1RLQW1aMzFpQlVYemlQN0VTUlNSNTRXNzQzb1pWT25aelZtdFIzejEzU1FwYU9ndTN6K3g1MEQ1UTBma09pRXVCZDFiSml6Rzd3ZHUiLCJtYWMiOiIwN2I5YTk4YzY1Njk1ZjIyMzIyNmMwODhlNTMyOGZmY2Q4MmEyNzRjZTYzY2E2MmRiYzQ3NWIzYmMxMGQ0M2NiIiwidGFnIjoiIn0%3D; expires=Sat, 28 Jun 2025 23:41:58 GMT; Max-Age=43200; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Im9ybDNtb1ZZQ1dkejVGVjBMTzdydkE9PSIsInZhbHVlIjoiaVEzMURiUGlOZjk1SkVXajdqRXhzaG5lZHROL1QyOGZOMEZ0dDhLcDdEMTlNdGpOVmNKZ1RLQW1aMzFpQlVYemlQN0VTU ▶" 1 => "laravel_session=eyJpdiI6Ijk0eVhLa0dwOVFUdWtnL3hZWjVOUEE9PSIsInZhbHVlIjoidWR0VVgwRmxWa1ZOMEo5S3lqT3JZSUZuVC9XUXpKbytTT21YYkVLR05TZ25yNCtKUTRXeWVOUHV4aDRBcUZ4RzZxcTExVVhvT3ZhdHZNVWJNa0NsR3pKWk1EVTNhWmRYQnlFZ2ViZEhkOVFyUE9uYUV2ODdjZS9mMytaMnJrRkUiLCJtYWMiOiJjZTQxOTVhNTAyYjQ1MmRkMjFkY2ViODRhYWU4OTlkNDE0YThkOGZkMDM5MmZhNmZlZjgwNjQ2NDAzYTU1MTBkIiwidGFnIjoiIn0%3D; expires=Sat, 28 Jun 2025 23:41:58 GMT; Max-Age=43200; path=/; secure; httponly ◀laravel_session=eyJpdiI6Ijk0eVhLa0dwOVFUdWtnL3hZWjVOUEE9PSIsInZhbHVlIjoidWR0VVgwRmxWa1ZOMEo5S3lqT3JZSUZuVC9XUXpKbytTT21YYkVLR05TZ25yNCtKUTRXeWVOUHV4aDRBcUZ4RzZx ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Im9ybDNtb1ZZQ1dkejVGVjBMTzdydkE9PSIsInZhbHVlIjoiaVEzMURiUGlOZjk1SkVXajdqRXhzaG5lZHROL1QyOGZOMEZ0dDhLcDdEMTlNdGpOVmNKZ1RLQW1aMzFpQlVYemlQN0VTUlNSNTRXNzQzb1pWT25aelZtdFIzejEzU1FwYU9ndTN6K3g1MEQ1UTBma09pRXVCZDFiSml6Rzd3ZHUiLCJtYWMiOiIwN2I5YTk4YzY1Njk1ZjIyMzIyNmMwODhlNTMyOGZmY2Q4MmEyNzRjZTYzY2E2MmRiYzQ3NWIzYmMxMGQ0M2NiIiwidGFnIjoiIn0%3D; expires=Sat, 28-Jun-2025 23:41:58 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Im9ybDNtb1ZZQ1dkejVGVjBMTzdydkE9PSIsInZhbHVlIjoiaVEzMURiUGlOZjk1SkVXajdqRXhzaG5lZHROL1QyOGZOMEZ0dDhLcDdEMTlNdGpOVmNKZ1RLQW1aMzFpQlVYemlQN0VTU ▶" 1 => "laravel_session=eyJpdiI6Ijk0eVhLa0dwOVFUdWtnL3hZWjVOUEE9PSIsInZhbHVlIjoidWR0VVgwRmxWa1ZOMEo5S3lqT3JZSUZuVC9XUXpKbytTT21YYkVLR05TZ25yNCtKUTRXeWVOUHV4aDRBcUZ4RzZxcTExVVhvT3ZhdHZNVWJNa0NsR3pKWk1EVTNhWmRYQnlFZ2ViZEhkOVFyUE9uYUV2ODdjZS9mMytaMnJrRkUiLCJtYWMiOiJjZTQxOTVhNTAyYjQ1MmRkMjFkY2ViODRhYWU4OTlkNDE0YThkOGZkMDM5MmZhNmZlZjgwNjQ2NDAzYTU1MTBkIiwidGFnIjoiIn0%3D; expires=Sat, 28-Jun-2025 23:41:58 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6Ijk0eVhLa0dwOVFUdWtnL3hZWjVOUEE9PSIsInZhbHVlIjoidWR0VVgwRmxWa1ZOMEo5S3lqT3JZSUZuVC9XUXpKbytTT21YYkVLR05TZ25yNCtKUTRXeWVOUHV4aDRBcUZ4RzZx ▶" ] ]
0 of 0array:4 [▼ "_token" => "SUyDex2RztPkLwmUf06Gw1MsdRqsLpXmMSzLYGt3" "last_miki_page" => 8 "_previous" => array:1 [▶ "url" => "https://beta.inline-hockey.ch/team-it/1935" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]