SELECT
   contacts.id AS 'contacts_id', 
   contacts.sex AS 'contacts_sex', 
   contacts.givenname AS 'contacts_givenname',
   contacts.surname AS 'contacts_surname', 
   contacts.company AS 'contacts_company',
   contacts.email AS 'contacts_email',
   contacts.phone AS 'contacts_phone', 
   contacts.fax AS 'contacts_fax', 
   contacts.ticket AS 'contacts_ticket', 
   contacts.position_id AS 'contacts_position_id',
   contacts.numofemployees_id AS 'contacts_numofemployees_id',
   contacts.contacttype_id AS 'contacts_contacttype_id',
   conversation.id AS 'conversation_id',
   conversation.contact_id AS 'conversation_contact_id',
   conversation.agent_id AS 'conversation_agent_id',
   conversation.inquiry AS 'conversation_inquiry',
   conversation.inquiry_time AS 'conversation_inquiry_time',
   conversation.inquiry_notification_sent AS 'conversation_inquiry_notification_sent',
   conversation.answer AS 'conversation_answer',
   conversation.answer_time AS 'conversation_answer_time',
   conversation.answer_notification_sent AS 'conversation_answer_notification_sent'
FROM
   jm_contact_contacts contacts 
LEFT JOIN
   jm_contact_conversation conversation
ON
   (contacts.id = conversation.contact_id) 
ORDER BY
   conversation.inquiry_time DESC