DISTINCT wp_posts.post_title destination_to,
(
SELECT MIN(price_share) FROM wp_transfers_availability a_m_p1
WHERE price_share IS NOT NULL AND (a_m_p1.destination_from_id = 84 OR a_m_p1.destination_from_id = 0) AND (a_m_p1.destination_to_id = wp_posts.ID OR a_m_p1.destination_to_id = 0)
AND DATE(a_m_p1.end_datetime) > now() AND price_share > 0
) price_share_min,
(
SELECT MIN(price_private) FROM wp_transfers_availability a_m_p2
WHERE price_private IS NOT NULL AND (a_m_p2.destination_from_id = 84 OR a_m_p2.destination_from_id = 0) AND (a_m_p2.destination_to_id = wp_posts.ID OR a_m_p2.destination_to_id = 0)
AND DATE(a_m_p2.end_datetime) > now() AND price_private > 0
) price_private_min,
wp_posts.ID as destination_to_id
