Error en la base de datos de WordPress: [Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '<>']SELECT DISTINCT rr.hotel_id, rr.room_id, rr.rate_id
FROM wp_wpr_room_rates AS rr
LEFT JOIN wp_posts AS p
ON p.ID = rr.woocommerce_product_id
AND p.post_type = 'product'
AND p.post_status NOT IN ('trash', 'auto-draft')
LEFT JOIN wp_postmeta AS hotel_meta
ON hotel_meta.post_id = rr.woocommerce_product_id
AND hotel_meta.meta_key = 'wpr_hotel_id'
LEFT JOIN wp_postmeta AS room_meta
ON room_meta.post_id = rr.woocommerce_product_id
AND room_meta.meta_key = 'wpr_room_id'
LEFT JOIN wp_postmeta AS rate_meta
ON rate_meta.post_id = rr.woocommerce_product_id
AND rate_meta.meta_key = 'wpr_rate_id'
WHERE rr.woocommerce_product_id IS NULL
OR rr.woocommerce_product_id = 0
OR p.ID IS NULL
OR hotel_meta.meta_value IS NULL
OR room_meta.meta_value IS NULL
OR rate_meta.meta_value IS NULL
OR hotel_meta.meta_value <> rr.hotel_id
OR room_meta.meta_value <> rr.room_id
OR rate_meta.meta_value <> rr.rate_id
Encontrá tu lugar en el mundo
