Database error: DB Error: syntax error
On query:

SELECT *,
UNIX_TIMESTAMP(cc_date) cc_date,
(select count(*) from crm_course_customer where ccc_cc_id=cc_id) cc_amount,
( cc_places
-
(select count(*) from crm_course_customer where ccc_cc_id=cc_id)
-
(SELECT count(*) FROM crm_digital_applied_courses WHERE cc_digital_course_id=crm_digital_applied_courses.course_id AND (crm_digital_applied_courses.`status` = 'passed' OR crm_digital_applied_courses.`status` = 'open'))
) cc_freeplaces
FROM crm_course
LEFT JOIN crm_digital_courses ON crm_digital_courses.id = crm_course.cc_digital_course_id
WHERE cc_status='open'
AND cc_date > now()
ORDER BY cc_date LIMIT -19,19 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-19,19' at line 14]

Type cursus
Naam cursus Niet gesorteerd Datum Niet gesorteerd Plaatsen Niet gesorteerd Vrije plaatsen Niet gesorteerd
Pagina 0 van 6 »