File manager - Edit - /home/autoph/public_html/tasks/db/queries/read_ticket_replies.sql
Back
SELECT tr.id,tr.ticket_id,t.user_id as owner_id,u.id as from_user,u.firstname,u.lastname,tr.description,ts.name as ticket_status, IF(DATE_FORMAT(tr.date_added,'%Y') = DATE_FORMAT(NOW(),'%Y') , DATE_FORMAT(tr.date_added,'%b. %d - %h:%i%p'),DATE_FORMAT(tr.date_added,'%b %d, %Y %h:%i%p')) as date_addedf FROM ticket_replies tr LEFT OUTER JOIN tickets t ON tr.ticket_id = t.id LEFT OUTER JOIN users u ON tr.user_id = u.id LEFT OUTER JOIN ticket_status ts ON tr.ticket_status_id = ts.id WHERE 1 AND tr.ticket_id = 86 AND tr.status = 1 ORDER BY tr.date_added DESC
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings