Error : 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 L_price asc' at line 1

SELECT distinct (`program_id`),`L_price` FROM sama.mt_program_cache_prices WHERE `program_id` in() order by L_price asc
in