SOULTONE CYMBALS IS SEARCHING FOR A DISTRIBUTOR IN SLOVAKIA!
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
Soultone
Soultone Cymbals is a major US brand of premium cymbals, founded in 2003. At this moment Soultone is available in 37 countries on 5 continents and continues to grow each day. And in 2019, Soultone Cymbals is searching for a new distributor in Slovakia! Are you our candidate? Then we would love to talk to you!
The new distributor will be the focal point of Soultone activity in Slovakia, and the provider of service and cymbals to all Slovakian endorsers and dealers. The candidate can be a company or individual of any age or experience in distributing a major international musical instrument brand. He or she must be willing to promote Soultone Cymbals exclusively, not in combination with any other cymbal brand. Good communication skills and a good working knowledge of the English language are a must, as the candidate will have to communicate with fellow distributors around Europe.
Do you think you are the right person for the job and would like to go on an adventure with us? Please send a message to Jeroen van Delft of Soultone Cymbals International at jeroen@soultonecymbals.com. We would love to hear from you!
www.soultonecymbals.com
