PHP : /homepages/37/d197077523/htdocs/www.vollspann.com/user/user_termin_liste.php
SQL-Statement :SELECT a.evdet_id,
Date_Format(from_unixtime(a.dtstart),'%w') as 'Wochentag',
Date_Format(from_unixtime(a.dtstart), '%d.%m.%Y') as 'StartDate',
Date_Format(from_unixtime(a.dtstart), '%Y%m%d') as 'StartDate1',
date_format(from_unixtime(a.dtstart), '%H:%i') as 'StartTime',
date_format(from_unixtime(a.dtstart), '%H%i') as 'StartTime1',
Date_Format(from_unixtime(a.dtend), '%d.%m.%Y') as 'EndDate',
a.location as 'Ort',
a.summary as 'Summary',
c.title as 'Team',
a.description,
a.extra_info
FROM
joomla_jevents_vevdetail as a,
joomla_jevents_catmap as b,
joomla_categories as c,
joomla_jevents_vevent as d
WHERE
c.Title in ( 'TVE 1', 'U23', 'Allgemein', 'TVE', 'AH', 'AH-Spiele', 'U19', 'U19-II', 'U18', 'U17', 'U16', 'U15', 'U14', 'U13', 'U12', 'U11', 'U10', 'U9', 'U8', 'U7' )
and c.id = b.catid
and b.evid = a.evdet_id
and a.evdet_id = d.ev_id
and d.state = 1
and a.dtstart > unix_timestamp(date_sub(now(),interval 5 day))
and a.dtstart < unix_timestamp(date_add(now(),interval 90 day)) order by a.dtstart
Zeile : 126 SQL-Row : AH Weihnachtsfeier im Fischer´s
Zeile : 177 Titel-Vergleich (Exclude) ->AH WEIHNACHTSFEIER IM FISCHER´S<-
=>AH WEIHNACHTS IM FISCHER´S<-
14.12.2024-20241214-14.12.2024
Zeile : 126 SQL-Row : Winterdörfle Schwabengarten
Zeile : 177 Titel-Vergleich (Exclude) ->WINTERDöRFLE SCHWABENGARTEN<-
=>WINTERDöRFLE SCHWABENGARTEN<-
27.12.2024-20241227-27.12.2024
| 14.12.20241800 | Sa. | 14.12.2024 | 18:00 Uhr | AH | | AH Weihnachtsfeier im Fischer´s | | | |
| 27.12.20241900 | Fr. | 27.12.2024 | 19:00 Uhr | AH | | Winterdörfle Schwabengarten | | | |
Array
(
[0] => 202412141800|Sa.|14.12.2024|18:00 Uhr|AH||AH Weihnachtsfeier im Fischer´s |||||||
[1] => 202412271900|Fr.|27.12.2024|19:00 Uhr|AH||Winterdörfle Schwabengarten |||||||
)