| 0.0011 |
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`='0' AND `titles`.`id`='789'
GROUP BY
`videos`.`category`
ORDER BY
`videos`.`category` ASC
LIMIT 1
|
| 0.0006 |
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` = '789'
|
| 0.0007 |
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` = '789'
ORDER BY
`videos`.`episode_num` + 0
|
| 0.0005 |
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` = '789';
|
| 0.0007 |
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` = '789' AND
`creditables`.`creditable_type` = 'title'
ORDER BY
`creditables`.`order` ASC
|
| 0.0017 |
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`='0' AND `titles`.`id`!='789' 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
|
