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 bdate' at line 1
SELECT id,bdate,duration,title,synopsis FROM `broadcasts` WHERE bdate LIKE '1972-11-28%' AND service= ORDER BY bdate