error db: 4885774SELECT a.id_ticket, a.id_parent, a.id_contact, a.id_kreator, a.id_operater, a.body, (SELECT subject FROM tickets WHERE id_ticket = a.id_parent) as subject, a.id_oblast, DATE_FORMAT(a.datum, '%d. %m. %y') as datum ,DATE_FORMAT(a.datum, '%H : %i') as sat , a.status,w.status as statusNaziv,(SELECT status FROM tickets WHERE id_parent = a.id_parent ORDER BY id_ticket DESC LIMIT 1) as statusPrikaz,(SELECT id_ticket FROM tickets WHERE id_parent = a.id_parent ORDER BY id_ticket DESC LIMIT 1) as idDraftTiket, DATEDIFF(NOW(),a.datum) as vremeCekanja, ( SELECT CASE WHEN qq.status IN (3,6,7,8,10) THEN 'U obradi' ELSE ww.status END FROM tickets qq JOIN tickets_statusi ww ON qq.status = ww.id_status WHERE qq.id_parent = a.id_parent ORDER BY qq.id_ticket DESC LIMIT 1 ) as statusNazivPrikaz ,(CASE WHEN a.id_kreator = 1 THEN (SELECT s.ime_prezime FROM ml_contacts s WHERE s.id_contact = a.id_contact) WHEN a.id_kreator = 2 THEN 'PKT' ELSE 'neodređeno' END) as kreator , c.username as operater ,d.naziv_firme, d.e_mail, d.ime_prezime ,(SELECT COUNT(*) FROM tickets e WHERE a.id_parent = e.id_parent) as cnt, (SELECT SUM(CASE WHEN t.status = 6 THEN 1 ELSE 0 END) FROM tickets t WHERE t.id_parent = a.id_ticket) as draftTicket FROM tickets a LEFT OUTER JOIN cms_user c ON a.id_operater = c.id_user JOIN ml_contacts d ON a.id_contact = d.id_contact and a.id_contact >0 AND d.id_contact >0 JOIN tickets_statusi w on a.status = w.id_status WHERE 1 AND a.status IN (1,2,10) AND a.id_contact IN (SELECT s.id_contact FROM ml_contacts s WHERE s.PIB = ) ORDER BY a.id_parent DESC, CASE WHEN a.id_ticket = a.id_parent THEN a.id_ticket END DESC, CASE WHEN a.id_ticket != a.id_parent THEN a.id_ticket END DESC