SELECT locations.* FROM locations  
                               WHERE locations.status = 1   Order by locations.id ASC