class.mysql.php : 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY RAND() LIMIT 4' at line 1 - SELECT ogl.id, ogl.ident, ogl.title, ogl.category, ogl.city, ogl.city_rw, ogl.country, ogl.cost, ogl.cost_notice, ogl.cost_currency, ogl.for_free, ogl.status, ogl.display, ogl.forever, ogl.urgent, ogl.create_date, ogl.whole_country, ogl.company_id, pay.pay_expire AS view_till, pay_promoted.pay_expire AS promoted_till, (SELECT GROUP_CONCAT(ph.photo_filename ORDER BY ph.photo_main = 'YES' DESC) FROM oglo2_announcement_photos AS ph WHERE ph.photo_announcement_id = ogl.id) AS photos FROM oglo2_announcement AS ogl LEFT JOIN oglo2_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' INNER JOIN oglo2_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' AND pay_promoted.pay_expire >= NOW() LEFT JOIN oglo2_company AS comp ON (comp.company_id = ogl.company_id AND comp.company_uid > 0) WHERE (ogl.status='ACCEPT' OR ogl.status='NOT_CONFIRMED') AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-07-09' OR pay.pay_create <= '2025-07-04' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-07-09') OR ogl.forever = 'TRUE') AND ogl.category IN () ORDER BY RAND() LIMIT 4