OpenLLM-France/wikimedia huggingface dataset:
# Sargable

In relational databases, a condition (or predicate) in a query is said to be sargable if the DBMS engine can take advantage of an index to speed up the execution of the query. The term is derived from a contraction of Search ARGument ABLE. It was first used by IBM researchers as a contraction of Search ARGument, and has come to mean simply "can be looked up by an index."
For database query optimizers, sargable is an important property in OLTP workloads because it suggests a good query plan can be obtained by a simple heuristic matching query to indexes instead of a complex, time-consuming cost-based search, thus it is often desired to write sargable queries. A query failing to be sargable is known as a non-sargable query and typically has a negative effect on query time, so one of the steps in query optimization is to convert them to be sargable. The effect is similar to searching for a specific term in a book that has no index, beginning at page one each time, instead of jumping to a list of specific pages identified in an index.
The typical situation that will make a SQL query non-sargable is to include in the WHERE clause a function operating on a column value. The WHERE clause is not the only clause where sargability can matter; it can also have an effect on ORDER BY, GROUP BY and HAVING clauses. The SELECT clause, on the other hand, can contain non-sargable expressions without adversely affecting the performance.
Some database management systems, for instance PostgreSQL, support functional indices. Conceptually, an index is simply a mapping between a value and one or more locations. With a functional index, the value stored in the index is the output of the function specified when the index is created. This capability expands what is sargable beyond base column expressions.
* Sargable operators: =, >, <, >=, <=, BETWEEN, LIKE, IS [NOT] NULL, IN
* Sargable operators that rarely improve performance: <>, NOT, NOT IN, NOT LIKE

## Simple example

WHERE clauses that are sargable typically have field values on the left of the operator, and scalar values or expressions on the right side of the operator.
Not sargable:
This is not sargable because myIntField is embedded in a function. If any indexes were available on myIntField, they could not be used. In addition, SQRT would be called on every record in myTable.
Sargable version:
This is sargable because myIntField is NOT contained in a function, making any available indexes on myIntField potentially usable. Furthermore, the expression is evaluated only once, rather than for each record in the table.

## Text example

WHERE ... LIKE clauses that are sargable have field values on the left of the operator, and LIKE text strings that do not begin with the % on the right.
Not sargable:
This is not sargable. It must examine every row to find the fields containing the substring 'Wales' in any position.
Sargable version:
This is sargable. It can use an index to find all the myNameField values that start with the substring 'Jimmy'.
# Parnassos Literary Society

The Parnassos Literary Society (Greek: Φιλολογικός Σύλλογος Παρνασσός) was founded in 1865 in Athens and has published various magazines. The oldest literary society in mainland Greece, it continues to be active today.
The Society was founded on 24 June 1865 by the four children of the numismatist Pavlos Lambros [el] to contribute to the spiritual, social, and moral improvement of the Greek people through its events. Its first president was Michael Lambros. The club quickly became well-known, and functioned as a sort of Academy with literary, archaeological, legal, artistic and even scientific sections. It organized lectures, exhibitions, and various competitions. In 1872, at the suggestion of S. Vassiliadis, it opened a night school for destitute children. The historian Constantine Paparrigopoulos became honorary chairman.
It was officially recognized as a nonprofit organization by the Greek state on March 17, 1875.
The club is now housed in a private mansion on the St. George Square designed by Ifikratis Kokkidis (Ιφικράτης Κοκκίδης). The club has a valuable library and art gallery with 250 works by Greek artists.

## Publications

From 1877–1895, the club published the magazine Parnassos (Παρνασσός).
From 1896–1939, it published Epeteris (Επετηρίς, "Yearbook").
From 1959 to the present, the club has published a second series of Parnassos quarterly.

## Notable members

* Simos Menardos
* John Pentland Mahaffy
# Salma bint Umays

Salmā bint ʿUmays (Arabic: سلمى بنت عميس) was a companion of the prophet Muhammad, hailing from the southwest Arabian Khath'am tribe.
Her father was Umays ibn Maadd, and her mother was Hind bint Awf from the Himyar tribe. Her full siblings were Asma bint Umays and Awn ibn Umays, and her maternal half-siblings included Maymuna bint al-Harith, Lubaba bint al-Harith and Mahmiya ibn al-Jaz'i. Salma and her sister Asma were among the early converts to Islam.
She married Hamza ibn Abd al-Muttalib, and they had one daughter, Umama. Salma and Umama joined the emigration to Medina in 622; but after Hamza was martyred at the battle of Uhud, they returned to Mecca. Salma then married Shaddad ibn al-Had, who was from the Layth clan of the Bakr tribe, and they had one son, Abdullah.
Salma was still living in Mecca in March 629, when Muhammad visited to perform the minor pilgrimage. At that time, Ali took her daughter Umama away to live among the Muslims in Medina.
# Stalmine

Stalmine is a village in the civil parish of Stalmine-with-Staynall, in the Wyre borough of Lancashire, England, in a part of the Fylde known as Over Wyre. The village is located on a small hill on the A588, the main road between Hambleton and Lancaster, with the highest level 75 ft above sea level. The village name has been spelled Stalmin (in 1205) and Stalemynne (in 1278). The village had a population of 1,087 at the 2011 Census.

## Village history

The name is thought to mean the pool or stream at the mouth of the river, from the Old English steall and the Old Norse mynni.
The village history dates back to 1066 when Tostig Godwinson held it as part of his Preston Fee. The first recorded possessor was Robert de Stalmine in 1165. The chapel of Stalmine was first mentioned about 1200 and a cemetery was consecrated in 1230. The chapel was rebuilt in 1806 when it was renamed St James. In 1689 Stalmine had a Presbyterian meeting house, which in 1717 was stated to be located "very near to the chapel".

## Amenities

The village church, St. James Church (Church of England) on Hallgate Lane, has a sundial dated 1690. The village has one pub (the Seven Stars), which is located at the top of the hill in the village, and one school, Stalmine County Primary School. Stalmine Hall Residential Park is located near the church, in the grounds of the 19th century Stalmine Hall.

## Sport

The village is home to the amateur football club Wyre Villa, who play in the West Lancashire League, part of the English football league system. They play their home games at Hall Gate Park on the edge of the village. The most successful season in the club's history to date was in 1996-97 when they were West Lancashire League champions. Blackpool F.C. Ladies also play their home games at Hall Gate Park.
# Square Tower (Sarawak)

The Square Tower is a clock tower in Kuching, Sarawak, Malaysia.

## History

The building was originally constructed in 1879 as a prison. It was then later turned into a fortress.

## Architecture

The building bears the Brooke era coat of arms.
# Alt Nation

Alt Nation is a Sirius XM Radio station broadcasting alternative rock from the 2000s to the present. It is carried on Sirius XM Radio channel 36 and DISH Network channel 6036.
The station hosts the Alt Nation Ping Pong Throwdown, which offers listeners the chance to play table tennis with bands featured on the station.
Alt Nation has become increasingly known for breaking new bands into the alternative rock radio scene. For example, the station was the first to play "Pumped Up Kicks" by Foster the People, which went to number one on the Alternative Rock Chart.

## Hosts

* Jeff Regan
* Madison
* Tatiana Miranda
* Justin Kade
* Kyle Anderson
* JaRon
* Dan

## Core artists

* Bastille
* Cage the Elephant
* Grouplove
* Twenty One Pilots
* Vampire Weekend
* The Black Keys
* Foster the People
* the 1975
* Glass Animals
* Billie Eilish
* Jimmy Eat World
* Muse
* Silversun Pickups
* Gorillaz
* Young the Giant
# Henry Beverhout

Henry Beverhout was an African-Caribbean methodist minister who led a company of Nova Scotian settlers who settled in Sierra Leone.
Beverhout was an African-Caribbean person born free in St Croix, an island in the Danish West Indies. He moved to Charleston, South Carolina but aligned himself with the Black Loyalists with whom he migrated to New Brunswick, Canada, following the defeat of the British in the American War of Independence. Here he organised a methodist congregation which joined the migration to Sierra Leone in Halifax, Nova Scotia. He became the leader or captain of a "company", a social unit of self-government the Nova Scotian settlers developed and was to become a vociferous critic of the Sierra Leone Company after the settlers had arrived in Africa.
His daughter, Ann, married the Anglican missionary Gustavus Reinhold Nyländer. A second daughter, Frances, married another Anglican missionary, Charles Wenzel.$^{:177}$
# Reginald Stewart (conductor)

Reginald Stewart (20 April 1900 in Edinburgh – 8 July 1984 in Santa Barbara, California) was a Scottish conductor, pianist, and music educator who was chiefly active in the United States and Canada.

## Life and career

He was Born with in Edinburgh, Scotland, Stewart began his musical studies in his native city with H.T. Collinson, the choirmaster at St Mary's Cathedral. He then pursued studies with Arthur Friedheim and Mark Hambourg in Toronto, Canada, and with Nadia Boulanger and Isidor Philipp in Paris.
In the 1920s, Stewart was musical director at the University of Toronto's Hart House. During this period, he was hired by the Toronto Daily Star′s radio station, CFCA, to create and lead Canada's first radio orchestra, consisting of 50 musicians, for the station's regular dance program, Hour of Good Music.
Stewart is best remembered as the conductor of the Baltimore Symphony Orchestra (1942-1952) and the head of the Peabody Conservatory (1941-1958). In 1933 he founded the Toronto Bach Choir and in 1934 he founded the Toronto Philharmonic Orchestra. Stewart resigned from his conducting posts with both ensembles after accepting a position with Peabody in 1941.
In 1962 Stewart became an artist-in-residence at the Music Academy of the West in Montecito, California where he ultimately became chair of the piano department. He remained in Santa Barbara until his death at the age of 84 in July 1984.
# Dili Municipality

Dili Municipality (Portuguese: Município Díli, Tetum: Munisípiu Dili) is one of the 14 municipalities, formerly districts, of Timor-Leste, and includes the national capital Dili. The municipality had a population of 277,279 as of 2015 most of whom live in the capital city.

## Etymology

Several explanations have been proffered for the origin of the municipality's name. It is often explained, including by the municipality's own website, as being derived from the Tetum word ai-dila, which means pawpaw. According to Australian linguist, ethnologist and historian Geoffrey Hull, however, that explanation is phonologically and historically implausible, as the language spoken in the area now known as Dili before the Portuguese established their seat of administration there in 1769 was Mambai, not Tetum. Hull describes such explanations as "folk etymology".
In Hull's view, the word Dili appears to be cognate with the Bunak word zili (transl. 'cliff'), a reference to the escarpment behind the city; he comments that a Papuan language, of which Bunak is an example, was spoken in the Dili area before the spread of the Austronesian-based Mambai and Tetum languages.
Another "folk etymology" explanation suggested by the municipality is that its name is derived from the Portuguese word Dali, which, in turn, is an approximation of the Tetum expression tali akar (transl. 'hemp rope'). According to the municipality, there were lots of hemp trees in what is now the suco of Caicoli [de] at the centre of the then Reino Motaain, which covered present day Dili. Every year, the local community held a traditional dance ceremony, and also offered sacrifices for the hemp tree. The local people believed that the Portuguese word Dali meant 'sacred eye', and so they adopted it as the area's name.

## Geography

Since 1 January 2022, Dili has been the second smallest municipality in East Timor by area, at 224.0 km$^2$ (86.5 sq mi). It also has the highest population. It lies on the north coast of the island of Timor facing Ombai Strait,$^{:ESI-4,2-13}$ and borders the municipalities of Manatuto to the east, Aileu to the south, and Liquiçá to the west.
Atauro Island, to the north of the municipality opposite the capital, was one of Dili's administrative posts until the end of 2021, when it became a separate municipality.
Dili is the economic and political centre of East Timor.

## Administrative posts

The municipality's administrative posts (formerly sub-districts) are:
* Cristo Rei
* Dom Aleixo
* Metinaro
* Nain Feto; and
* Vera Cruz
The administrative posts are divided into 31 sucos ("villages") in total.
* Subdivisions of the municipality
* Cities in the municipality of Dili
# Šerif Hasić

Šerif Hasić (born 7 January 1988) is a Bosnian former professional footballer who plays as a centre-back.

## Honours

Mladost Doboj Kakanj
* First League of FBiH: 2014–15
# Vladimir Karalić

Vladimir Karalić (Serbian Cyrillic: Bлaдимиp Kapaлић; born 22 March 1984) is a Bosnian former professional footballer who played as a forward.
Karalić has represented Bosnia and Herzegovina national team once in 2007.

## Club career
### Sun Pegasus

On 11 January 2013, Karalić joined Hong Kong First Division League club Sun Pegasus from Rudar Prijedor for an undisclosed fee. After the season ended, Karalić was released by Sun Pegasus.

## International career

Karalić has made an appearance for the Bosnia and Herzegovina national team in a friendly match against Poland on 15 December 2007.

## Personal life

His father Slobodan Karalić was a professional football player.

## Career statistics
### Hong Kong

    As of 11 January 2013. The following table only shows statistics in Hong Kong.
| Club | Season | Division | League | League | Senior Shield | Senior Shield | League Cup | League Cup | FA Cup | FA Cup | AFC Cup | AFC Cup | Total | Total |
| Club | Season | Division | Apps | Goals | Apps | Goals | Apps | Goals | Apps | Goals | Apps | Goals | Apps | Goals |
| Sun Pegasus | 2012–13 | First Division | 1 | 0 | 0 | 0 | — | — | 0 | 0 | N/A | N/A | 0 | 0 |
| Sun Pegasus Total | Sun Pegasus Total | Sun Pegasus Total | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Hong Kong Total | Hong Kong Total | Hong Kong Total | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
# Enis Nadarević

Enils Nadarević (born 19 July 1987) is a Bosnian former football winger. He last played for Città di Fasano.

## Career

Born in Bihać in the former Yugoslavia, Nadarević moved to Italy as a youth in 2005. He signed a contract to play professional football with A.S. Varese 1910, but was initially unable to play for the club due to restrictions on non-EU players in the Serie B. He spent the 2009–10 season on loan at Serie D side A.S.D. Sanvitese.
Shortly after an Italian court ruled that he could play in Serie B, Nadarević made his league debut in a match against Siena on 18 December 2010.

### Genoa

In January 2013 Genoa acquired Nadarević for €300,000 transfer fee. On 16 July he was signed by Serie B club A.C. Cesena in a temporary deal. In January 2014 he left for Bari, which he was sent off during a match and suspended for 3 matches.

### Trapani

On 19 July 2014 Nadarević was signed by Serie B club Trapani in a temporary deal, with an option to purchase outright. On 21 June 2015 Trapani excised the option.
On 28 January 2016 he was signed by Novara in a temporary deal, with an option to purchase outright.

### Monopoli

On 18 December 2016 was signed at Monopoli in Lega Pro.

### Fidelis Andria

On August 20167 it was announced Nadarević signed a 1-year deal with the Serie C side Fidelis Andria.
# Samir Šarić

Samir Šarić (born 27 May 1984 in Sarajevo) is a Bosnian-Herzegovinian retired football player.

## Club career

He has played for Radnik Hadžići, FK Sarajevo, Umeå FC, Løv-Ham and Sandefjord.

### Career statistics

| Season | Club | Division | League | League | Cup | Cup | Europe | Europe | Total | Total |
| Season | Club | Division | Apps | Goals | Apps | Goals | Apps | Goals | Apps | Goals |
| 2004–05 | FK Sarajevo | Premijer liga BiH | 26 | 6 | 9 | 4 | – | – | 35 | 10 |
| 2005–06 | FK Sarajevo | Premijer liga BiH | 28 | 6 | 5 | 3 | – | – | 33 | 9 |
| 2006–07 | FK Sarajevo | Premijer liga BiH | 2 | 0 | 0 | 0 | 1 | 0 | 3 | 0 |
| 2007 | Løv-Ham | Adeccoligaen | 22 | 10 | 0 | 0 | - | - | 22 | 10 |
| 2008 | Løv-Ham | Adeccoligaen | 18 | 8 | 2 | 3 | - | - | 20 | 11 |
| 2008 | Sandefjord | Adeccoligaen | 7 | 2 | 0 | 0 | - | - | 7 | 2 |
| 2009 | Sandefjord | Tippeligaen | 14 | 1 | 1 | 0 | - | - | 15 | 1 |
| 2010 | Sandefjord | Tippeligaen | 13 | 2 | 4 | 4 | - | - | 17 | 6 |
| 2011 | Sandefjord | Adeccoligaen | 0 | 0 | 0 | 0 | - | - | 0 | 0 |
| Career Total | Career Total | Career Total | 130 | 35 | 21 | 14 | 1 | 0 | 152 | 49 |
# Edin Šehić

Edin Šehić (Bosnian pronunciation:; born 3 February 1995) is a Bosnian footballer who plays as a winger for Bosnian Premier League club Igman Konjic.

## Club career

Although Šehić's parents hail from the Bosnian city of Zavidovići, he was born in the Croatian city of Zagreb. His father, Jusuf played youth football for Krivaja Zavidovići.
From the age of five, Šehić started training with Dubrava, before joining the youth setup of NK Zagreb at the age of nine. Three years later, at the age of 12, he became the youngest footballer to sign a scholarship contract for NK Zagreb.
In 2013, Šehić was promoted to the first team and signed a seven-year deal. He scored his first goal in a 4–3 win against Segesta. Although the club was relegated from the first tier in 2015–16, he continued to play with the club. He scored a hat-trick in the first league match against Rudeš. He contributed with ten goals in the season, playing as an attacker in the later half of the season.
On 22 April 2017, Šehić moved to Hajduk Split, after agreeing to a three-year deal. On 16 July, he made his debut in a 1–1 draw against Lokomotiva. In August, he made his UEFA Europa League debut in a 2–0 victory against Danish club Brøndby IF. Coming on as a 75th-minute substitute for Zvonimir Kožulj, Sehić received a yellow card twelve minutes later.
On 9 January 2019, Šehić terminated his contract with the club on mutual consent. On 22 January 2019, he signed for Ukrainian Premier League club Vorskla Poltava.
In August 2021, Šehić moved to the Cypriot Second Division side Akritas Chlorakas following a month-long stint at NK Rudeš. There, he helped the club achieve promotion, capping 28 times in the first season at the club.

## International career

Šehić is a Bosnian-Herzegovinian youth international and has played for the under-18 team and under-21 team.

## Career statistics
### Club

    As of match played on 4 November 2018
| Club | Season | League | League | League | Cup | Cup | Continental | Continental | Total | Total |
| Club | Season | Division | Apps | Goals | Apps | Goals | Apps | Goals | Apps | Goals |
| Zagreb | 2013–14 | Druga HNL | 22 | 1 | 1 | 0 | — | — | 23 | 1 |
| Zagreb | 2014–15 | Prva HNL | 9 | 0 | 1 | 0 | — | — | 10 | 0 |
| Zagreb | 2015–16 | Prva HNL | 19 | 0 | 3 | 0 | — | — | 22 | 0 |
| Zagreb | 2016–17 | Druga HNL | 23 | 10 | 1 | 0 | — | — | 24 | 10 |
| Zagreb | Total | Total | 73 | 11 | 6 | 0 | — | — | 79 | 11 |
| Hajduk Split | 2017–18 | Prva HNL | 12 | 0 | 2 | 0 | 1 | 0 | 15 | 0 |
| Hajduk Split | 2018–19 | Prva HNL | 3 | 0 | 1 | 0 | 0 | 0 | 4 | 0 |
| Hajduk Split | Total | Total | 15 | 0 | 3 | 0 | 1 | 0 | 19 | 0 |
| Rudar Velenje (loan) | 2017–18 | Slovenian PrvaLiga | 16 | 3 | 0 | 0 | — | — | 16 | 3 |
| Career total | Career total | Career total | 104 | 14 | 9 | 0 | 1 | 0 | 114 | 14 |
* ↑ Appearances in UEFA Europa League

## Personal life

While watching the final of the 2013 Croatian Football Cup between Hajduk Split and Lokomotiva, Šehić, who is a Hajduk fan, was attacked.
# Tomislav Stanić

Tomislav Stanić (born 30 May 1981) is a Bosnian-Herzegovinian retired footballer who last played for Malavan in the Iran Pro League.

## Club career

Stanić previously played for Hajduk Split and NK Inter Zaprešić in the Croatian First League, making only a handful of substitute appearances over three seasons. He had a brief spell with Dynamo Dresden in the German 2. Bundesliga during the 2005-06 season where he scored 1 goal. He became the first foreign footballer to ever play for Malavan F.C. when he joined the club in 2008.

## Azerbaijan career statistics

| Club performance | Club performance | Club performance | League | League | Cup | Cup | Continental | Continental | Total | Total |
| Season | Club | League | Apps | Goals | Apps | Goals | Apps | Goals | Apps | Goals |
| Azerbaijan | Azerbaijan | Azerbaijan | League | League | Azerbaijan Cup | Azerbaijan Cup | Europe | Europe | Total | Total |
| 2006-07 | Inter Baku | Azerbaijan Premier League | 4 | 0 | | | - | - | 4 | 0 |
| 2007-08 | Gänclärbirliyi Sumqayit | Azerbaijan Premier League | 18 | 3 | | | - | - | 18 | 3 |
| Total | Azerbaijan | Azerbaijan | 22 | 3 | | | 0 | 0 | 22 | 3 |
| Career total | Career total | Career total | 22 | 3 | | | 0 | 0 | 22 | 3 |
# Tonyboy Espinosa

Antonio "Tonyboy" Espinosa (sometimes spelled as Tony Boy) is a Filipino former basketball player and basketball coach who serving as one of the assistant coaches under Chito Victolero of the Magnolia Hotshots in the PBA.

## Playing career
### La Salle

Espinosa played for De La Salle Green Archers from 1991 to 1995 under Derrick Pumaren, and later with Virgil Villavicencio, and played with future colleague Jason Webb. In the 1991 UAAP Finals, he played against FEU Tamaraws led by another future colleague Johnny Abarrientos. With the Green Archers leading, 76–71, Espinosa was called for his fifth foul on Johnny Abarrientos. But the referees failed to send the La Salle guard out of the game, letting some seconds run down before Adi Papa was sent in as his replacement. La Salle won the game, but the FEU coach Arturo Valenzona protested and eventually claimed the title, because La Salle did not appear on the rematch game after the protest.

### Professional

Espinosa was drafted by Mobiline Cellulars in 1997, and played on the team until 1999. He played with Batangas Blades. He was free agent until 2004, when he was signed by then James Yap-led Purefoods TJ Hotdogs. He also played on Coca-Cola Tigers from 2005 until 2006.

## Coaching career

Espinosa was hired in 2015 when Jason Webb was appointed as an assistant coach in Star Hotshots. That time, another former Green Juno Sauler joined the staff. When Webb was demoted, he was retained.
He was assigned as head coach of Purefoods TJ Titans of the PBA 3x3.