SELECT ktvs_videos.video_id, (case when title_ja<>'' then title_ja else title end) as title, (case when description_ja<>'' then description_ja else description end) as description, dir as dir, server_group_id, load_type_id, user_id, content_source_id, dvd_id, status_id, is_hd, is_private, access_level_id, is_locked, duration, file_formats, file_size, file_dimensions, file_url, pseudo_url, screen_amount, screen_main, screen_main_temp, poster_amount, poster_main, embed, delete_reason, (rating/rating_amount) as rating, rating_amount, video_viewed, video_viewed_player, video_viewed_unique, video_viewed_paid, embed_viewed, embed_viewed_unique, embed_viewed_paid, comments_count, favourites_count, purchases_count, tokens_required, release_year, post_date as post_date, last_time_view_date, added_date, rs_completed, admin_flag_id, af_custom1, af_custom2, af_custom3, custom1, custom2, custom3, gallery_url, is_review_needed from ktvs_videos inner join (select distinct video_id from ktvs_categories_videos where category_id in (1)) table1 on table1.video_id=ktvs_videos.video_id where ktvs_videos.status_id=1 and ktvs_videos.relative_post_date<=10000 and ktvs_videos.post_date<='2024-05-08 17:10:04' and ktvs_videos.video_id in (0,48065,48811,48688,44570,12336,9609,41657,43993,11011,1501,1410,52340) order by rand() LIMIT 12