l.title AS l_title,
l.latitude AS l_latitude,
l.longitude AS l_longitude,
l.title AS l_title,
l.latitude AS l_latitude,
l.longitude AS l_longitude,
->addScalarResult('l_city', 'l_city', 'string')
->addScalarResult('l_latitude', 'l_latitude', 'float')
->addScalarResult('l_longitude', 'l_longitude', 'float')
->addScalarResult('l_city', 'l_city', 'string')
->addScalarResult('l_latitude', 'l_latitude', 'float')
->addScalarResult('l_longitude', 'l_longitude', 'float')
->addScalarResult('l_title', 'l_title', 'string')
->addScalarResult('t_id', 't_id', 'integer')
->addScalarResult('t_title', 't_title', 'string')
->addScalarResult('l_title', 'l_title', 'string')
->addScalarResult('t_id', 't_id', 'integer')
->addScalarResult('t_title', 't_title', 'string')
->addScalarResult('p_description', 'p_description', 'string')
->addScalarResult('p_class', 'p_class', 'string')
->addScalarResult('p_short', 'p_short', 'string')
->addScalarResult('p_description', 'p_description', 'string')
->addScalarResult('p_class', 'p_class', 'string')
->addScalarResult('p_short', 'p_short', 'string')
->addScalarResult('p_rate', 'p_rate', 'integer')
->addScalarResult('p_contact', 'p_contact', 'string')
->addScalarResult('p_donate', 'p_donate', 'string')
->addScalarResult('p_rate', 'p_rate', 'integer')
->addScalarResult('p_contact', 'p_contact', 'string')
->addScalarResult('p_donate', 'p_donate', 'string')
->addScalarResult('created', 'created', 'datetime')
->addScalarResult('updated', 'updated', 'datetime')
->addScalarResult('l_id', 'l_id', 'integer')
->addScalarResult('created', 'created', 'datetime')
->addScalarResult('updated', 'updated', 'datetime')
->addScalarResult('l_id', 'l_id', 'integer')
->addScalarResult('l_title', 'l_title', 'string')
->addScalarResult('l_address', 'l_address', 'string')
->addScalarResult('l_zipcode', 'l_zipcode', 'string')
->addScalarResult('l_title', 'l_title', 'string')
->addScalarResult('l_address', 'l_address', 'string')
->addScalarResult('l_zipcode', 'l_zipcode', 'string')
ADDDATE(ADDTIME(s.date, s.begin), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS start,
ADDDATE(ADDTIME(ADDTIME(s.date, s.begin), s.length), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS stop,
s.location_id AS l_id,
ADDDATE(ADDTIME(s.date, s.begin), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS start,
ADDDATE(ADDTIME(ADDTIME(s.date, s.begin), s.length), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS stop,
s.location_id AS l_id,
->addScalarResult('t_id', 't_id', 'integer')
->addScalarResult('t_title', 't_title', 'string')
->addScalarResult('l_id', 'l_id', 'integer')
->addScalarResult('t_id', 't_id', 'integer')
->addScalarResult('t_title', 't_title', 'string')
->addScalarResult('l_id', 'l_id', 'integer')
->addScalarResult('l_title', 'l_title', 'string')
->addScalarResult('a_id', 'a_id', 'integer')
->addScalarResult('a_canceled', 'a_canceled', 'datetime')
->addScalarResult('l_title', 'l_title', 'string')
->addScalarResult('a_id', 'a_id', 'integer')
->addScalarResult('a_canceled', 'a_canceled', 'datetime')
'id' => $session['id'],
'start' => $session['start'],
'stop' => $session['stop'],
'id' => $session['id'],
'start' => $session['start'],
'stop' => $session['stop'],
'pseudonym' => $pseudonym,
'class' => $class,
'slot' => self::GLYPHS[$session['t_title']],
'pseudonym' => $pseudonym,
'class' => $class,
'slot' => self::GLYPHS[$session['t_title']],
ADDDATE(ADDTIME(s.date, s.begin), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS start,
ADDDATE(ADDTIME(ADDTIME(s.date, s.begin), s.length), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS stop,
s.location_id AS l_id,
ADDDATE(ADDTIME(s.date, s.begin), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS start,
ADDDATE(ADDTIME(ADDTIME(s.date, s.begin), s.length), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS stop,
s.location_id AS l_id,
->addScalarResult('t_id', 't_id', 'integer')
->addScalarResult('t_title', 't_title', 'string')
->addScalarResult('l_id', 'l_id', 'integer')
->addScalarResult('t_id', 't_id', 'integer')
->addScalarResult('t_title', 't_title', 'string')
->addScalarResult('l_id', 'l_id', 'integer')
->addScalarResult('l_title', 'l_title', 'string')
->addScalarResult('a_id', 'a_id', 'integer')
->addScalarResult('au_id', 'au_id', 'integer')
->addScalarResult('l_title', 'l_title', 'string')
->addScalarResult('a_id', 'a_id', 'integer')
->addScalarResult('au_id', 'au_id', 'integer')
'id' => $session['id'],
'start' => $session['start'],
'stop' => $session['stop'],
'id' => $session['id'],
'start' => $session['start'],
'stop' => $session['stop'],
'pseudonym' => $pseudonym,
'class' => $class,
'slot' => self::GLYPHS[$session['t_title']],
'pseudonym' => $pseudonym,
'class' => $class,
'slot' => self::GLYPHS[$session['t_title']],