Erreur de la base de données WordPress : [Unknown column 'event_owner' in 'where clause']SELECT COUNT(DISTINCT wp_em_bookings.booking_id) FROM wp_em_bookings
WHERE event_owner=0 AND booking_status=0 AND wp_em_bookings.event_id != 0
ORDER BY booking_date
Erreur de la base de données WordPress : [Illegal mix of collations for operation 'UNION']SELECT * FROM wp_em_bookings
LEFT JOIN (
SELECT b.booking_id AS user_name_bid, user_name FROM wp_em_bookings b LEFT JOIN (
SELECT wm1.user_id, CONCAT(wm1.meta_value,' ',wm2.meta_value) as user_name FROM wp_usermeta wm1
LEFT JOIN wp_usermeta wm2 ON wm1.user_id=wm2.user_id AND wm2.meta_key='last_name'
WHERE wm1.meta_key='first_name'
) um ON um.user_id = b.person_id WHERE user_id IS NOT NULL AND user_name != ' '
UNION
SELECT b.booking_id AS user_name_bid, CONCAT(bm1.meta_value,' ',bm2.meta_value) as user_name FROM wp_em_bookings b
LEFT JOIN wp_em_bookings_meta bm1 ON bm1.booking_id = b.booking_id AND (bm1.meta_key='_registration_first_name' OR bm1.meta_key='_registration|first_name')
LEFT JOIN wp_em_bookings_meta bm2 ON bm2.booking_id = b.booking_id AND (bm2.meta_key='_registration_last_name' OR bm2.meta_key='_registration|last_name')
WHERE bm1.meta_key IS NOT NULL OR bm2.meta_key IS NOT NULL
UNION
SELECT b.booking_id AS user_name_bid, bm1.meta_value FROM wp_em_bookings b
LEFT JOIN wp_em_bookings_meta bm1 ON bm1.booking_id = b.booking_id AND (bm1.meta_key='_registration_user_name' OR bm1.meta_key='_registration|user_name')
WHERE bm1.meta_key IS NOT NULL
) user_name ON user_name.user_name_bid = wp_em_bookings.booking_id
WHERE event_owner=0 AND booking_status=0 AND wp_em_bookings.event_id != 0
GROUP BY booking_id
ORDER BY user_name ASC
LIMIT 20
OFFSET 0