SELECT `services`.`name`, `services`.`id`, `services`.`description`, `services`.`wait_time_on`, `services`.`wait_time`, `services`.`roundup_time`, `services`.`time`, `services`.`category`, `service_employees`.`price`, `addon_services`.`connected_service_id`, `services`.`break_after`, `services`.`fromset`
FROM `services`
JOIN `addon_services` ON `addon_services`.`service_id` = `services`.`id`
JOIN `service_employees` ON `service_employees`.`service_id` = `addon_services`.`service_id`
WHERE `services`.`active` = 1
AND `services`.`show_in_widget` = 1
AND `services`.`active` = 1
AND `service_employees`.`department_id` = '2523'
AND `service_employees`.`disable_online_booking` = 0
ORDER BY `services`.`orderby`, `services`.`id`, `service_employees`.`price` asc