select `subtitles`.`language` as `language` from `series_subtitles` innerjoin `subtitles` on `series_subtitles`.`shortcode` = `subtitles`.`short_code` where `series_subtitles`.`episode_id` =98
select `series_genre`.`name` as `categories_name`, `series_genre`.`slug` as `categories_slug` from `series_genre` innerjoin `series_categories` on `series_categories`.`category_id` = `series_genre`.`id` where `series_categories`.`series_id` =15
select `series_categories`.`category_id` from `series` innerjoin `series_categories` on `series`.`id` = `series_categories`.`series_id` where `series`.`id` =15
select*from `series` innerjoin `series_categories` on `series`.`id` = `series_categories`.`series_id` where `series_categories`.`category_id` in (30) and `series`.`id` !=15and `series`.`active` =1groupby `series`.`id`