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 >= '2026-05-31 00:00:00' AND e.event_start <= '2026-07-01 23:59:59') OR (e.event_end >= '2026-05-31 00:00:00' AND e.event_end <= '2026-07-01 23:59:59') OR (e.event_start <= '2026-05-31 00:00:00' AND e.event_end >= '2026-07-01 23:59:59')) ) GROUP BY n.nid HAVING (event_start >= '2026-06-01 00:00:00' AND event_start <= '2026-06-30 23:59:59') OR (event_end >= '2026-06-01 00:00:00' AND event_end <= '2026-06-30 23:59:59') OR (event_start <= '2026-06-01 00:00:00' AND event_end >= '2026-06-30 23:59:59') ORDER BY event_start ASC in /home/dx040700/www_root/includes/database.mysql.inc on line 174.
| Foto(Photo): |
|
| Meno(Name): |
František Kadera |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1990 |
| Kontakt(Contact): |
frantisek.kadera@gmail.com |
| Mobil(Cell): |
|
| Povolanie(Profession): |
student |
| Bicia súprava(Drums): |
Mapex Voyager |
| Snare: |
Mapex Voyager |
| Hardware: |
Mapex, Gibraltar |
| Činely(Cymbals): |
Paiste PST3, PST5, PST8 |
| Paličky(Sticks): |
Vic Firth |
| Blany(Heads): |
Remo |
| Elektronika(Electronics): |
--- |
| Doplnky(Accessories): |
Dvojšlapka Pearl Pearl P-122 TW |
| Hral(a) som v skupine(Band): |
--- |
| Hrám v skupine(Band): |
--- |
| O sebe(About me): |
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
| Foto(Photo): |
|
| Meno(Name): |
Miroslav Valkovič |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1993 |
| Kontakt(Contact): |
0915131456 |
| Mobil(Cell): |
|
| Povolanie(Profession): |
Zvarac |
| Bicia súprava(Drums): |
Gretsch Catalina Club |
| Snare: |
Gretsch |
| Hardware: |
Premier |
| Činely(Cymbals): |
Soultone extreme |
| Paličky(Sticks): |
PROMark |
| Blany(Heads): |
Evans |
| Elektronika(Electronics): |
None |
| Doplnky(Accessories): |
|
| Hral(a) som v skupine(Band): |
Chunky Waves |
| Hrám v skupine(Band): |
None |
| O sebe(About me): |
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
| Foto(Photo): |
|
| Meno(Name): |
Ján lau |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1976 |
| Kontakt(Contact): |
drummer@me.com |
| Mobil(Cell): |
|
| Povolanie(Profession): |
Drummer |
| Bicia súprava(Drums): |
Yamaha maple custom absolute |
| Snare: |
Omar hakim |
| Hardware: |
Yamaha |
| Činely(Cymbals): |
Meinl |
| Paličky(Sticks): |
silverfox |
| Blany(Heads): |
Evans onyx |
| Elektronika(Electronics): |
... |
| Doplnky(Accessories): |
|
| Hral(a) som v skupine(Band): |
Ghymes.
Indigo |
| Hrám v skupine(Band): |
Ghymes ,indigo |
| O sebe(About me): |
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
| Foto(Photo): |
|
| Meno(Name): |
Jindřich Planka |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1966 |
| Kontakt(Contact): |
gino.leopoldov@gmail.com |
| Mobil(Cell): |
|
| Povolanie(Profession): |
bubeník |
| Bicia súprava(Drums): |
Pearl rok 1983 |
| Snare: |
Pearl |
| Hardware: |
Pearl |
| Činely(Cymbals): |
paiste, zildian |
| Paličky(Sticks): |
5A |
| Blany(Heads): |
Remo |
| Elektronika(Electronics): |
Roland TD 17 |
| Doplnky(Accessories): |
percusné nástroje |
| Hral(a) som v skupine(Band): |
Kamene-Beata Dubasová, Perinbaba, Presburg, Fermata, Maybe..... |
| Hrám v skupine(Band): |
GINOSLAV |
| O sebe(About me): |
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
| Foto(Photo): |
|
| Meno(Name): |
Peter Horváth |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1985 |
| Kontakt(Contact): |
peterhorvath1985@gmail.com |
| Mobil(Cell): |
|
| Povolanie(Profession): |
muž |
| Bicia súprava(Drums): |
Pearl Forum |
| Snare: |
Pearl |
| Hardware: |
Pearl |
| Činely(Cymbals): |
Zijdjian |
| Paličky(Sticks): |
Vater Pro rock |
| Blany(Heads): |
Remo |
| Elektronika(Electronics): |
nemám |
| Doplnky(Accessories): |
|
| Hral(a) som v skupine(Band): |
April Weeps |
| Hrám v skupine(Band): |
doom projekt |
| O sebe(About me): |
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
| Foto(Photo): |
|
| Meno(Name): |
Ivan Javorčík |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1995 |
| Kontakt(Contact): |
0911845848 |
| Mobil(Cell): |
|
| Povolanie(Profession): |
študent |
| Bicia súprava(Drums): |
Mapex Black Panther Velvetone
povrchová úprava Butter Burst
Bass 22×18"
Tom tom 10×8„, 12×9“
Floor tom 14×14„, 16×16“
|
| Snare: |
Sonor Force 3007 maple 14x5,5 |
| Hardware: |
Sonor, Mapex, Yamaha, Pearl, Gibraltar |
| Činely(Cymbals): |
Meinl, Paiste, Soultone, Sabian |
| Paličky(Sticks): |
Pro-mark 5B, Vic Firth 3A |
| Blany(Heads): |
Remo: Emperor X, Emperor coated, Powerstroke 3 |
| Elektronika(Electronics): |
Metronóm BOSS DB-30,Dr.Beat |
| Doplnky(Accessories): |
|
| Hral(a) som v skupine(Band): |
The Reflex, STO KORUN! |
| Hrám v skupine(Band): |
The Reflex, STO KORUN! |
| O sebe(About me): |
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
| Foto(Photo): |
|
| Meno(Name): |
Juraj Rudík |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1984 |
| Kontakt(Contact): |
jurajrudik@gmail.com |
| Mobil(Cell): |
0907747543 |
| Povolanie(Profession): |
Tlačiar |
| Bicia súprava(Drums): |
TAMA swingstar |
| Snare: |
tama , 14/ 5,5 plech |
| Hardware: |
Tama,Yamaha stojany
Yamaha Hit-hat stojan
Yamaha profesional -dvoj pedal |
| Činely(Cymbals): |
Meinl |
| Paličky(Sticks): |
Vater 5B |
| Blany(Heads): |
Remo-tom-tom , Evans-snare |
| Elektronika(Electronics): |
Roland Handsonic 10 , Boss DB 90 |
| Doplnky(Accessories): |
|
| Hral(a) som v skupine(Band): |
Predmestie minulosti
|
| Hrám v skupine(Band): |
RannéToporenie,Bystrík |
| O sebe(About me): |
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
| Foto(Photo): |
|
| Meno(Name): |
Roman Lehuta |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1966 |
| Kontakt(Contact): |
johmysta@gmail.com |
| Mobil(Cell): |
|
| Povolanie(Profession): |
elektrikár |
| Bicia súprava(Drums): |
Roland |
| Snare: |
Pearl |
| Hardware: |
Roland |
| Činely(Cymbals): |
Roland |
| Paličky(Sticks): |
Goodwood |
| Blany(Heads): |
Remo |
| Elektronika(Electronics): |
Roland TD11 |
| Doplnky(Accessories): |
|
| Hral(a) som v skupine(Band): |
Protakt, Problém |
| Hrám v skupine(Band): |
Brothersband |
| O sebe(About me): |
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
| Foto(Photo): |
|
| Meno(Name): |
Lukáš Šiška |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1981 |
| Kontakt(Contact): |
lukas.siska4@gmail.com |
| Mobil(Cell): |
|
| Povolanie(Profession): |
vedúci predajne |
| Bicia súprava(Drums): |
Pearl Vision VSX Grafitti Limited Edition |
| Snare: |
Peral Free Floating steel 14x6,5 |
| Hardware: |
Gibraltar, DW 9002 double pedal, Yamaha, Pearl |
| Činely(Cymbals): |
Sabian B8 Pro, Zildjian 14" Avedis A Projection Hi-Hat, Stagg, Paiste |
| Paličky(Sticks): |
Vic Firth, Vic Firth NOVA |
| Blany(Heads): |
Remo Emperor, Coated Ambassador snare |
| Elektronika(Electronics): |
Apple MacBook + external audio device M-Audio fast track pro, Alesis 5 |
| Doplnky(Accessories): |
|
| Hral(a) som v skupine(Band): |
Darkside ( austria), Galadriel, Ravenarium, Adam Ďurica band, Xenon( austria) |
| Hrám v skupine(Band): |
Craniotomy, Dysanchely, TANX |
| O sebe(About me): |
Mám strašne rád hru na bicie a hľadanie uplatnenia a skúseností v rozličných štýloch. Každá skúsenosť ma posunie ďalej a hlavne cvičiť, cvičiť, cvičiť :)
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
| Foto(Photo): |
|
| Meno(Name): |
Mario Hajdin |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1980 |
| Kontakt(Contact): |
Sekule |
| Mobil(Cell): |
0944977402 |
| Povolanie(Profession): |
Szco |
| Bicia súprava(Drums): |
Mapex Mbirch 22, 16, 12, 8 + SD Tama Rockstar ocel 14
Mapex Pro M 22, 14, 10 + SD Tama Rockstar ocel 14
Mapex Saturn V 22, 16, 14, 12, 10 + SD Black panther black widow 14
|
| Snare: |
Tama Rockstar ocel, Mapex Black panther |
| Hardware: |
Tama, Mapex |
| Činely(Cymbals): |
Sabian XS, Anatolian expression, Meinl HCS |
| Paličky(Sticks): |
Vater, Vic firth, Pro Mark, Balbex |
| Blany(Heads): |
Evans G2 clear / coated, Evans G1 clear |
| Elektronika(Electronics): |
Yamaha clickstation, Boss micro BR |
| Doplnky(Accessories): |
Cajon |
| Hral(a) som v skupine(Band): |
Enemmy, CRS, Blue scouts moody seed, Sabotage, Arteria |
| Hrám v skupine(Band): |
Pandora, Frenciz, Between Harmony, Opium Poppy |
| O sebe(About me): |
Večný učeň na bicie.
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
| Foto(Photo): |
|
| Meno(Name): |
Marek Susla |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1983 |
| Kontakt(Contact): |
marek@metropolis.sk |
| Mobil(Cell): |
|
| Povolanie(Profession): |
Hudobník |
| Bicia súprava(Drums): |
Sonor 20" BD, 10" TT, 12" TT, 14" TT |
| Snare: |
14"x6,5", 10"x5", 10"x2" |
| Hardware: |
Sonor 400´s series |
| Činely(Cymbals): |
Istanbul Mehmet cymbals |
| Paličky(Sticks): |
Vater Fusion |
| Blany(Heads): |
Remo Emperor Clear |
| Elektronika(Electronics): |
Korg-D888 |
| Doplnky(Accessories): |
|
| Hral(a) som v skupine(Band): |
Hral som asi v siestich kapelach rozneho zanru... |
| Hrám v skupine(Band): |
Metropolis, S.M.O.G., Michal Balla Trio |
| O sebe(About me): |
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
| Foto(Photo): |
RADOVAN HOLUBEK |
| Meno(Name): |
RADOVAN HOLUBEK |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1984 |
| Kontakt(Contact): |
radovan.holubek@gmail.com |
| Mobil(Cell): |
+421905199309 |
| Povolanie(Profession): |
bubeník |
| Bicia súprava(Drums): |
Sonor Delite - color: Brilliant champagne
bass drum: 22"x17,5"
tom1: 10"x9"
tom2: 12"x10"
tom3: 14"x12"
|
| Snare: |
sonor delite snare: 14"x 4 1/4" |
| Hardware: |
Sonor 400´s and 600´s series, yamaha |
| Činely(Cymbals): |
Zildjian A custom projection, Zildjian Armand, |
| Paličky(Sticks): |
signature Joker |
| Blany(Heads): |
Remo emperor clear- tom´s, Remo Coated Ambassador - snare, Evans - bass drum. |
| Elektronika(Electronics): |
Korg MA30 Metronom, Roland Handsonic HPD10 |
| Doplnky(Accessories): |
|
| Hral(a) som v skupine(Band): |
P.S., Beáta Dubasová, Panama, Adam Ďurica, Sisa Sklovská, Peci Uherčík, Metropolis, Martin Kelecsenyi, Robo Papp & Bystrík, Mirnix- Dirnix, Dagmar Rostandt, Setback, Elán je Elán band etc.. |
| Hrám v skupine(Band): |
Beata Dubasová / independent |
| O sebe(About me): |
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
| Foto(Photo): |
DBO |
| Meno(Name): |
Alexander Mikóczi |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1983 |
| Kontakt(Contact): |
sanko@centrum.sk |
| Mobil(Cell): |
|
| Povolanie(Profession): |
Referent logistiky |
| Bicia súprava(Drums): |
Tama Swingstar |
| Snare: |
Tama Starclassic |
| Hardware: |
Tama |
| Činely(Cymbals): |
powerfull soundwave Hi-hat - Meinl Amun 14", medium crash Zildjian Z Custom 17", medium crash Zildjian Z3 19", ride Meinl headliner FX-9 20" , Zildjian Z Custom China 20" |
| Paličky(Sticks): |
Vater 5A, Ballbex 5A |
| Blany(Heads): |
EVANS |
| Elektronika(Electronics): |
....
|
| Doplnky(Accessories): |
|
| Hral(a) som v skupine(Band): |
... |
| Hrám v skupine(Band): |
Down By Order |
| O sebe(About me): |
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
| Foto(Photo): |
|
| Meno(Name): |
Peter Mikušek |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1991 |
| Kontakt(Contact): |
peter.mikusek@gmail.com |
| Mobil(Cell): |
|
| Povolanie(Profession): |
hudba |
| Bicia súprava(Drums): |
Tama Starclassic Maple
22"x16" BD
10"x7",12"x8" - rack toms
14"x14", 16"x16" floor toms
|
| Snare: |
Tama S.L.P. 14x8 steel |
| Hardware: |
TAMA/Gibraltar/DW |
| Činely(Cymbals): |
TRX |
| Paličky(Sticks): |
Vic Firth AH5B Maple |
| Blany(Heads): |
Evans Onyx - Toms, Evans EMAD2 - Bass Drum, Evans Genera HD - Snare |
| Elektronika(Electronics): |
- |
| Doplnky(Accessories): |
|
| Hral(a) som v skupine(Band): |
The Downhill, Allan Mikušek, Metropolis, NoControl, Beans & Bullets, MindStorm, Status Euphoria |
| Hrám v skupine(Band): |
Allan Mikušek |
| O sebe(About me): |
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
| Foto(Photo): |
|
| Meno(Name): |
Tomas Kolek |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1979 |
| Kontakt(Contact): |
email |
| Mobil(Cell): |
|
| Povolanie(Profession): |
súkr. |
| Bicia súprava(Drums): |
Pearl Vision |
| Snare: |
Pearl Reference brass snare |
| Hardware: |
Pearl hardware |
| Činely(Cymbals): |
Sabian |
| Paličky(Sticks): |
Vic Firth |
| Blany(Heads): |
Evans |
| Elektronika(Electronics): |
nie |
| Doplnky(Accessories): |
|
| Hral(a) som v skupine(Band): |
6SV, Rain |
| Hrám v skupine(Band): |
Darchaic |
| O sebe(About me): |
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
| Foto(Photo): |
|
| Meno(Name): |
Bálint Takács |
| Kraj(Country): |
Trnavský kraj |
| Rok narodenia(Birth): |
1986 |
| Kontakt(Contact): |
jazzhibition@gmail.com |
| Mobil(Cell): |
|
| Povolanie(Profession): |
Bubeník, učiteľ bicích |
| Bicia súprava(Drums): |
REMO Mastertouch 22"10"12"14"15"
Gretsch Catalina Club Jazz 18"12"14 |
| Snare: |
GRETSCH Renown Maple 14"x5,5" |
| Hardware: |
YAMAHA, Gibraltar |
| Činely(Cymbals): |
Zildjian 22" Consatntinople Medium Ride, 19" A Custom Crash, 17" K Custom Hybrid Crash, 20" A Custom China, 13,25" K Custom Hybrid H.H., 8" A Splash, 6" A Custo Splash, 10" Factory Metal Street EFX |
| Paličky(Sticks): |
Vic Firth American 5A |
| Blany(Heads): |
BD - PS Pro, PS3, PS3 Coated SD- Ambassador Coated/ Diplomat TT - Ambassador Clear/ Coated |
| Elektronika(Electronics): |
Roland Handsonic |
| Doplnky(Accessories): |
|
| Hral(a) som v skupine(Band): |
Tsunami Fusion Band, Blue Moon Trio, Trrr... Ghymes, Crash Blues Band |
| Hrám v skupine(Band): |
JVV https://www.facebook.com/jovilagvan |
| O sebe(About me): |
https://www.facebook.com/tsunamibalint
|
| Moja galéria(Gallery): |
|
| Moje video(Video): |
|
