WordPress database error: [Table 'joyandtrip_com.wp_st_rental' doesn't exist]SELECT SQL_CALC_FOUND_ROWS wpch_posts.*,
st_rental_price
FROM wpch_posts INNER JOIN wpch_st_rental as tb ON wpch_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)) <= UNIX_TIMESTAMP('2024-05-18') AND UNIX_TIMESTAMP(DATE(tb.sale_price_to)) >= UNIX_TIMESTAMP('2024-05-19'))
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 wpch_st_rental_availability AS tb3 LEFT JOIN wp_st_rental AS tb
ON
tb.post_id = tb3.post_id
WHERE tb3.check_in >= UNIX_TIMESTAMP('2024-05-18') AND tb3.check_out < UNIX_TIMESTAMP('2024-05-19') AND(
CAST(tb3.number AS DECIMAL) - CAST(tb3.number_booked AS DECIMAL) > 0
) GROUP BY tb3.post_id
) AS tb2
ON
wpch_posts.ID = tb2.post_id
WHERE 1=1 AND wpch_posts.post_type = 'st_rental' AND ((wpch_posts.post_status = 'publish')) AND wpch_posts.ID IN (SELECT post_id FROM wpch_st_location_relationships WHERE 1=1 AND location_from IN ('58','59','60') AND post_type IN ('st_rental')) AND CAST(tb.rentals_booking_period AS UNSIGNED) <= 0 AND (CAST(tb2.number AS DECIMAL) - CAST(tb2.number_booked AS DECIMAL) > 0)
GROUP BY wpch_posts.ID
ORDER BY tb.is_featured desc
LIMIT 0, 12