SELECT ktvs_videos.video_id, title as title, description 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 (20,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:09:53' and ktvs_videos.video_id in (0,12257,30806,43206,46562,43531,41515,11964,56322,43352,56165,56266,30649) order by rand() LIMIT 12