| 0.0010 |
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`='2017'
GROUP BY
`videos`.`category`
ORDER BY
`videos`.`category` ASC
LIMIT 1
|
| 0.0007 |
SELECT
`tags`.`id`,
`tags`.`name`,
`tags`.`display_name`
FROM
`taggables`
LEFT JOIN `tags`
ON `taggables`.`tag_id`=`tags`.`id`
WHERE
`taggable_id` = '2017' AND
`tags`.`type` = 'genre'
|
| 0.0005 |
SELECT
`videos`.`id`,
`videos`.`url`,
`videos`.`type`,
`videos`.`quality`,
`videos`.`season_num`,
`videos`.`episode_num`,
`videos`.`source`,
`videos`.`approved`,
`videos`.`language`,
`videos`.`category`
FROM
`videos`
LEFT JOIN `titles`
ON `videos`.`title_id`=`titles`.`id`
WHERE
`titles`.`id` = '2017'
ORDER BY
`videos`.`episode_num` + 0
|
| 0.0005 |
SELECT
`videos`.`id`,
`videos`.`url`,
`videos`.`type`,
`videos`.`quality`,
`videos`.`season_num`,
`videos`.`episode_num`,
`videos`.`source`,
`videos`.`approved`,
`videos`.`language`,
`videos`.`category`
FROM
`videos`
LEFT JOIN `titles`
ON `videos`.`title_id`=`titles`.`id`
WHERE
`titles`.`id` = '2017' AND `videos`.`category`='full'
ORDER BY
`videos`.`episode_num` + 0, `videos`.`language` ASC
LIMIT 1
|
| 0.0009 |
SELECT
`tags`.`id`,
`tags`.`name`,
`tags`.`display_name`
FROM
`taggables`
LEFT JOIN `tags`
ON `taggables`.`tag_id`=`tags`.`id`
WHERE
`taggable_id` = '2017' AND
`tags`.`type` = 'keyword' AND
`tags`.`prod` = 'networks'
|
| 0.0006 |
SELECT
`tags`.`id`,
`tags`.`name`,
`tags`.`display_name`
FROM
`taggables`
LEFT JOIN `tags`
ON `taggables`.`tag_id`=`tags`.`id`
WHERE
`taggable_id` = '2017' AND
`tags`.`type` = 'keyword' AND
`tags`.`prod` = 'companies'
|
| 0.0005 |
SELECT
`tags`.`id`,
`tags`.`name`,
`tags`.`display_name`
FROM
`taggables`
LEFT JOIN `tags`
ON `taggables`.`tag_id`=`tags`.`id`
WHERE
`taggable_id` = '2017' AND
`tags`.`type` = 'production_country'
|
| 0.0062 |
SELECT
`people`.`id`,
`people`.`name`,
`people`.`original_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` = '2017' AND
`creditables`.`creditable_type` = 'App\\Title'
ORDER BY
`creditables`.`order` ASC
|
| 0.6739 |
SELECT
CONCAT('', GROUP_CONCAT(DISTINCT CONCAT('', `videos`.`language`, '')), '') as `langs`,
`titles`.`id`,
`titles`.`name`,
`titles`.`original_title`,
`titles`.`tmdb_vote_average`,
`titles`.`year`,
`titles`.`poster`,
`titles`.`backdrop`,
`titles`.`imdb_id`,
`titles`.`tmdb_id`,
`titles`.`season_count`,
`titles`.`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`!='2017' 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
|
კომენტარები