DKIP
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, tz.offset_dst AS offset_dst, tz.dst_region, tz.is_dst, e.event_start ...' at line 1
query: SELECT DISTINCT(n.nid), n.uid, n.title, n.type, e.event_start, e.event_start AS event_start_orig, e.event_end, e.event_end AS event_end_orig, e.timezone, e.has_time, e.has_end_date, tz.offset AS offset, tz.offset_dst AS offset_dst, tz.dst_region, tz.is_dst, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_start_utc, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_end_utc, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL 0 SECOND AS event_start_user, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL 0 SECOND AS event_end_user, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL 3600 SECOND AS event_start_site, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL 3600 SECOND AS event_end_site, tz.name as timezone_name FROM dobb_node n INNER JOIN dobb_event e ON n.nid = e.nid INNER JOIN dobb_event_timezones tz ON tz.timezone = e.timezone INNER JOIN dobb_node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( n.status = 1 AND ((e.event_start >= '2024-04-30 00:00:00' AND e.event_start <= '2024-06-01 23:59:59') OR (e.event_end >= '2024-04-30 00:00:00' AND e.event_end <= '2024-06-01 23:59:59') OR (e.event_start <= '2024-04-30 00:00:00' AND e.event_end >= '2024-06-01 23:59:59')) ) GROUP BY n.nid HAVING (event_start >= '2024-05-01 00:00:00' AND event_start <= '2024-05-31 23:59:59') OR (event_end >= '2024-05-01 00:00:00' AND event_end <= '2024-05-31 23:59:59') OR (event_start <= '2024-05-01 00:00:00' AND event_end >= '2024-05-31 23:59:59') ORDER BY event_start ASC in /home/do1741500/www_root/includes/database.mysql.inc on line 174.
Profil (Profile)
| Foto(Photo): |
|
| Meno(Name): |
Ádám Markó |
| Kraj(Country): |
Zahraničie (outland) |
| Rok narodenia(Birth): |
1982 |
| Kontakt(Contact): |
adammarko82@gmail.com |
| Mobil(Cell): |
|
| Povolanie(Profession): |
drummer |
| Bicia súprava(Drums): |
Yamaha Oak Custom, Pearl Export Select |
| Snare: |
Pearl Chad Smith Signature |
| Hardware: |
Pearl, Giblaltar |
| Činely(Cymbals): |
Alchemy, Istanbul |
| Paličky(Sticks): |
Csibi Sticks |
| Blany(Heads): |
Aquarian |
| Elektronika(Electronics): |
- |
| Doplnky(Accessories): |
|
| Hral(a) som v skupine(Band): |
Ganxta Zolee & Kartel, Hrutka Róbert, Miller Zoltán, Groove Funky Gang, Kálloy-Molnár Péter, Für Anikó |
| Hrám v skupine(Band): |
David Kollar Project, Special Providence |
| O sebe(About me): |
Born in 26th of january 1982 in Budapest, Hungary. His parents are both classical musicians, and for this, music determined his childhood. At 4 years age he started to "hit the beats" with toys and he decided to be a drummer when he grows up. From 1988 he studied at the Aelia Sabina Music School as the student of Tibor Kovács and Oszkár Balázs until 1996. From autumn 1996 he learned to improvise and "think as a drummer" from Iván Nesztor. This was the era when he met jazz music. In 2001 he was admitted to the Kobánya Music Studio where he graduated in 2006 . He thinks very thankfully of this institution, because of all his teachers (János Sramkó, János Solti, Vilmos Jávori, Gyula Babos, János Rudolf Tóth) and all the subjects he learned.He plays in different bands since 1996. In january 2004, with former schoolmate and friend, Zoltán Cséry, they formed Special Providence prog-fusion band. Nowadays this band is one of the most dominant modern jazz-rock group in Hungary.
Having an approach, by putting music as a priority over virtosistic individualisim, allows the band to represent fusion jazz in a new light. The group is very appreciated in and around Hungary with their virtoso, yet easily digestable style. Having released their first album in 2006 titled „Space Cafe“ and then being invited to go on tour with the well established Jeff Andrews Trio. In 2008 they released their 2nd album titled "Labyrinth" which got very good critics in the international music scene. They are undoubtable a band highly recommended, with their huge dynamic stage presonce and aura for any listerner to digest. Adam is the member of several great pop/rock music groups and jazz bands as a sessionmusician. In 2009 they formed a trio with a slovakian guitarist David Kollar. They recorded their first dvd in august 2009. Adam performed in several countries (England,Slovakia,Poland,Italy,Czech Republic,Romania,Serbia,Bulgaria and Greece). Music is his life, and desires to serve it on the highest level wherever in the world. Musical diversity and individuality in music are the two keystones in his playing and his music.
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
História
- Členom už
- 13 rokov 49 týždňov
Pošta
- Prihás sa, alebo si vytvor Profil, aby si mohol poslať správu tomuto používateľovi.
