Warning!

Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR `hostgroups`.`name` LIKE '%number%' OR `fact_names`.`short_name` LIKE '%numbe' at line 1: SELECT DISTINCT `fact_values`.id FROM `fact_values` LEFT OUTER JOIN `fact_names` ON `fact_names`.`id` = `fact_values`.`fact_name_id` LEFT OUTER JOIN `hosts` ON `hosts`.`id` = `fact_values`.`host_id` AND `hosts`.`type` IN ('Host::Managed') LEFT OUTER JOIN `hostgroups` ON `hostgroups`.`id` = `hosts`.`hostgroup_id` LEFT OUTER JOIN `hosts` `hosts_fact_values` ON `hosts_fact_values`.`id` = `fact_values`.`host_id` AND `hosts_fact_values`.`type` IN ('Host::Managed') INNER JOIN `fact_names` fact_names_816980 ON (fact_names_816980.id = fact_values.fact_name_id) WHERE (fact_names.name <> '_timestamp') AND ((fact_names_816980.`name` = '') AND ((`fact_names`.`name` = BINARY 'serial') AND (`fact_values`.`value` LIKE '%number%' OR `fact_values`.`value` LIKE '%number%' OR `fact_names`.`name` LIKE '%number%' OR OR `hostgroups`.`name` LIKE '%number%' OR `fact_names`.`short_name` LIKE '%number%') AND (`fact_values`.`value` = BINARY '24P0QW1'))) ORDER BY `fact_values`.`value` ASC LIMIT 300 OFFSET 0