| 0.0003 |
SELECT
CONCAT('', GROUP_CONCAT(DISTINCT CONCAT('', `videos`.`language`, '')), '') as `langs`,
CONCAT('', GROUP_CONCAT(DISTINCT CONCAT('', `videos`.`category`, '')), '') as `cats`,
`videos`.`category`,
`titles`.*
FROM
`titles`
LEFT JOIN `videos`
ON `videos`.`title_id`=`titles`.`id`
WHERE
`titles`.`is_series`='1' AND `titles`.`id`='243'
GROUP BY
`videos`.`category`
ORDER BY
`videos`.`category` ASC
LIMIT 1
|
| 0.0002 |
SELECT
`genres`.`id`,
`genres`.`name`,
`genres`.`display_name`
FROM
`genre_title`
LEFT JOIN `genres`
ON `genre_title`.`genre_id`=`genres`.`id`
WHERE
`genre_title`.`title_id` = '243'
|
| 0.0002 |
SELECT
`seasons`.`id`,
`seasons`.`number`,
`seasons`.`updated_at`
FROM
`seasons`
LEFT JOIN
`videos`
ON `seasons`.`title_id`=`videos`.`title_id`
WHERE
`seasons`.`title_id` = '243' AND `seasons`.`number`=`videos`.`season_num`
GROUP BY `seasons`.`number`
|
| 0.0002 |
SELECT
`videos`.`id`,
`videos`.`src`,
`videos`.`type`,
`videos`.`quality`,
`videos`.`season_num`,
`videos`.`episode_num`,
`videos`.`type`,
`videos`.`approved`,
`videos`.`language`,
`videos`.`category`
FROM
`videos`
LEFT JOIN `titles`
ON `videos`.`title_id`=`titles`.`id`
WHERE
`titles`.`id` = '243'
ORDER BY
`videos`.`episode_num` + 0
|
| 0.0002 |
SELECT
`country_title`.`production_country_id` as `id`,
`production_countries`.`display_name`,
`production_countries`.`name`
FROM
`country_title`
LEFT JOIN `production_countries` ON
`country_title`.`production_country_id`=`production_countries`.`id`
WHERE
`country_title`.`title_id` = '243';
|
| 0.0002 |
SELECT
`people`.`id`,
`people`.`name`,
`people`.`poster`,
`people`.`known_for`,
`people`.`gender`,
`creditables`.`department`,
`creditables`.`job`,
`creditables`.`order`,
`creditables`.`character`
FROM
`creditables`
LEFT JOIN `people`
ON `creditables`.`person_id`=`people`.`id`
WHERE
`creditables`.`creditable_id` = '243' AND
`creditables`.`creditable_type` = 'title'
ORDER BY
`creditables`.`order` ASC
|
| 0.0018 |
SELECT
CONCAT('', GROUP_CONCAT(DISTINCT CONCAT('', `videos`.`language`, '')), '') as `langs`,
`titles`.`id`,
`titles`.`name`,
`titles`.`original_title`,
`titles`.`tmdb_vote_average`,
DATE_FORMAT(`release_date`, '%Y') as `year`,
`titles`.`poster`,
`titles`.`backdrop`,
`titles`.`imdb_id`,
`titles`.`tmdb_id`,
`videos`.`season_num` as `season_count`,
`videos`.`episode_num` as `episode_count`,
`titles`.`certification`,
`titles`.`language` as translation,
`titles`.`is_series`,
`videos`.`language`
FROM
`titles`
LEFT JOIN `videos`
ON `videos`.`title_id`=`titles`.`id`
LEFT JOIN `taggables`
ON `titles`.`id`=`taggables`.`taggable_id`
LEFT JOIN `tags`
ON `taggables`.`tag_id`=`tags`.`id`
WHERE
`titles`.`is_series`='1' AND `titles`.`id`!='243' AND `tags`.`type`='genre' AND `titles`.`name` LIKE CONCAT('%', `titles`.`name` ,'%')
GROUP BY
`titles`.`id`
HAVING
`videos`.`language` IS NOT NULL
ORDER BY
RAND()
LIMIT 8
|
