| 0.2138 |
SELECT
SQL_CALC_FOUND_ROWS titles.id,
CONCAT('', GROUP_CONCAT(DISTINCT CONCAT('', `videos`.`category`, '')), '') as `type`,`videos`.`episode_num` as `episode_count`,`videos`.`season_num` as `season_count`,
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`.`category`,
`videos`.`language`
FROM
`titles`
LEFT JOIN `videos`
ON `videos`.`title_id`=`titles`.`id`
WHERE
`titles`.`is_series`='1'
AND `videos`.`category`='full'
GROUP BY
`titles`.`id`
ORDER BY
`titles`.`updated_at` DESC
LIMIT 0,24
|
