sqlite3 to obtain the filenames of selected images (over 5K)

Dear all,

I would like to obtain the filenames of ~5,300 selected images after CTF estimation, but when typed like below using sqlite3

select filename from image_assets, image_group_1 where image_assets.image_asset_id = image_group_1.image_asset_id;

a partial list is only obtained and all ~5,300 filenames are not shown (most probably due to display limit in the shell?). I shall be most grateful if any of you happen to advise me how to figure this out.

Thank you in advance.

John

=== Never mind. Just figured this out and unlocked the scrolling limit. John ===