Nom de la société
Ville
Query SELECT `users`.`sid` as `object_sid` , `users_properties`.value , COUNT(*) as countRows FROM `users`    LEFT JOIN `users_properties` as users_properties ON `users_properties`.object_sid = `users`.sid WHERE 1 AND `users`.`active` = '1' AND (0 OR(1 AND (`id` = 'CompanyName' AND `value` LIKE 'e%') ) )   GROUP BY `users_properties`.`object_sid`  ORDER BY `users_properties`.value ASC  : 
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hotessejobbdd.users.sid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query SELECT `users`.`sid` as `object_sid` , `users_properties`.value , COUNT(*) as countRows FROM `users`    LEFT JOIN `users_properties` as users_properties ON `users_properties`.object_sid = `users`.sid WHERE 1 AND `users`.`active` = '1' AND (0 OR(1 AND (`id` = 'CompanyName' AND `value` LIKE 'e%') ) )   GROUP BY `users_properties`.`object_sid`  ORDER BY `users_properties`.value ASC  : 
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hotessejobbdd.users.sid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Résultat de la recherche par société