Sottern Lake
General data
- Water type: Natural lake
- Progression: Nykopingsan River -> Baltic sea -> Atlantic Ocean -> Planet Earth
- Climates: Temperate
- Continents: Europe
- Countries: Sweden
Sottern is a lake in Hallsberg municipality and Örebro municipality in Närke and is part of the Nyköpingsån\'s main catchment area. The lake is a maximum of 16 m deep, has an area of 27.8 square km and is 71 m above sea level. The lake is drained by the stream Nyköpingsån. During trial fishing, a large number of fish species have been caught, including perch, birch and bream. Sottern is the largest among lakes that are only located within Närke.
The more catches you post, the higher your chances of winning this amazing prize.
Every catch shared between May and November 2025 is automatically entered into the prize draw.
Only one rule: Make sure to tag both the fish species and the body of water!
| 1 x Application (79.47%) | 83.85ms |
| 1 x Booting (20.52%) | 21.65ms |
select * from `sessions` where `id` = 'zkf68V2GBGO9Wyhz6RWirE4MZsWYO56vvoxZNQl8' limit 1| Bindings |
|
| Backtrace |
|
select * from `waters` where `type` = 'Natural lake' and `alias` = 'sottern-lake' and `published` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (3236) and `translations`.`translatable_type` = 'App\\Models\\Water'| Bindings |
|
| Backtrace |
|
select * from `waters` where `waters`.`parent_id` in (3236)| Backtrace |
|
select `countries`.*, `country_water`.`water_id` as `pivot_water_id`, `country_water`.`country_id` as `pivot_country_id` from `countries` inner join `country_water` on `countries`.`id` = `country_water`.`country_id` where `country_water`.`water_id` in (3236)| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (217) and `translations`.`translatable_type` = 'App\\Models\\Country'| Bindings |
|
| Backtrace |
|
select `continents`.*, `continent_country`.`country_id` as `pivot_country_id`, `continent_country`.`continent_id` as `pivot_continent_id` from `continents` inner join `continent_country` on `continents`.`id` = `continent_country`.`continent_id` where `continent_country`.`country_id` in (217)| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (2) and `translations`.`translatable_type` = 'App\\Models\\Continent'| Bindings |
|
| Backtrace |
|
select `fish`.*, `water_fish`.`water_id` as `pivot_water_id`, `water_fish`.`fish_id` as `pivot_fish_id` from `fish` inner join `water_fish` on `fish`.`id` = `water_fish`.`fish_id` where `water_fish`.`water_id` in (3236)| Backtrace |
|
with recursive `laravel_cte` as ((select `waters`.*, -1 as `depth`, cast(`id` as char(65535)) as `path` from `waters` where `waters`.`id` = 3232) union all (select `waters`.*, `depth` - 1 as `depth`, concat(`path`, '.', `waters`.`id`) from `waters` inner join `laravel_cte` on `laravel_cte`.`parent_id` = `waters`.`id`)) select * from `laravel_cte`| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (39, 41, 370, 3232) and `translations`.`translatable_type` = 'App\\Models\\Water'| Bindings |
|
| Backtrace |
|
select `climates`.*, `climate_water`.`water_id` as `pivot_water_id`, `climate_water`.`climate_id` as `pivot_climate_id` from `climates` inner join `climate_water` on `climates`.`id` = `climate_water`.`climate_id` where `climate_water`.`water_id` = 3236| Bindings |
|
| Backtrace |
|
select * from `translations` where `translations`.`translatable_type` = 'App\\Models\\Climate' and `translations`.`translatable_id` = 3 and `translations`.`translatable_id` is not null and `lang` = 'en' limit 1| Bindings |
|
| Backtrace |
|
select `continents`.*, `continent_water`.`water_id` as `pivot_water_id`, `continent_water`.`continent_id` as `pivot_continent_id` from `continents` inner join `continent_water` on `continents`.`id` = `continent_water`.`continent_id` where `continent_water`.`water_id` = 3236| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (2) and `translations`.`translatable_type` = 'App\\Models\\Continent'| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `tags` where `tags`.`context_id` = 3236 and `tags`.`context_id` is not null and `type` = 'water'| Bindings |
|
| Backtrace |
|
select * from `tags` where `tags`.`context_id` = 3236 and `tags`.`context_id` is not null and `type` = 'water' order by `created_at` desc limit 100| Bindings |
|
| Backtrace |
|
select * from `sessions` where `id` = 'zkf68V2GBGO9Wyhz6RWirE4MZsWYO56vvoxZNQl8' limit 1| Bindings |
|
| Backtrace |
|
insert into `sessions` (`payload`, `last_activity`, `user_id`, `ip_address`, `user_agent`, `id`) values ('YTozOntzOjY6Il90b2tlbiI7czo0MDoiTHBvUEpkU2tWRGUwZ2hlU1ZrTjdjZmJvcExQdXhXNVJqRm5tNVFVeCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTg6Imh0dHBzOi8vZGV2LnRhZ215ZmlzaC5jb20vd2F0ZXJzL25hdHVyYWwtbGFrZS9zb3R0ZXJuLWxha2UiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1748429910, null, '172.18.0.5', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'zkf68V2GBGO9Wyhz6RWirE4MZsWYO56vvoxZNQl8')| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:35 [▼ "x-real-ip" => array:1 [▶ 0 => "172.69.59.9" ] "x-forwarded-server" => array:1 [▶ 0 => "traefik" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-forwarded-port" => array:1 [▶ 0 => "443" ] "x-forwarded-host" => array:1 [▶ 0 => "dev.tagmyfish.com" ] "x-forwarded-for" => array:1 [▶ 0 => "172.69.59.9" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "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"" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cf-visitor" => array:1 [▶ 0 => "{"scheme":"https"}" ] "cf-timezone" => array:1 [▶ 0 => "America/New_York" ] "cf-region-code" => array:1 [▶ 0 => "OH" ] "cf-region" => array:1 [▶ 0 => "Ohio" ] "cf-ray" => array:1 [▶ 0 => "946d3cbe8d8cdd00-ORD" ] "cf-postal-code" => array:1 [▶ 0 => "43215" ] "cf-metro-code" => array:1 [▶ 0 => "535" ] "cf-iplongitude" => array:1 [▶ 0 => "-83.00610" ] "cf-iplatitude" => array:1 [▶ 0 => "39.96250" ] "cf-ipcountry" => array:1 [▶ 0 => "US" ] "cf-ipcontinent" => array:1 [▶ 0 => "NA" ] "cf-ipcity" => array:1 [▶ 0 => "Columbus" ] "cf-connecting-ip" => array:1 [▶ 0 => "18.224.200.148" ] "cdn-loop" => array:1 [▶ 0 => "cloudflare; loops=1" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "accept-encoding" => array:1 [▶ 0 => "gzip, br" ] "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)" ] "host" => array:1 [▶ 0 => "dev.tagmyfish.com" ] ]
[]
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 => "Wed, 28 May 2025 10:58:30 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkxnY0xSbzZqNXZ4YlF6cmI0ZjFRcWc9PSIsInZhbHVlIjoiMExyZmorckJXWWJ6dlQzMklXdTRKbE9iZWNXRHNzQ3ZwUzIybS9lSGllc3hPcWFzMmVkMCswYmpaQ0UxUDN0dXFFNUtBUlVtUTgrcytJcU9RT05nTkJadXpUK1NlT2dUMVJKUHpMTGVXY21ZQkxyU1IrVnAvVDFQQm9lbDAyOFgiLCJtYWMiOiIwMDEzM2MzNGI5NWFmM2JlZGYwMGYwZWUyNWM5ODNjNzhlMDg3ZjkxZGU2ZDUyYzc1NDE0OTM4YzM0M2NhNzljIiwidGFnIjoiIn0%3D; expires=Wed, 28 May 2025 12:58:30 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkxnY0xSbzZqNXZ4YlF6cmI0ZjFRcWc9PSIsInZhbHVlIjoiMExyZmorckJXWWJ6dlQzMklXdTRKbE9iZWNXRHNzQ3ZwUzIybS9lSGllc3hPcWFzMmVkMCswYmpaQ0UxUDN0dXFFNUtBU ▶" 1 => "tagmyfish_session=eyJpdiI6IjNaVG5ZRlVncDNtZC80TTNsYUdNZFE9PSIsInZhbHVlIjoiY0JodkpmSTA4Y3gxTjlBR1VycXJITi9Cc3hzOUZPQmM4ZGFHK1RRKzNDMmxSZHA3RnRza1p6dWFUeUxaV053RTVWcGlBZkRVZUU1MnloSU4wNzIxTUNObmF2cWhzaVJkWm5pTFJxbFUxMU5ROHZGVHZJbklRdVB0L2VHOGlRaUMiLCJtYWMiOiJhODUyMmE4YzZlMDFkZTQ3ZmNhY2MxYmRjMzM3ZDRlY2M1ZTM4NWQ0OGJkNzkyODkwOWZlODViYjVkNTg3MzFjIiwidGFnIjoiIn0%3D; expires=Wed, 28 May 2025 12:58:30 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀tagmyfish_session=eyJpdiI6IjNaVG5ZRlVncDNtZC80TTNsYUdNZFE9PSIsInZhbHVlIjoiY0JodkpmSTA4Y3gxTjlBR1VycXJITi9Cc3hzOUZPQmM4ZGFHK1RRKzNDMmxSZHA3RnRza1p6dWFUeUxaV053RT ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkxnY0xSbzZqNXZ4YlF6cmI0ZjFRcWc9PSIsInZhbHVlIjoiMExyZmorckJXWWJ6dlQzMklXdTRKbE9iZWNXRHNzQ3ZwUzIybS9lSGllc3hPcWFzMmVkMCswYmpaQ0UxUDN0dXFFNUtBUlVtUTgrcytJcU9RT05nTkJadXpUK1NlT2dUMVJKUHpMTGVXY21ZQkxyU1IrVnAvVDFQQm9lbDAyOFgiLCJtYWMiOiIwMDEzM2MzNGI5NWFmM2JlZGYwMGYwZWUyNWM5ODNjNzhlMDg3ZjkxZGU2ZDUyYzc1NDE0OTM4YzM0M2NhNzljIiwidGFnIjoiIn0%3D; expires=Wed, 28-May-2025 12:58:30 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IkxnY0xSbzZqNXZ4YlF6cmI0ZjFRcWc9PSIsInZhbHVlIjoiMExyZmorckJXWWJ6dlQzMklXdTRKbE9iZWNXRHNzQ3ZwUzIybS9lSGllc3hPcWFzMmVkMCswYmpaQ0UxUDN0dXFFNUtBU ▶" 1 => "tagmyfish_session=eyJpdiI6IjNaVG5ZRlVncDNtZC80TTNsYUdNZFE9PSIsInZhbHVlIjoiY0JodkpmSTA4Y3gxTjlBR1VycXJITi9Cc3hzOUZPQmM4ZGFHK1RRKzNDMmxSZHA3RnRza1p6dWFUeUxaV053RTVWcGlBZkRVZUU1MnloSU4wNzIxTUNObmF2cWhzaVJkWm5pTFJxbFUxMU5ROHZGVHZJbklRdVB0L2VHOGlRaUMiLCJtYWMiOiJhODUyMmE4YzZlMDFkZTQ3ZmNhY2MxYmRjMzM3ZDRlY2M1ZTM4NWQ0OGJkNzkyODkwOWZlODViYjVkNTg3MzFjIiwidGFnIjoiIn0%3D; expires=Wed, 28-May-2025 12:58:30 GMT; path=/; secure; httponly ◀tagmyfish_session=eyJpdiI6IjNaVG5ZRlVncDNtZC80TTNsYUdNZFE9PSIsInZhbHVlIjoiY0JodkpmSTA4Y3gxTjlBR1VycXJITi9Cc3hzOUZPQmM4ZGFHK1RRKzNDMmxSZHA3RnRza1p6dWFUeUxaV053RT ▶" ] ]
0 of 0array:3 [▼ "_token" => "LpoPJdSkVDe0gheSVkN7cfbopLPuxW5RjFnm5QUx" "_previous" => array:1 [▶ "url" => "https://dev.tagmyfish.com/waters/natural-lake/sottern-lake" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]
