$CTquery = Drupal::entityQuery('node')
  ->condition('status', 1)
  ->condition('type', 'article')
  ->condition('field_category.entity.name', ['cat1','cat2'], 'IN')
  ->sort('field_category_top', 'ASC') //minor sorting
  ->sort('field_featured', 'ASC') //major sorting
  ->range(0,10);