You could try something like thisSELECT tTicket.`ticket_id`, tTicket.`user_id`, tTicket.`status_id`, tTicket.`dept_id`, tTicket.`sla_id`, tTicket.`topic_id`, tTicket.`staff_id`, tTicket.`team_id`, tTicket.`email_id`, tTicket.`source`, tTicket.`isoverdue`, tTicket.`isanswered`, tTicket.`est_duedate`, tTicket.`closed`, tTicket.`created`, tField.`name`, tField.`label`, tValues.`value` FROM(SELECT * FROM `ost_ticket`) tTicketLEFT JOIN(SELECT * FROM `ost_form_entry` WHERE `object_type` = 'T') tEntriesON tTicket.`ticket_id` = tEntries.`object_id`LEFT JOIN(SELECT * FROM `ost_form_entry_values`) tValuesON tEntries.`id` = tValues.`entry_id`LEFT JOIN(SELECT * FROM `ost_form_field`) tFieldON tValues.`field_id` = tField.`id`