query error: SELECT al.*, al.album_artist as album_artist_code, p.price as current_price, j.*, pid.*, ar.*, i.*, label.*, artist.*, ap.*, re.trial_prohibited, re.prior_tracks, EXTRACT(EPOCH FROM re.reservation_start) AS reservation_start, EXTRACT(EPOCH FROM re.reservation_end) AS reservation_end, EXTRACT(EPOCH FROM re.download_start) AS download_start, EXISTS(SELECT pdcd.code_album_child FROM packages_dler_can_dl pdcd WHERE pdcd.code_album_parent = al.code) AS child_albums_exist, EXISTS(SELECT pdcd.code_album_parent FROM packages_dler_can_dl pdcd WHERE pdcd.code_album_child = al.code) AS parent_albums_exist, aa.*, (COALESCE((SELECT code FROM admin_priceoff_info WHERE (start_at IS NULL OR start_at <= NOW()) AND (end_at IS NULL OR NOW() < end_at) AND code_album = al.code), (CASE WHEN al.tier_code ~ '^(CM|CT)' THEN 1 ELSE 0 END))) AS campaign, (SELECT COUNT(ti.code_tag) FROM tagged_item ti WHERE ti.code_album = al.code AND ti.active AND ti.code_tag = 13795) AS bonus_addendum, (SELECT COUNT(ti.code_tag) FROM tagged_item ti WHERE ti.code_album = al.code AND ti.active AND ti.code_tag = 14066) AS explicit_version FROM albums al LEFT JOIN LATERAL (SELECT j.path AS jacket_path FROM jacket j  WHERE j.code_album = al.code AND j.active ORDER BY j.code DESC  LIMIT 1 ) AS j ON true  LEFT JOIN LATERAL (SELECT product_id FROM product_id pid  WHERE pid.code_album = al.code ORDER BY pid.code DESC  LIMIT 1 ) AS pid ON true  LEFT JOIN LATERAL (SELECT ar.body AS review_text FROM album_reviews ar  WHERE ar.code_album = al.code AND ar.is_official ORDER BY ar.modified_at DESC  LIMIT 1 ) AS ar ON true  LEFT JOIN LATERAL (SELECT re.trial_prohibited, re.prior_tracks, re.reservation_start, re.reservation_end, re.download_start FROM reservation re WHERE re.code_album = al.code AND re.active   ) AS re ON true  LEFT JOIN LATERAL (SELECT CASE WHEN ap.code_album IS NOT NULL THEN true ELSE false END AS additional_payable, ap.comment AS additional_payable_comment  FROM additional_payables ap WHERE ap.code_album = al.code AND ap.active  ORDER BY ap.created_at DESC  LIMIT 1 ) AS ap ON true  LEFT JOIN LATERAL (SELECT count(*) AS iine_sum FROM iine i WHERE i.code_album = al.code   ) AS i ON true  LEFT JOIN LATERAL (SELECT th.primary_name AS album_label_name, th.code AS album_label_code FROM right_holder rh JOIN them th ON rh.code_them = th.code AND th.type = 'COMPANY'  WHERE rh.code_album = al.code AND rh.type = 'LABEL'    ) AS label ON true  LEFT JOIN LATERAL (SELECT th.primary_name AS album_artist_name, th.code AS album_artsit_code FROM them th WHERE th.code = al.album_artist AND th.type IN ('PERSON', 'UNIT')    ) AS artist ON true  LEFT JOIN LATERAL (SELECT p.price FROM prices p WHERE p.code_album = al.code AND (COALESCE(p.start_date, now()) <= now() AND COALESCE(p.end_date, now() + interval '1 minutes') > now()) AND code_track IS NULL  ORDER BY p.code DESC  LIMIT 1 ) AS p ON true  LEFT JOIN LATERAL (SELECT CASE WHEN COUNT(t.code) > 1 THEN json_agg(json_build_object('code', t.code, 'name', t.primary_name) ORDER BY rh.order_num) ELSE NULL END AS artists FROM them t, right_holder rh WHERE t.code = rh.code_them AND rh.code_album = al.code AND t.type IN ('PERSON', 'UNIT') AND rh.type = 'ARTIST' GROUP BY rh.code_album ) AS aa ON true WHERE al.code = :code;