Valley National Administrative Services
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 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 -18000 SECOND AS event_start_site, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL -18000 SECOND AS event_end_site, tz.name as timezone_name FROM node n INNER JOIN event e ON n.nid = e.nid INNER JOIN event_timezones tz ON tz.timezone = e.timezone WHERE n.status = 1 AND ((e.event_start >= '2025-12-05 00:00:00' AND e.event_start <= '2026-01-06 00:00:00') OR (e.event_end >= '2025-12-05 00:00:00' AND e.event_end <= '2026-01-06 00:00:00') OR (e.event_start <= '2025-12-05 00:00:00' AND e.event_end >= '2026-01-06 00:00:00')) GROUP BY n.nid HAVING (event_start >= '2025-12-06 00:00:00' AND event_start <= '2026-01-05 00:00:00') OR (event_end >= '2025-12-06 00:00:00' AND event_end <= '2026-01-05 00:00:00') OR (event_start <= '2025-12-06 00:00:00' AND event_end >= '2026-01-05 00:00:00') ORDER BY event_start ASC in /home/mwpay/public_html/vnascaptive.com/sites/all/modules/event/event_database.mysqli.inc on line 105.
Valley National Administrative Services (VNAS) is geared to meet the needs of our clients and their owners. Our leading insurance industry expertise and captive specialization enables our professionals to focus on helping you resolve your business issues. We can offer constructive, objective and independent advice.
Our team of professionals can help you to identify business risks and work to maximize opportunities and mitigate challenges associated with them. We have excellent working relationships with all parties necessary to affect a successful captive insurance company.
We can help make captive insurance – Adjustable Adaptable Accessible – for you.
