Database Error; SQL: SELECT DISTINCT `t`.*, GROUP_CONCAT(DISTINCT `units`.`id` SEPARATOR ',') as `unit_ids`, GROUP_CONCAT(DISTINCT `tenants`.`name` SEPARATOR ', ') as `tenant_names`, `building_type`.`name` as `building_type_name` FROM `wp_pods_crm_building` AS `t` LEFT JOIN `wp_podsrel` AS `rel_units` ON `rel_units`.`field_id` = 635 AND `rel_units`.`item_id` = `t`.`id` LEFT JOIN `wp_pods_crm_unit` AS `units` ON `units`.`id` = `rel_units`.`related_item_id` LEFT JOIN `wp_podsrel` AS `rel_tenants` ON `rel_tenants`.`field_id` = 1588 AND `rel_tenants`.`item_id` = `t`.`id` LEFT JOIN `wp_pods_crm_tenant` AS `tenants` ON `tenants`.`id` = `rel_tenants`.`related_item_id` LEFT JOIN `wp_podsrel` AS `rel_building_type` ON `rel_building_type`.`field_id` = 631 AND `rel_building_type`.`item_id` = `t`.`id` LEFT JOIN `wp_pods_crm_building_type` AS `building_type` ON `building_type`.`id` = `rel_building_type`.`related_item_id` WHERE ( `t`.`id` in (2393, 3457, 2394, 2396, 2588, 2719, 2712, 2710, 2711, 3074, 2720, 2713, 2714, 2715, 2716, 2717, 2718, 3575, 3576, 3577) and `t`.`computed_available_space` >= 0 ) GROUP BY `t`.`id` ORDER BY field(status, "built", "under construction", "planned"), computed_available_space desc, `t`.`code`, `t`.`id`; Response: Column 'status' in order clause is ambiguous