-Lists tickets for agent in a month that is open SELECT (SELECT CONCAT_WS(' ', `firstname`, `lastname`) AS name FROM ost_staff st WHERE st.staff_id = t.staff_id) AS agent, t.ticket_id, t.number, (SELECT name FROM ost_user u WHERE u.id = t.user_id) AS client, cd.subject, t.created, t.lastupdate FROM ost_ticket tLEFT JOIN ost_ticket__cdata cd ON t.ticket_id = cd.ticket_idLEFT JOIN ost_ticket_status ts ON ts.id = t.status_idWHERE ts.state= 'open' AND DATE_FORMAT(t.created,'%Y-%m') = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 1 MONTH), '%Y-%m') GROUP BY number ORDER BY `Agent`-List all Forms values for TicketsSELECT ticket.ticket_id,ticket.number,ticket.dept_id,val.field_id,form.title,formf.label, val.value,ticket.staff_id,user.name, dept.name as dept, status.state as status,ticket.source,ticket.isoverdue,ticket.isanswered,ticket.createdFROM ost_ticket ticketLEFT JOIN ost_ticket_status status ON status.id = ticket.status_id LEFT JOIN ost_user user ON user.id = ticket.user_id LEFT JOIN ost_department dept ON ticket.dept_id=dept.id LEFT JOIN ost_form_entry entry ON ticket.ticket_id = entry.id LEFT JOIN ost_form_entry_values val ON entry.id = val.entry_idLEFT JOIN ost_form form ON form.id = val.entry_idLEFT JOIN ost_form_field formf ON val.field_id = formf.id;