Givisiez
| 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 | 16.05.2025 | 19:45 | Rolling Aventicum | Givisiez | 16.05.2025 19:45 |
|
4:13 | 4:13 | 3:3 | 0:4 | 1:6 | |
| SNR | 10.04.2025 | 20:30 | Givisiez | La Neuveville | 10.04.2025 20:30 |
|
13:0 | 13:0 | 3:0 | 5:0 | 5:0 |
| Nom | Prénom | Matchs | Goals | Assists | Points |
|---|---|---|---|---|---|
| BAERISWYL | Alexandre | 2 | 0 | 6 | 6 |
| DESPONT | Pascal | 2 | 3 | 2 | 5 |
| SCIBOZ | Thierry | 1 | 2 | 2 | 4 |
| OBERSON | Gilles | 2 | 2 | 2 | 4 |
| ISELI | Sylvain | 1 | 2 | 2 | 4 |
| ARRIGHI | Michel | 1 | 3 | 0 | 3 |
| MENETREY | Alain | 1 | 2 | 1 | 3 |
| FAVRE | Nicolas | 1 | 1 | 2 | 3 |
| PERROUD | David | 1 | 1 | 2 | 3 |
| DONZE | Jonathan | 1 | 2 | 0 | 2 |
| SPRECHER | Patrick | 2 | 2 | 0 | 2 |
| BUNTSCHU | Marc | 1 | 2 | 0 | 2 |
| RIGOLET | Laurent | 2 | 1 | 1 | 2 |
| CHUARD | Patrick | 2 | 1 | 1 | 2 |
| DAFFLON | Willy | 2 | 0 | 2 | 2 |
| YERLY | Damien | 1 | 1 | 0 | 1 |
| NEUHAUS | Stéphane | 1 | 1 | 0 | 1 |
| BERDAT | Michaël | 2 | 0 | 0 | 0 |
| METZGER | Cédric | 1 | 0 | 0 | 0 |
| MINACCI | Didier | 1 | 0 | 0 | 0 |
Pour iOS et MAC :
S'abonner au calendrier
Pour Windows et Android :
Ajouter le calendrier dans votre logiciel préféré en entrant le lien suivant (Explications pour Google Agenda) :
https://beta.inline-hockey.ch/games/exportiCal/t/2008
| 1 x Application (72.1%) | 535ms |
| 1 x Booting (27.9%) | 207ms |
# 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-en' and `page_id` is not null| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `alias` = 'team-en' 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` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_theme_templates` where `miki_theme_templates`.`id` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_themes` where `miki_themes`.`id` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `languages`| Backtrace |
|
select `user_groups`.*, `has_user_groups`.`has_user_group_id` as `pivot_has_user_group_id`, `has_user_groups`.`user_group_id` as `pivot_user_group_id`, `has_user_groups`.`has_user_group_type` as `pivot_has_user_group_type` from `user_groups` inner join `has_user_groups` on `user_groups`.`id` = `has_user_groups`.`user_group_id` where `has_user_groups`.`has_user_group_id` = 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` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `languages` where `main_language` = 1 limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_boxes` where `name` = 'main_sponsor_left'| Bindings |
|
| Backtrace |
|
select * from `miki_boxes` where `name` = 'main_sponsor_left' limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_box_contents` where `miki_box_contents`.`box_id` = 15 and `miki_box_contents`.`box_id` is not null and `language_code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_box_contents` where `miki_box_contents`.`box_id` = 15 and `miki_box_contents`.`box_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_boxes` where `name` = 'main_sponsor_right'| Bindings |
|
| Backtrace |
|
select * from `miki_boxes` where `name` = 'main_sponsor_right' limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_box_contents` where `miki_box_contents`.`box_id` = 16 and `miki_box_contents`.`box_id` is not null and `language_code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_box_contents` where `miki_box_contents`.`box_id` = 16 and `miki_box_contents`.`box_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `languages`| Backtrace |
|
select * from `miki_places` where `category_id` = 24 and `state` = 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 7 and `pictures`.`has_images_id` is not null| Bindings |
|
| Backtrace |
|
select * from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 7 and `pictures`.`has_images_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 9 and `pictures`.`has_images_id` is not null| Bindings |
|
| Backtrace |
|
select * from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 9 and `pictures`.`has_images_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 14 and `pictures`.`has_images_id` is not null| Bindings |
|
| Backtrace |
|
select * from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 14 and `pictures`.`has_images_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_places` where `category_id` = 22 and `state` = 1| Bindings |
|
| Backtrace |
|
select * from `miki_places` where `category_id` = 23 and `state` = 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 1 and `pictures`.`has_images_id` is not null| Bindings |
|
| Backtrace |
|
select * from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 1 and `pictures`.`has_images_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 2 and `pictures`.`has_images_id` is not null| Bindings |
|
| Backtrace |
|
select * from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 2 and `pictures`.`has_images_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 11 and `pictures`.`has_images_id` is not null| Bindings |
|
| Backtrace |
|
select * from `pictures` where `pictures`.`has_images_type` = 'App\\MikiPlace' and `pictures`.`has_images_id` = 11 and `pictures`.`has_images_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_boxes` where `name` = 'sponsors-top'| Bindings |
|
| Backtrace |
|
select * from `miki_boxes` where `name` = 'sponsors-top' limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_box_contents` where `miki_box_contents`.`box_id` = 11 and `miki_box_contents`.`box_id` is not null and `language_code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_box_contents` where `miki_box_contents`.`box_id` = 11 and `miki_box_contents`.`box_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `state` = 1 and `menu` = 1 and `parent_id` is null order by `position` asc| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `parent_id` = 3 and `menu` = '1' and `state` > 0| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 3 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `languages` where `main_language` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 3 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `parent_id` = 32 and `menu` = '1' and `state` > 0| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 32 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = 'calendar'| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `name` = 'calendar' limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 1 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 32 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `parent_id` = 32 and `state` > 0 and `menu` = '1' order by `position` asc| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 1 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 1 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `parent_id` = 1 and `menu` = '1' and `state` > 0| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `parent_id` = 1 and `state` > 0 and `menu` = '1' order by `position` asc| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 48 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = 'competitions-list'| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `name` = 'competitions-list' limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 40 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 48 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 49 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = 'competitions-list'| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `name` = 'competitions-list' limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 40 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 49 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 50 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = 'competitions-list'| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `name` = 'competitions-list' limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 40 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 50 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 51 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = 'competitions-list'| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `name` = 'competitions-list' limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 40 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 51 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 52 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = 'competitions-list'| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `name` = 'competitions-list' limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 40 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 52 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 53 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = 'competitions-list'| Bindings |
|
| Backtrace |
|
select * from `miki_pages` where `name` = 'competitions-list' limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 40 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 53 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `languages` where `code` = 'en'| Bindings |
|
| Backtrace |
|
select * from `miki_page_contents` where `miki_page_contents`.`page_id` = 54 and `miki_page_contents`.`page_id` is not null and `language_code` = 'en' order by `created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `name` = ?select * from `miki_pages` where `name` = ? limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_pages` where `parent_id` = ? and `state` > ? and `menu` = ? order by `position` ascselect count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select count(*) as aggregate from `languages` where `code` = ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `miki_pages` where `parent_id` = ? and `menu` = ? and `state` > ?select * from `miki_page_contents` where `miki_page_contents`.`page_id` = ? and `miki_page_contents`.`page_id` is not null and `language_code` = ? order by `created_at` desc limit 1select count(*) as aggregate from `fsih_seasons` where `default` = ?select * from `fsih_seasons` where `default` = ? limit 1select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1select `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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 nullselect count(*) as aggregate from `fsih_stats` where `fsih_stats`.`player_id` = ? and `fsih_stats`.`player_id` is not null and `type` = ? and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and `season_id` = ?) and exists (select * from `fsih_games` where `fsih_stats`.`game_id` = `fsih_games`.`id` and (`team1_id` = ? or `team2_id` = ?)) and exists (select * from `fsih_games` 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 nullselect 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 1select * from `languages` where `main_language` = ? limit 1select 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 1select * from `fsih_league_titles` where `fsih_league_titles`.`league_id` = ? and `fsih_league_titles`.`league_id` is not null and `language_code` = ? limit 1select 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 1select count(*) as aggregate from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not nullselect * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not null limit 1select count(*) as aggregate from `fsih_clubs` where `fsih_clubs`.`id` is nullselect count(*) as aggregate from `fsih_clubs` where `fsih_clubs`.`id` is nullselect * from `fsih_seasons`select count(*) as aggregate from `people` where `people`.`id` = ? and `people`.`deleted_at` is nullselect count(*) as aggregate from `people` where `people`.`id` = ? and `people`.`deleted_at` is nullselect * from `people` where `people`.`id` = ? and `people`.`deleted_at` is null limit 1select count(*) as aggregate from `people` where `people`.`id` = ? and `people`.`deleted_at` is nullselect * from `people` where `people`.`id` = ? and `people`.`deleted_at` is null limit 1select 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 1select 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 1select 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` ascselect * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is nullselect * 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 nullselect * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is nullselect * from `fsih_competitions` where `fsih_competitions`.`id` = ? limit 1select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1select * from `fsih_leagues` where `fsih_leagues`.`id` = ? limit 1select * from `fsih_clubs` where `fsih_clubs`.`id` = ? limit 1select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not nullselect * from `fsih_clubs` where `fsih_clubs`.`id` = ? limit 1select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not nullselect 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` descselect * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is nullselect * 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 nullselect * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is nullselect * from `fsih_competitions` where `fsih_competitions`.`id` = ? limit 1select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1select * from `fsih_leagues` where `fsih_leagues`.`id` = ? limit 1select * from `fsih_clubs` where `fsih_clubs`.`id` = ? limit 1select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not nullselect * from `fsih_clubs` where `fsih_clubs`.`id` = ? limit 1select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not nullselect * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is nullselect * 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 nullselect * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is nullselect * from `fsih_competitions` where `fsih_competitions`.`id` = ? limit 1select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1select * from `fsih_leagues` where `fsih_leagues`.`id` = ? limit 1select * from `fsih_clubs` where `fsih_clubs`.`id` = ? limit 1select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not nullselect * from `fsih_clubs` where `fsih_clubs`.`id` = ? limit 1select * from `pictures` where `pictures`.`has_images_type` = ? and `pictures`.`has_images_id` = ? and `pictures`.`has_images_id` is not nullselect * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is nullselect * 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 nullselect * from `fsih_stats` where `fsih_stats`.`game_id` = ? and `fsih_stats`.`game_id` is not null and `type` = ? and `fsih_stats`.`deleted_at` is nullselect * from `fsih_competitions` where `fsih_competitions`.`id` = ? limit 1select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1select * from `fsih_teams` where `fsih_teams`.`id` = ? limit 1select * from `fsih_leagues` where `fsih_leagues`.`id` = ? limit 1... 229 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 => "Tue, 22 Jul 2025 11:39:15 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InBQRlBkbUhpV1ZuMjh5MTZGZEl4cmc9PSIsInZhbHVlIjoieFh3ZnA1NFg1WWdkSEx2R21lSTJoSE5COGlteTZMc2RVb0pTeERQa0R1bGswTEM5TVZGMFVWSmZwNTExYStxYW5OOXFXN0lnN20xYlFwVjRSR3BFcW5RaTBBa1hueUFQTm43WW41UXB6VEFiYWhIR05jaXF5NWcxdmtIRDNtNGEiLCJtYWMiOiI1ZWFiMDYzM2Y2OTIzOTQ0ODNmMTU1MDBkNjBiYzNiNzRjYzA4ZGFiNmYzNzA1ZTFhNjA4YzVmY2IwZjFlYWJlIiwidGFnIjoiIn0%3D; expires=Tue, 22 Jul 2025 23:39:15 GMT; Max-Age=43200; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InBQRlBkbUhpV1ZuMjh5MTZGZEl4cmc9PSIsInZhbHVlIjoieFh3ZnA1NFg1WWdkSEx2R21lSTJoSE5COGlteTZMc2RVb0pTeERQa0R1bGswTEM5TVZGMFVWSmZwNTExYStxYW5OOXFXN ▶" 1 => "laravel_session=eyJpdiI6IjR3N3FiSS9NQ1I5eUpCSWdBRnQxdFE9PSIsInZhbHVlIjoiSE9Gb2hYVmNQMkpTanBYc1NaMzF4WHRDeFpYVVZ1dDBmZjRrbXRQZjc0dlNHbVROanE0Z1htRUZjUTN2VHQ0dEZ3V0l6c1lOZ0svcmhLNE8vRWY3WGdFbTNlZUpZQ3U5YmF6ck9jeStyNEw0S1hZWWYzemJQWHB2V3R3ZUNkS1YiLCJtYWMiOiI1OWNkYTQzOWEzMDgxN2ZjZTliZjJlODE2NDNhMzk2NGRjOGVjZjQ1M2JjNGFmZjU2MjNhMjQyMDQ4YzI1OWRiIiwidGFnIjoiIn0%3D; expires=Tue, 22 Jul 2025 23:39:15 GMT; Max-Age=43200; path=/; secure; httponly ◀laravel_session=eyJpdiI6IjR3N3FiSS9NQ1I5eUpCSWdBRnQxdFE9PSIsInZhbHVlIjoiSE9Gb2hYVmNQMkpTanBYc1NaMzF4WHRDeFpYVVZ1dDBmZjRrbXRQZjc0dlNHbVROanE0Z1htRUZjUTN2VHQ0dEZ3 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InBQRlBkbUhpV1ZuMjh5MTZGZEl4cmc9PSIsInZhbHVlIjoieFh3ZnA1NFg1WWdkSEx2R21lSTJoSE5COGlteTZMc2RVb0pTeERQa0R1bGswTEM5TVZGMFVWSmZwNTExYStxYW5OOXFXN0lnN20xYlFwVjRSR3BFcW5RaTBBa1hueUFQTm43WW41UXB6VEFiYWhIR05jaXF5NWcxdmtIRDNtNGEiLCJtYWMiOiI1ZWFiMDYzM2Y2OTIzOTQ0ODNmMTU1MDBkNjBiYzNiNzRjYzA4ZGFiNmYzNzA1ZTFhNjA4YzVmY2IwZjFlYWJlIiwidGFnIjoiIn0%3D; expires=Tue, 22-Jul-2025 23:39:15 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InBQRlBkbUhpV1ZuMjh5MTZGZEl4cmc9PSIsInZhbHVlIjoieFh3ZnA1NFg1WWdkSEx2R21lSTJoSE5COGlteTZMc2RVb0pTeERQa0R1bGswTEM5TVZGMFVWSmZwNTExYStxYW5OOXFXN ▶" 1 => "laravel_session=eyJpdiI6IjR3N3FiSS9NQ1I5eUpCSWdBRnQxdFE9PSIsInZhbHVlIjoiSE9Gb2hYVmNQMkpTanBYc1NaMzF4WHRDeFpYVVZ1dDBmZjRrbXRQZjc0dlNHbVROanE0Z1htRUZjUTN2VHQ0dEZ3V0l6c1lOZ0svcmhLNE8vRWY3WGdFbTNlZUpZQ3U5YmF6ck9jeStyNEw0S1hZWWYzemJQWHB2V3R3ZUNkS1YiLCJtYWMiOiI1OWNkYTQzOWEzMDgxN2ZjZTliZjJlODE2NDNhMzk2NGRjOGVjZjQ1M2JjNGFmZjU2MjNhMjQyMDQ4YzI1OWRiIiwidGFnIjoiIn0%3D; expires=Tue, 22-Jul-2025 23:39:15 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6IjR3N3FiSS9NQ1I5eUpCSWdBRnQxdFE9PSIsInZhbHVlIjoiSE9Gb2hYVmNQMkpTanBYc1NaMzF4WHRDeFpYVVZ1dDBmZjRrbXRQZjc0dlNHbVROanE0Z1htRUZjUTN2VHQ0dEZ3 ▶" ] ]
0 of 0array:4 [▼ "_token" => "lO6bWDhd2VERqik3tRsLSGrUfWQ7WUqLvzK6bHOG" "last_miki_page" => 8 "_previous" => array:1 [▶ "url" => "https://beta.inline-hockey.ch/team-en/2008" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]