New Releases
No new releases.
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC,
CASE object_type
WHEN 'movie' THEN 1
' at line 45]
(
SELECT
p.ID,
p.post_title,
m.poster_path,
m.imdb_rating,
'movie' AS object_type,
l.rank
FROM wp_tmdb_endpoint_lists l
INNER JOIN wp_movies m
ON m.tmdb_id = l.tmdb_id
INNER JOIN wp_posts p
ON p.ID = m.post_id
WHERE l.endpoint = 'trending_day'
AND l.object_type = 'movie'
AND l.missing = 0
AND p.post_type = 'movies'
AND p.post_status = 'publish'
AND m.release_date >= '2025-12-09'
)
UNION ALL
(
SELECT
p.ID,
p.post_title,
s.poster_path,
s.imdb_rating,
'tv' AS object_type,
l.rank
FROM wp_tmdb_endpoint_lists l
INNER JOIN wp_shows s
ON s.tmdb_id = l.tmdb_id
INNER JOIN wp_posts p
ON p.ID = s.post_id
WHERE l.endpoint = 'trending_day'
AND l.object_type = 'tv'
AND l.missing = 0
AND p.post_type = 'shows'
AND p.post_status = 'publish'
)
ORDER BY
rank ASC,
CASE object_type
WHEN 'movie' THEN 1
WHEN 'tv' THEN 2
END
LIMIT 20
WordPress database error: [Unknown column 'm.id' in 'on clause']
SELECT COUNT(*)
FROM wp_movies m
JOIN wp_posts p ON p.ID = m.id
WHERE
p.post_status = 'publish'
AND m.release_date BETWEEN '2026-01-26' AND '2026-02-09'
WordPress database error: [Unknown column 'm.id' in 'field list']
SELECT
m.id,
m.release_date AS date,
m.poster_path,
m.imdb_rating,
m.youtube,
m.genres,
m.origin_country,
'movies' AS post_type,
p.post_title,
p.post_name
FROM wp_movies m
JOIN wp_posts p ON p.ID = m.id
WHERE
p.post_status = 'publish'
AND m.release_date BETWEEN '2026-01-26' AND '2026-02-09'
ORDER BY m.release_date DESC, m.imdb_rating DESC
LIMIT 20 OFFSET 0
No new releases.