hi anyone can help me what are the query in this to show all ticket details like in picture
here's my query
Select Distinct ost_ticket.number As TicketNumber,
ost_user.name As Client,
ost_department.name As Departament,
ost_staff.username As Staff,
ost_ticket.created As Created,
ost_ticket.closed As ClosedDate,
ost_ticket_status.name AS Status,
ost_help_topic.topic As HelpTopics,
(Select ost_form_entry_values.value from ost_form_entry_values where field_id = '183') AS FieldValue1,
from ost_ticket
Join ost_staff On ost_staff.staff_id = ost_ticket.staff_id
Join ost_department On ost_ticket.dept_id = ost_department.id
Join ost_user_email On ost_ticket.user_id = ost_user_email.user_id
Join ost_user On ost_user_email.id = ost_user.id
Join ost_ticketcdata On ost_ticket.ticket_id = ost_ticketcdata.ticket_id
Join ost_ticket_status On ost_ticket.status_id = ost_ticket_status.id
Inner Join ost_help_topic On ost_ticket.topic_id = ost_help_topic.topic_id
LEft JOIN ost_form_entry On ost_ticket.ticket_id = ost_form_entry.object_id
LEFT JOIN ost_form_entry_values ON ost_form_entry_values.entry_id =ost_form_entry.id
WHERE ost_ticket.created BETWEEN '2019-03-11 00:00:01' AND '2019-05-31 23:59:59'
AND ost_help_topic.topic_id = '17';