1054 Unknown column 'customer.email' in 'field list' SQL=SELECT `customer`.*, COALESCE(`user`.`email`,`customer`.`email`) AS email, GROUP_CONCAT(`group`.`title`) AS `usertype` FROM `#__booking_customer` AS `customer` LEFT JOIN `#__user_usergroup_map` AS `map` ON `map`.`user_id` = `customer`.`user` LEFT JOIN `#__usergroups` AS `group` ON `group`.`id` = `map`.`group_id` LEFT JOIN `#__users` AS `user` ON `user`.`id` = `customer`.`user` WHERE `customer`.`id` = 0 GROUP BY `customer`.`user`