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 6121wp-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 6121fast-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 6121rank-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 6121traveler
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 6121WordPress 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)) <= 1759622400 AND UNIX_TIMESTAMP(DATE(tb.sale_price_to)) >= 1759708800)
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 >= 1759622400
AND tb3.check_out < 1759708800
AND( CAST(tb3.number AS DECIMAL) - CAST(tb3.number_booked AS DECIMAL) > 0 )
)
OR
(
tb3.check_in >= 1759622400
AND tb3.check_out <= 1759708800
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,15662,15672,15710,15718,15726,15737,15745,15753,15755,15882,15889,15896,15901,15908,15925,15930,15955,15969,15977,16029,16042,16049,16055,16062,16068,16177,16179,16181,16183,16185,16203,16250,16270,16279,16307,16323,16345,16357,16372,16393,16411,16429,16442,16448,16458,16633,16648,16719,16732,16744,16762,16767,16778,16815,16822,16832,16835,16846,16857,16869,17113,17136,17199,17315,17316,17317,18605,18609,18612,18614,21528,21685,22232,22247,22558,26260,28077,28093,28094,28096,28097) 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