Select vm.video_id,video_random_id,video_name,video_name_home,video_url,video_story_label,video_description,video_page_title,video_keywords,video_tags,category_id,(select cm.category_master_name from category_master cm where cm.category_master_id=vm.category_id and cm.active='Y') as category_name,sub_category_id,(select scm.sub_category_master_name from sub_category_master scm where scm.sub_category_master_id=vm.sub_category_id and scm.active='Y') as sub_category_name,video_tags1,admin_name,admin_name1,video_date,video_time_r,video_date1,video_time,video_epoch,video_image,video_image1,video_image2,video_localities,video_youtube_id,video_file_name_mp4 from video_master vm where vm.video_id=1071324 and vm.active='Y'
