<params>buildings
startDate
endDate
areas</params>
#;
SELECT br.reservationID as reference, date_format(br.startDate,'%Y/%m/%d') as startDate, date_format(br.endDate,'%Y/%m/%d') as endDate, br.apartment,'OTEBooking' as state,'' as extension
FROM bookingreservation br
LEFT JOIN customer as c ON (c.customer = br.bookingCustomer)
LEFT JOIN customercompany as cc ON (cc.customer = c.customer)
LEFT JOIN company co ON (co.company = cc.company), property p, unit u
WHERE
u.unit = br.apartment
                      <dtml-if areas>
                        <dtml-if buildings>
                          AND (<dtml-sqltest areas column="p.area" type=string multiple> OR <dtml-sqltest buildings column="p.property" type=int multiple>)
                        <dtml-else>
                            AND <dtml-sqltest areas column="p.area" type=string multiple>
                        </dtml-if>
                      <dtml-else>
                        <dtml-if buildings>
                         AND <dtml-sqltest buildings column="p.property" type=int multiple>
                        </dtml-if>
                      </dtml-if>
      AND br.startDate < <dtml-sqlvar endDate type=string>
      AND br.endDate > <dtml-sqlvar startDate type=string>
AND br.expiry > NOW() AND br.extensionOf <> "" AND br.statetype = ""
GROUP BY br.reservationID