Činely

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-10-31 00:00:00' AND e.event_start <= '2024-12-01 23:59:59') OR (e.event_end >= '2024-10-31 00:00:00' AND e.event_end <= '2024-12-01 23:59:59') OR (e.event_start <= '2024-10-31 00:00:00' AND e.event_end >= '2024-12-01 23:59:59')) ) GROUP BY n.nid HAVING (event_start >= '2024-11-01 00:00:00' AND event_start <= '2024-11-30 23:59:59') OR (event_end >= '2024-11-01 00:00:00' AND event_end <= '2024-11-30 23:59:59') OR (event_start <= '2024-11-01 00:00:00' AND event_end >= '2024-11-30 23:59:59') ORDER BY event_start ASC in /home/dx040700/www_root/includes/database.mysql.inc on line 174.
 TémyOdpovedeViewsAutorPosledný príspevok
Anatolian Cymbals
0
0 by Martin Vajgl
23/07/2011 - 13:55
nie je
Aké používať činely
8
0 by julius.petrus
04/11/2009 - 14:06
by germo
19/10/2010 - 09:06
Nie sú nové príspevky
Nie sú nové príspevky
Nové príspevky
Nové príspevky
Horúca téma (nie sú nové príspevky)
Horúca téma (nie sú nové príspevky)
Horúca téma (nové príspevky)
Horúca téma (nové príspevky)
Vybrané témy
Vybrané témy
Uzavreté témy
Uzavreté témy
Syndikovať obsah