Výsledky ankety časopisu Modern Drummer

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-03-31 00:00:00' AND e.event_start <= '2024-05-01 23:59:59') OR (e.event_end >= '2024-03-31 00:00:00' AND e.event_end <= '2024-05-01 23:59:59') OR (e.event_start <= '2024-03-31 00:00:00' AND e.event_end >= '2024-05-01 23:59:59')) ) GROUP BY n.nid HAVING (event_start >= '2024-04-01 00:00:00' AND event_start <= '2024-04-30 23:59:59') OR (event_end >= '2024-04-01 00:00:00' AND event_end <= '2024-04-30 23:59:59') OR (event_start <= '2024-04-01 00:00:00' AND event_end >= '2024-04-30 23:59:59') ORDER BY event_start ASC in /home/do1741500/www_root/includes/database.mysql.inc on line 174.

Vložil(a) julius.petrus

Výuka

Ak chcete pridať komentáre, tak sa musíte prihlásiť alebo zaregistrovať.

Anketa Modern Drummer

Rovnako ako aj predchádzajúce roky, prestížny americký časopis Modern Drummer, vyhlásil koncom roka 2018 anketu v ktorej si čitatelia mohli zvoliť svojho najobľúbenejšieho bubeníka/čku. Anketa bola rozdelená na jednotlivé hudobné štýly a źánre pričom čitatelia mohli voliť cez internet, alebo odoslaním vyplneného formulára. Výsledky budú publikované v aprílovom čísle časopisu. Tento rok do siene slávy vstúpil Dave Grohl.

Tu sú výsledky

SIEŇ SLÁVY
Dave Grohl

ŠTÚDIO
1. Matt Chamberlain
2. Aaron Sterling
3. Nir Z
4. Blair Sinta
5. Fred Eltringham

KLASICKÝ ROCK
1. Todd Sucherman
2. Mick Fleetwood
3. Nick Mason
4. Tico Torres
5. Russ Kunkel

MODERNÝ ROCK
1. Taylor Hawkins
2. Jean-Paul Gaster
3. Jeff Friedl
4. Arejay Hale
5. Hayley Cramer

EXPERIMENTÁLNY ROCK
1. Matt Johnson
2. Kris Myers
3. Jason McGerr
4. Lia Braswell
5. Chris Bear

METAL
1. Chris Adler
2. Gene Hoglan
3. Aaron Gillespie
4. Blake Richardson
5. Brann Dailor

PROGRESÍVNY ROCK
1. Gavin Harrison
2. Mike Mangini
3. Carl Palmer
4. Virgil Donati
5. Nick D'Virgilio

R&B/FUNK/HIP-HOP
1. Nate Smith
2. Sonny Emory
3. Adam Deitch
4. Eric "Boots" Greene
5. Tony "Rico" Nichols

KLASICKÝ JAZZ
1. Jack DeJohnette
2. Brian Blade
3. Ulysses Owens Jr.
4. Mike Clark
5. Matt Wilson

MODERNÝ JAZZ
1. Antonio Sanchez
2. Eric Harland
3. Marcus Gilmore
4. Jonathan Barber
5. Dafnis Prieto

FUSION
1. Simon Phillips
2. Nate Smith
3. Gergo Borlai
4. Zach Danziger
5. Michael Mitchell

POP
1. Tony Royster Jr.
2. Eric Hernandez
3. Mark Schulman
4. Drew Shoals
5. Karl Brazil

COUNTRY
1. Rich Redmond
2. Lisa Pankratz
3. Travis McNabb
4. Keio Stroud
5. Seth Rausch

OBJAV ROKA
1. Max Portnoy
2. Jimmy Macbride
3. Jamison Ross
4. Marian Li-Pino
5. Booker Stardrum

WORLD MUSIC
1. Kiko Freitas
2. Bobby Sanabria
3. Courtney Diedrick
4. Barrett Martin
5. Ranjit Barot

KLINIKY/VZDELÁVANIE
1. Benny Greb
2. Anika Nilles
3. Aaron Spears
4. Mark Walker
5. Dana Hall

NAJLEPŠÍ INŠTRUKTÁŽNY PRODUKT
1. Aaron Sterling, Sounds of Sterloid Vol. II (online master class)
2. Jost Nickel, Jost Nickel's Fill Book
3. Gregory "Torch" Sgrulloni, Trap Style Drumming (book)
4. Mark Colenburg, The Beat Matrix Unlocked (book)
5. Claus Hessler, Camp Duty Update (book)

NAJLEPŠIA NAHRÁVKA:
1. Steve Gadd, Chinese Butterfly (The Chick Corea and Steve Gadd Band)
2. Elvin Jones, Both Directions at Once (John Coltrane)
3. Nate Smith, The Fearless Flyers (The Fearless Flyers)
4. Brann Dailor, Emperor of Sand (Mastodon)
5. Jean-Paul Gaster, Book of Bad Decisions (Clutch)

Po	Ut	St	Št	Pi	So	Ne
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30

slovakdrummers.sk

Výsledky ankety časopisu Modern Drummer

Zaregistrujte sa

Prihlásenie

Najbližšie akcie

Akcie / koncerty