| 0.0003 |
SELECT
`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`='0'
AND `videos`.`category` IN ('full')
GROUP BY
`titles`.`id`
LIMIT 0,24
|
| 0.0002 |
SELECT
count(`titles`.`id`) as count,
`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`='0'
AND `videos`.`category` IN ('full')
|
| 0.0002 |
SELECT id,name,display_name FROM `tags` WHERE `type` LIKE 'genre' ORDER BY `tags`.`display_name` ASC
|
