Leaderboard

Interesting to see a duplicate package ID. I wonder if that is an anomaly with the data being imported. The package IDs shown in your screenshot are constructed from data saved in the database. If you're familiar with databases, or have access to a database UI utility like phpmyadmin, you can view these records from the `packages` table. The problem is that one of the `id_value`'s is duplicated. Having duplicate package IDs is normal if the packages are from different companies, but clearly that is not the case here. However, having a duplicate package ID will not negatively impact how the system operates, as that ID is for display purposes only.

This will get you more info for context, or you can remove the fields just for the email addresses: SELECT `contacts`.`client_id`, `contacts`.`id` AS `contact_id`, `contacts`.`first_name`, `contacts`.`last_name`, `contacts`.`email`, `services`.`status`, `services`.`date_canceled`, COUNT(`services`.`id`) AS `number_of_services` FROM `contacts` INNER JOIN `services` ON `services`.`client_id` = `contacts`.`client_id` WHERE `services`.`status` = 'active' AND `services`.`package_group_id` = '1' GROUP BY `contacts`.`id` ORDER BY `contacts`.`client_id`, `contacts`.`id`