Consulta con UNIXTIME en SELECT

[unlocktools]

Si lo pongo asi:

Código MySQL:

SELECT  FROM_UNIXTIME(UNIX_TIMESTAMP(), '%Y %D %M %h:%i:%s %x'), jad6s_rsticketspro_tickets.id, jad6s_rsticketspro_tickets.date, jad6s_rsticketspro_tickets.code, jad6s_rsticketspro_tickets.status_id, jad6s_rsticketspro_custom_fields_values.value, jad6s_rsticketspro_ticket_messages.message, jad6s_rsticketspro_tickets.subject, jad6s_rsticketspro_ticket_notes.text
from jad6s_rsticketspro_tickets, jad6s_rsticketspro_custom_fields_values, jad6s_rsticketspro_ticket_messages, jad6s_rsticketspro_ticket_notes
where jad6s_rsticketspro_tickets.id = jad6s_rsticketspro_custom_fields_values.ticket_id
and jad6s_rsticketspro_tickets.id = jad6s_rsticketspro_ticket_messages.ticket_id
and jad6s_rsticketspro_tickets.id = jad6s_rsticketspro_ticket_notes.ticket_id
GROUP BY jad6s_rsticketspro_tickets.code
ORDER BY jad6s_rsticketspro_tickets.id DESC
 

me arroja la fecha actual delante de cada registro, pero la columna date sigue igual.
Si lo coloco asi:

Código MySQL:

SELECT jad6s_rsticketspro_tickets.id, FROM_UNIXTIME(UNIX_TIMESTAMP(jad6s_rsticketspro_tickets.date), '%Y %D %M %h:%i:%s %x'), jad6s_rsticketspro_tickets.code, jad6s_rsticketspro_tickets.status_id, jad6s_rsticketspro_custom_fields_values.value, jad6s_rsticketspro_ticket_messages.message, jad6s_rsticketspro_tickets.subject, jad6s_rsticketspro_ticket_notes.text
from jad6s_rsticketspro_tickets, jad6s_rsticketspro_custom_fields_values, jad6s_rsticketspro_ticket_messages, jad6s_rsticketspro_ticket_notes
where jad6s_rsticketspro_tickets.id = jad6s_rsticketspro_custom_fields_values.ticket_id
and jad6s_rsticketspro_tickets.id = jad6s_rsticketspro_ticket_messages.ticket_id
and jad6s_rsticketspro_tickets.id = jad6s_rsticketspro_ticket_notes.ticket_id
GROUP BY jad6s_rsticketspro_tickets.code
ORDER BY jad6s_rsticketspro_tickets.id DESC
 

me arroja al principio en cada registro : 1970 1st January 01:00:00 1970