string(1276) " SELECT IF(1, 0, 1) as isRestrictedByCountry, gs.*, finishGameList.logo_path as provider_logo_path, finishGameList.logo_mini_path as provider_logo_mini_path FROM (SELECT game_settings.*, gpm.logo_path, gpm.logo_mini_path FROM game_settings LEFT JOIN `game_providers_menu` gpm ON gpm.provider = game_settings.provider AND gpm.id IN ( SELECT IF (gpmcdg.id, gpmcdg.id, game_providers_menu.id) as id FROM game_providers_menu LEFT JOIN game_providers_menu gpmcdg ON `game_providers_menu`.`provider` = gpmcdg.provider AND gpmcdg.domain_group_id = 34 WHERE game_providers_menu.domain_group_id IS NULL ) WHERE g_view=1 AND (gpm.is_showed = 1 OR gpm.is_showed IS NULL) AND device IN ('any','pc') ORDER BY popular DESC LIMIT 116 OFFSET 0) as finishGameList LEFT JOIN game_settings gs ON gs.id = ( SELECT gs2.id FROM game_settings gs2 LEFT JOIN `game_hosters` as gh2 ON gh2.id = gs2.game_hoster_id WHERE finishGameList.g_name = gs2.g_name AND finishGameList.game_provider_id = gs2.game_provider_id AND gs2.g_view = 1 ORDER BY gh2.show_slots_priority DESC LIMIT 1 ) "