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 'OR optr_dyn_cats.id = ) AND optr_dyn_cats.status = 'A' GROUP BY optr_dyn_cats...' at line 17

SELECT 
                    optr_dyn_cats.*,
                    optr_dyn_cats_assoc.pkt_id,
                    optr_dyn_cats_assoc.main_cat_id,
                    optr_dyn_cats_assoc.id AS assoc_id,
                    t_pt.value AS friendly_url_pt, t_eng.value AS friendly_url_eng
                FROM optr_dyn_cats
                LEFT JOIN optr_dyn_cats_assoc
                    ON optr_dyn_cats_assoc.main_cat_id = optr_dyn_cats.id
                LEFT JOIN optr_dyn_cats_translations t_pt
                            ON t_pt.id = optr_dyn_cats.id
                            AND t_pt.lang = 'PT'
                            AND t_pt.field = 'friendly_url' LEFT JOIN optr_dyn_cats_translations t_eng
                            ON t_eng.id = optr_dyn_cats.id
                            AND t_eng.lang = 'ENG'
                            AND t_eng.field = 'friendly_url'
                WHERE TRUE AND (optr_dyn_cats.related_id =  OR optr_dyn_cats.id = ) AND optr_dyn_cats.status = 'A' GROUP BY optr_dyn_cats.id ORDER BY optr_dyn_cats.order ASC 
-- /var/www/vhosts/optitravel.net/httpdocs/optitravel/online/www/layout54/destinations.php - getDynamicCategoriesAndPackages (7) >> /var/www/vhosts/optitravel.net/httpdocs/optitravel/includes/classes/apis/optipackage.inc.php - getDynCats (9125) >> /var/www/vhosts/optitravel.net/httpdocs/optitravel/includes/classes/apis/dyn_cats.inc.php - select (88) >> /var/www/vhosts/optitravel.net/httpdocs/optitravel/includes/classes/database/class_db_handler.php - __call (430) >> /var/www/vhosts/optitravel.net/httpdocs/optitravel/includes/classes/Core/Database/DB.php - GetArray (499)