Yoel Alroy

Yoel Alroy (Hebrew: יואל אלרואי; born 1930) is a former Israeli footballer who played in Maccabi Netanya and served as the mayor of Netanya from 1983 to 1993.[1]

Yoel Alroy
Personal information
Full name Yoel Alroy
Date of birth 1930
Place of birth Petah Tikva, Israel
Youth career
Maccabi Netanya
Senior career*
Years Team Apps (Gls)
1947–1960 Maccabi Netanya 95 (17)
* Senior club appearances and goals counted for the domestic league only

Alroy is a lawyer by profession. During his first term as mayor of Netanya there was a wave of development, he was responsible for the new boardwalk on the beach as well as a renovating Herzl street and the Tel-Hai pedestrian street. In 1998, he ran again, this time as an independent but was not elected.

Alroy currently serves as chairman of the Association for the Elderly in Netanya.[2]

Honours

gollark: You could do MULTIPLE nested selects but that would be horrible and I don't know if it would optimize it.
gollark: Oh bee oh apiary form.
gollark: <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714> <@293066066605768714>
gollark: Otherwise something like `SELECT *, (SELECT * FROM posts WHERE thread = threads.id ORDER BY created DESC) FROM threads` I think.
gollark: Well, I might go for putting a `newest_post_id` field in thread.

References


This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.