Will check it out... Here's the full query:
500 filter query error: generator Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,NUMERIC) for operation '>=' SQL=SELECT DISTINCT(CONCAT_WS('', `generatoren_0`.generator_description, ' - ', (SELECT generator_stationed FROM generatoren_standplaatsen WHERE id = `generatoren_0`.generator_stationed))) AS `text`, `generatoren_data`.`generator` AS `value` FROM `generatoren` LEFT JOIN `generatoren_vermogens` AS `generatoren_vermogens` ON `generatoren_vermogens`.`id` = `generatoren`.`generator_power` LEFT JOIN `generatoren_standplaatsen` AS `generatoren_standplaatsen` ON `generatoren_standplaatsen`.`id` = `generatoren`.`generator_stationed` LEFT JOIN `generatoren_materiaal` AS `generatoren_materiaal` ON `generatoren_materiaal`.`id` = `generatoren`.`generator_material` LEFT JOIN `generatoren_synchronisatie` AS `generatoren_synchronisatie` ON `generatoren_synchronisatie`.`id` = `generatoren`.`generator_synchronisation` LEFT JOIN `generatoren_data` AS `generatoren_data` ON `generatoren_data`.`generator` = `generatoren`.`id` LEFT JOIN `generatoren` AS `generatoren_0` ON `generatoren_0`.`id` = `generatoren_data`.`generator` LEFT JOIN `uq2ib_users` AS `uq2ib_users` ON `uq2ib_users`.`id` = `generatoren_data`.`executor` LEFT JOIN `generatoren_materiaal` AS `generatoren_materiaal_0` ON `generatoren_materiaal_0`.`id` = `generatoren_data`.`material` LEFT JOIN `uq2ib_users` AS `uq2ib_users_0` ON `uq2ib_users_0`.`id` = `generatoren_data`.`applicant` WHERE `generatoren_data`.`generator` IN ('8','9','21','44','45','46','47') AND `generatoren_0`.id NOT IN (SELECT generator FROM generatoren_data WHERE '' >= generatoren_data.startdate AND '' <= generatoren_data.enddate) ORDER BY CONCAT_WS('', `generatoren_0`.generator_description, ' - ', (SELECT generator_stationed FROM generatoren_standplaatsen WHERE id = `generatoren_0`.generator_stationed))ASC LIMIT 0, 100
-- Arjan