[HaBo]

SELECT t.id, t.title, t.project, p.prio_name, t.deadline, s.status_name
FROM ticket t, prio p, status s
WHERE t.priority = p.prio_id
AND t.status = s.status_id
AND t.id IN
(SELECT ticket_id FROM user_ticket WHERE user_id = '".$userID."' AND intern = '".$intern."');

select a.*, b.* from Tabelle1 a, Anderedatenbank.Tabelle2 b WHERE ...

SELECT FROM_UNIXTIME(datum, '%d.%m.%Y') from tabelle ...

sprintf('SELECT t.id, t.title, t.project, p.prio_name, t.deadline, s.status_name
FROM ticket AS t
JOIN prio AS p
ON t.priority = p.prio_id
JOIN status AS s
ON t.status = s.status_id
WHERE t.id IN
(SELECT ticket_id FROM user_ticket WHERE user_id = %d AND intern = %d);', $userID, $intern);

SELECT t.id, t.title, FROM_UNIXTIME(t.create_date, '%d.%m.%Y') as create_date, t.description, t.media, FROM_UNIXTIME(t.deadline, '%d.%m.%Y') as deadline, p.priority_name, s.status_name, k.projektname,ku.vname, ku.nname
FROM ticket AS t
JOIN priority AS p ON t.priority = p.id
JOIN status AS s ON t.status = s.id
JOIN db2.projekte AS k ON t.project = k.id
JOIN db2.ansprechpartner AS ku ON user.ap_id = ku.id
WHERE t.id = '3'

SELECT t.id, t.title, FROM_UNIXTIME(t.create_date, '%d.%m.%Y') as create_date, t.description, t.media, FROM_UNIXTIME(t.deadline, '%d.%m.%Y') as deadline, p.priority_name, s.status_name, k.projektname,ku.vname, ku.nname
FROM ticket AS t, user AS u
JOIN priority AS p ON t.priority = p.id
JOIN status AS s ON t.status = s.id
JOIN db2.projekte AS k ON t.project = k.id
JOIN db2.ansprechpartner AS ku ON u.ap_id = ku.id
WHERE t.id = '3'

....
FROM ticket AS T LEFT JOIN user ON