I want to get a list that the items with a specific term in the top (like promote). The query would be like:
$query = \Drupal::entityQuery('node') ->condition('status', 1) ->condition('type', 'news') ->sort('field_product_category', $tid, '<>') //Error <> ->range(0, 5);
Can I put calculation in sort condition? I do not want to make 2 queries.