Consulta con UNIXTIME en SELECT

[unlocktools]

Gracias, finalmente lo consegui asi :

Código MySQL:

SELECT  jad6s_rsticketspro_tickets.id, FROM_UNIXTIME(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
 

Gracias por tu ayuda.