Export not returning addresses properly by location type
Issue 1: Select Primary address and is returning the oldest address instead. This is what the underlying data is like:
MariaDB [civicrm_crm]> select id,is_primary,contact_id,street_address,location_type_id from civicrm_address where contact_id=5205;
+-------+------------+------------+---------------------+------------------+
| id | is_primary | contact_id | street_address | location_type_id |
+-------+------------+------------+---------------------+------------------+
| 1470 | 0 | 5205 | 317 SW 6th Ave #400 | 2 |
| 13705 | 1 | 5205 | 9755 SW Barnes Road | 3 |
| 13706 | 0 | 5205 | 9755 SW Barnes Road | 6 |
+-------+------------+------------+---------------------+------------------+
3 rows in set (0.00 sec)
And this is what is returned.
Issue 2: Select state by Location Main/Work and shows nothing, even though exists. Note: selecting State by Primary location does return results.
Currently using CiviCRM 5.26.2