Afficher des données en les ordonnant selon un champ d'une autre BDD

SELECT SQL_CALC_FOUND_ROWS * FROM tags WHERE tag_slug=:tag_slug LIMIT limite OFFSET debut

SELECT SQL_CALC_FOUND_ROWS
  t.art_id,
  t.tag_name,
  t.tag_slug,
  t.tag_code,
  a.id_article,
  a.date_creation
FROM
  tags t
  INNER JOIN articles a ON t.id_article = t.art_id
WHERE
  t.tag_slug = ':tag_slug'
ORDER BY
  a.date_creation DESC
LIMIT limite OFFSET debut

$page = (!empty($_GET['page']) ? $_GET['page'] : 1);

$accueil = 'https://exemple.fr/'.trim($_GET['lang']).'/t-'.trim($_GET['slug']).'';

$type_page = '-p-';

//$adj = 1;

//$limite = 2;

$debut = ($page - 1) * $limite;

//$query = "SELECT SQL_CALC_FOUND_ROWS * FROM tags WHERE tag_slug=:tag_slug LIMIT :limite OFFSET :debut";

$query = "SELECT SQL_CALC_FOUND_ROWS
  t.art_id,
  t.tag_name,
  t.tag_slug,
  t.tag_code,
  a.id_article,
  a.date_creation
FROM
  tags t
  INNER JOIN articles a ON t.id_article = t.art_id
WHERE
  t.tag_slug = ':tag_slug'
ORDER BY
  a.date_creation DESC
LIMIT :limite OFFSET :debut";

$tag_slug = trim($_GET['slug']);

$query = $bdd->prepare($query);

$query->bindValue('limite', $limite, PDO::PARAM_INT);
$query->bindValue('debut', $debut, PDO::PARAM_INT);
$query->bindValue('tag_slug', $tag_slug, PDO::PARAM_STR);

$query->execute();

$res_nb_art = $bdd->query('SELECT found_rows()');

$nb_total = $res_nb_art->fetchColumn();

$nb_pages = ceil($nb_total / $limite);

echo '<br />';
echo "Page $page / $nb_pages";
echo '<br /><br>';

echo getPaginationString($page, $nb_total, $limite, $adj, $accueil, $type_page);