Operário Esporte Clube
Operário Esporte Clube, commonly known as Operário, is a Brazilian football club based in Manacapuru, Amazonas state.
| Full name | Operário Esporte Clube | ||
|---|---|---|---|
| Founded | June 10, 1982 | ||
| Ground | Gilbertão, Manacapuru, Amazonas state, Brazil | ||
| Capacity | 15,000 | ||
|
| |||
History
The club was founded on June 10, 1982.[1] Operário won the Campeonato Amazonense Second Level in 2010.[1]
Achievements
- Campeonato Amazonense Second Level:
- Winners (1): 2010
Stadium
Operário Esporte Clube play their home games at Estádio Olímpico Municipal Gilberto Mestrinho, nicknamed Gilbertão.[1] The stadium has a maximum capacity of 15,000 people.[2]
gollark: Oops, it turns out I'm accidentally sorting by it instead of the rank, but it's equally slow after fixing that.
gollark: ```nonlocality=# EXPLAIN ANALYZE SELECT url, ts_rank(fts, query), ts_headline(fts::text, query, 'MaxWords=60') AS rank FROM pages, websearch_to_tsquery('bee') query WHERE fts @@ query ORDER BY rank LIMIT 1; QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------- Limit (cost=860.92..860.92 rows=1 width=96) (actual time=8506.425..8506.427 rows=1 loops=1) -> Sort (cost=860.92..861.05 rows=52 width=96) (actual time=8506.423..8506.425 rows=1 loops=1) Sort Key: (ts_headline((pages.fts)::text, query.query, 'MaxWords=60'::text)) Sort Method: top-N heapsort Memory: 25kB -> Nested Loop (cost=688.65..860.66 rows=52 width=96) (actual time=1.362..8505.403 rows=348 loops=1) -> Function Scan on websearch_to_tsquery query (cost=0.25..0.26 rows=1 width=32) (actual time=0.023..0.025 rows=1 loops=1) -> Bitmap Heap Scan on pages (cost=688.40..846.49 rows=52 width=142) (actual time=0.353..1.502 rows=348 loops=1) Recheck Cond: (fts @@ query.query) Heap Blocks: exact=231 -> Bitmap Index Scan on page_search_index (cost=0.00..688.39 rows=52 width=0) (actual time=0.320..0.320 rows=387 loops=1) Index Cond: (fts @@ query.query) Planning Time: 0.190 ms Execution Time: 8506.463 ms(13 rows)```
gollark: It's not a condition, it's an extra row on the output, and I can see exactly what it does via `EXPLAIN ANALYZE`.
gollark: Maybe I need a better full text search backend?!
gollark: This is apioform.
References
- Placar Guia 2011 (1350-C): 85. January 2011. Missing or empty
|title=(help) - "CNEF – Cadastro Nacional de Estádios de Futebol" (PDF) (in Portuguese). Confederação Brasileira de Futebol. Archived from the original (PDF) on May 10, 2013. Retrieved March 25, 2011.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.