joli-table-of-contents domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/thevivestia.com/staging.thevivestia.com/wp-includes/functions.php on line 6131wp-last-modified-info domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/thevivestia.com/staging.thevivestia.com/wp-includes/functions.php on line 6131fast-indexing-api domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/thevivestia.com/staging.thevivestia.com/wp-includes/functions.php on line 6131rank-math domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/thevivestia.com/staging.thevivestia.com/wp-includes/functions.php on line 6131traveler domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/thevivestia.com/staging.thevivestia.com/wp-includes/functions.php on line 6131WordPress database error: [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 '?type=villa
GROUP BY yTgq7VE_posts.ID
ORDER BY tb.is_featured des...' at line 47]SELECT SQL_CALC_FOUND_ROWS yTgq7VE_posts.*,
st_rental_price
FROM yTgq7VE_posts INNER JOIN yTgq7VE_st_rental as tb ON yTgq7VE_posts.ID = tb.post_id INNER JOIN
(
SELECT tb3.number , tb3.number_booked , tb3.post_id,
SUM(
CASE
WHEN tb.is_sale_schedule != 'on' THEN
CASE
WHEN tb.discount_type = 'percent'
THEN
CAST(tb3.price AS DECIMAL) -(CAST(tb3.price AS DECIMAL) / 100) * CAST(tb.discount_rate AS DECIMAL)
ELSE CAST(tb3.price AS DECIMAL) - CAST(tb.discount_rate AS DECIMAL)
END
WHEN tb.is_sale_schedule = 'on'THEN
CASE
WHEN(UNIX_TIMESTAMP(DATE(tb.sale_price_from)) <= 1764979200 AND UNIX_TIMESTAMP(DATE(tb.sale_price_to)) >= 1765065600)
THEN
CASE
WHEN tb.discount_type = 'percent'
THEN CAST(tb3.price AS DECIMAL) - (CAST(tb3.price AS DECIMAL) / 100) * CAST(tb.discount_rate AS DECIMAL)
ELSE CAST(tb3.price AS DECIMAL) - CAST(tb.discount_rate AS DECIMAL)
END
ELSE tb3.price
END
ELSE tb3.price
END
) as st_rental_price
FROM yTgq7VE_st_rental_availability AS tb3
LEFT JOIN yTgq7VE_st_rental AS tb ON tb.post_id = tb3.post_id
WHERE (
tb3.check_in >= 1764979200
AND tb3.check_out < 1765065600
AND( CAST(tb3.number AS DECIMAL) - CAST(tb3.number_booked AS DECIMAL) > 0 )
)
OR
(
tb3.check_in >= 1764979200
AND tb3.check_out <= 1765065600
AND( CAST(tb3.number AS DECIMAL) - CAST(tb3.number_booked AS DECIMAL) > 0 )
AND tb3.groupday = 1
)
GROUP BY tb3.post_id
) AS tb2
ON yTgq7VE_posts.ID = tb2.post_id
WHERE 1=1 AND yTgq7VE_posts.post_type = 'st_rental' AND ((yTgq7VE_posts.post_status = 'publish')) AND yTgq7VE_posts.ID NOT IN (15622,15631,15641,15651,15753,15755,15817,15874,15882,15889,15896,15901,15908,15918,15925,15930,15940,15955,15977,16029,16042,16049,16055,16062,16185,16203,16225,16250,16270,16279,16307,16323,16334,16345,16357,16372,16393,16411,16429,16442,16448,16458,16619,16648,16719,16732,16744,16762,16767,16773,16815,16822,16832,16835,16846,16857,16869,16877,17113,17136,17168,17179,17188,17199,17315,17316,17317,17319,18605,18608,18609,18612,18613,18614,21528,21685,22232,22247,22558,24943,25432,26260,28077,28093,28094,28096,28097,28116,28338,28352,28360,28369,28379) AND CAST(tb.rentals_booking_period AS UNSIGNED) <= 0 AND (CAST(tb2.number AS DECIMAL) - CAST(tb2.number_booked AS DECIMAL) > 0) AND tb.rental_max_adult>= 1 AND tb.rental_max_children>= 0?type=villa
GROUP BY yTgq7VE_posts.ID
ORDER BY tb.is_featured desc, yTgq7VE_posts.post_date desc
LIMIT 0, 50