SELECT TM_calls. * , x.last
FROM TM_calls
LEFT JOIN (

SELECT TM_calls.id AS cid, TM_calls_stati_zo.status AS last
FROM TM_calls
LEFT JOIN TM_calls_stati_zo 
ON TM_calls.id = TM_calls_stati_zo.call
LIMIT 1 , 1
ORDER BY TM_calls_stati_zo.timestamp DESC

) AS x ON x.cid = TM_calls.id

id | name | status
1 | test1 | 5
2 | test2 | 4
3 | test2 | 5

id | call | status | timestamp 
1 | 1 | 4 | 20070428
2 | 1 | 5 | 20070501
3 | 2 | 4 | 20070502
4 | 3 | 2 | 20070503
5 | 3 | 3 | 20070504
6 | 3 | 5 | 20070505

SELECT c.*, s.call AS lastState
FROM TM_calls AS c
LEFT JOIN (SELECT s.status FROM TM_calls_stati_zo AS s WHERE c.id = s.call ORDER BY s.timestamp DESC LIMIT 1, 1)

SELECT c. * , temp.last AS lastState
FROM TM_calls AS c
LEFT JOIN (

SELECT s.call, s.status AS last
FROM TM_calls_stati_zo AS s
WHERE c.id = s.call
ORDER BY s.timestamp DESC
LIMIT 1 , 1
) AS temp ON c.id = temp.call

SELECT
	TM_calls.*,
	neu.last
FROM
	TM_calls
LEFT JOIN
	(
SELECT
	status AS last,
	`call`
FROM
	TM_calls_stati_zo AS orig
LEFT JOIN
	(
SELECT
	`call` AS cid,
	MAX(timestamp) AS ts
FROM
	TM_calls_stati_zo
GROUP BY
	`call`
ORDER BY
	`call`) AS temp
	ON
		orig.CALL = cid
ORDER BY
	orig.`call`,
	(timestamp = ts) ASC,
	timestamp DESC ) AS neu
	ON
		TM_calls.id = neu.`call`
GROUP BY
	`call`

SELECT
	TM_calls.*,
	IF(neu.last = status , NULL , neu.last) AS 'vorheriger Status' 
FROM
	TM_calls
LEFT JOIN
	(
SELECT
	status AS last,
	`call`
FROM
	TM_calls_stati_zo AS orig
LEFT JOIN
	(
SELECT
	`call` AS cid,
	MAX(timestamp) AS ts
FROM
	TM_calls_stati_zo
GROUP BY
	`call`
ORDER BY
	`call`) AS temp
	ON
		orig.CALL = cid
ORDER BY
	orig.`call`,
	(timestamp = ts) ASC,
	timestamp DESC ) AS neu
	ON
		TM_calls.id = neu.`call`
GROUP BY
	`call`

SELECT 
  DATE_FORMAT(FROM_UNIXTIME(TM_calls.timestamp),'%Y-%m-%d') AS eingetragen,
  TM_kunden.firma AS 'Firma',
  TM_kunden.stadt AS 'Stadt',
  TM_fehler.text AS 'Fehlerart',
  TM_calls.headline AS 'Überschrift',
  TM_calls.fehler AS 'Fehlerbeschreibung',
  TM_calls.loesung AS 'Lösung',
  TM_calls.prod AS 'bestellte Produkte',
  TM_calls_stati.text AS 'Status',
  IF(sub.zstat = TM_calls.status,NULL,sub.stat) AS 'vorheriger Status'
FROM TM_calls
LEFT JOIN TM_kunden ON TM_kunden.id = TM_calls.kunde
LEFT JOIN TM_fehler ON TM_fehler.id = TM_calls.fehlerart
LEFT JOIN TM_calls_stati ON TM_calls_stati.id = TM_calls.status
LEFT JOIN (
SELECT 
   TM_calls.id AS callid, 
   stati.text AS stat, 
   last AS zstat
FROM 
   TM_calls 
LEFT JOIN 
   ( 
SELECT 
   status AS last, 
   `call` 
FROM 
   TM_calls_stati_zo AS orig 
LEFT JOIN 
   ( 
SELECT 
   `call` AS cid, 
   MAX(timestamp) AS ts 
FROM 
   TM_calls_stati_zo 
GROUP BY 
   `call` 
ORDER BY 
   `call`) AS temp 
   ON 
      orig.CALL = cid 
ORDER BY 
   orig.`call`, 
   (timestamp = ts) ASC, 
   timestamp DESC ) AS neu 
   ON 
      TM_calls.id = neu.`call` 
LEFT JOIN `TM_calls_stati` AS stati ON neu.last = stati.id
GROUP BY 
   `call` 
) AS sub ON TM_calls.id = sub.callid
ORDER BY TM_calls.timestamp DESC