| 9.1997 |
SELECT
SQL_CALC_FOUND_ROWS titles.id,
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` IN ('0','1')
AND ( `titles`.`name` LIKE '%s14%' OR `titles`.`name` LIKE '%ს14%' OR `titles`.`original_title` LIKE '%s14%' OR `titles`.`original_title` LIKE '%ს14%' )
GROUP BY
`titles`.`id`
ORDER BY
`titles`.`updated_at` DESC
LIMIT 0,24
|