Arriving.12/31/1969..1.SELECT t1. * , min( t2.price ) AS min_price, tb.startdate, tb.enddate
FROM `j25_bookman_units` AS t1
LEFT JOIN `j25_bookman_prices` AS t2 ON t2.uid = t1.id
LEFT JOIN `j25_bookman_bookings` AS tb ON tb.cid=t1.id
WHERE t1.published = 1 AND t1.category = '99'
GROUP BY t1.id ORDER BY rand(),t1.id limit 0,25
