Query failed: SELECT COUNT(c.kode_lowongan) AS code_lowongan, code, title, description, category, jenis_disable, post_date, b.name AS name, b.city AS city, b.province AS province FROM lowongan AS a LEFT JOIN company AS b ON a.id_company = b.id_company LEFT JOIN detail_lamaran as c ON a.code = c.kode_lowongan GROUP BY c.kode_lowongan WHERE a.status='Aktif' ORDER BY code_lowongan DESC