concat the output of the subquery? August 29, 2023 by Tarik This is what group_concat does. select group_concat(id) as video_list from videos where duration=0