class.udb.php:184 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND (u.roomID = 0 OR u.roomID IN ()) /* only appliable for rooms */ ...' at line 15

CREATE TEMPORARY TABLE `tmpD1199709281` ENGINE=MEMORY
SELECT * FROM (
SELECT b.*, l.textLong AS `discountText`, t.roomID,
SUM(CASE b.benefitType
WHEN 1 THEN b.benefitPrice
WHEN 2 THEN (t.price + t.panPrice) * b.benefitPrice / 100
WHEN 3 THEN b.benefitPrice
WHEN 4 THEN (t.price + t.panPrice) - t.altPrice
ELSE 0
END) as `discountValue`
, SUM(IF(b.benefitType = 2, t.totalEA * b.benefitPrice / 100, 0)) AS `discountEA`, SUM(IF(b.benefitType = 2, t.totalEK * b.benefitPrice / 100, 0)) AS `discountEK`
FROM `benefits` as `b` INNER JOIN `benefits_units` AS `u` USING(`benefitID`)
INNER JOIN `tmpT845153669` as `t` ON (t.siteID = b.siteID AND (u.roomID = 0 OR u.roomID = t.roomID) AND b.benefitDays & IF(t.cEnd = 1, 1, 2) AND (b.benefitDates = 0 OR t.cDate BETWEEN b.benefitDateStart AND b.benefitDateEnd))
LEFT JOIN `benefits_langs` AS `l` ON (b.benefitID = l.benefitID AND l.langID = 1)
WHERE b.siteID IN () AND (u.roomID = 0 OR u.roomID IN ()) /* only appliable for rooms */
AND b.active = 1 AND (b.benefitDates = 0 OR ('2025-10-12' BETWEEN b.benefitDateStart AND b.benefitDateEnd)) /* active in dates */
AND b.benefitTo = 0 /* for customer club or all */
AND (b.benefitTiming IN (0,3) OR (b.benefitTiming = 1 AND b.benefitTimingBefore >= 0) OR (b.benefitTiming = 2 AND b.benefitTimingBefore <= 0) OR (b.benefitTiming = 4 AND '2025-10-12' BETWEEN b.orderActualFrom AND b.orderActualTill)) /* last minute or advance booking */
AND b.benefitMinDates <= 1
AND (())
AND b.benefitType <> 4
GROUP BY b.benefitID, t.roomID
ORDER BY `discountValue`
) AS `tmp`
GROUP BY `roomID`
ORDER BY NULL
1: class.InSearch.php:1099 udb::query()
2: minisite.php:177 InSearch::getPriceData()
3: index.php:350 include()