Poster

SELECT p.id AS ID ,trim(p.name) AS name ,p.venue_id AS venue_id ,p.thmb_url AS thmb_url ,p.web_url AS web_url ,p.perf_date::timestamp::time AS tt ,p.perf_date::timestamp::date AS normal_date ,date_part('day', p.perf_date) AS dd ,date_part('month', p.perf_date) AS mm ,date_part('year', p.perf_date) AS yy ,v.alias AS v_alias ,vt.alias AS vt_alias ,vt.sort_n ,v.id ,p.perf_date AS perf_date ,p.auditorium_name AS auditorium_name ,p.min_price AS min_price ,p.max_price AS max_price ,p.genre AS genre FROM poster AS p LEFT JOIN poster_venue AS v ON (v.id = p.venue_id) LEFT JOIN poster_venue_type AS vt ON (vt.id=v.type_id) WHERE p.perf_date>=LOCALTIMESTAMP AND (p.perf_date::timestamp::date = '2025-04-04' ) ORDER BY 13,14,7,6