Views query breaks on multiple sort

Hi,

I've been tackling this problem for weeks now, and now that the production website is online, the problem still persists... I am totally frustrated. My problem:

I have a complicated view (see below) which sorts many fields from user, usernode and profile to create a userlist. All goes well, the view works (and gets overridden by template.php for own-written layout). After a few hits on that view page, it breaks, showing the following SQL error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC, profile_naam_value ASC' at line 1 query: SELECT DISTINCT(node.nid), value, profile_naam.value AS profile_naam_value, profile_instrument.value AS profile_instrument_value, profile_voornaam.value AS profile_voornaam_value, users.uid AS users_uid, profile_telefoon.value AS profile_telefoon_value, profile_pro.value AS profile_pro_value, usernode_users.access AS usernode_users_access, usernode_users.login AS usernode_users_login, profile_rvb.value AS profile_rvb_value FROM node node INNER JOIN usernode usernode ON node.nid = usernode.nid LEFT JOIN users usernode_users ON usernode.uid = usernode_users.uid LEFT JOIN users_roles users_roles ON node.uid = users_roles.uid INNER JOIN users users ON node.uid = users.uid LEFT JOIN profile_values profile_naam ON users.uid = profile_naam.uid AND profile_naam.fid = '2' LEFT JOIN profile_values profile_instrument ON users.uid = profile_instrument.uid AND profile_instrument.fid = '3' LEFT JOIN profile_values profile_voornaam ON users.uid = profile_voornaam.uid AND profile_voornaam.fid = '1' LEFT JOIN profile_values profile_telefoon ON users.uid = profile_telefoon.uid AND profile_telefoon.fid = '6' WHERE (node.type IN ('usernode')) AND (usernode_users.status = '1') AND (users_roles.rid IN ('3')) ORDER BY DESC, profile_naam_value ASC in /mounted-storage/home74a/sub007/sc42330-HQFI/www/akademos/includes/database.mysql.inc on line 172.

I am going crazy, because when I edit and save the view again (without changing anything) the view's behaviour goes back to normal... Until the next crash of the script of course... It seems like a field that has to be sorted does NOT show up in the query, thus showing

ORDER BY DESC, some_fiel ASC ...

which produces an error of course. The field that should have been there between BY and DESC is profile_pro_value, which is extracted at the beginning of the query.

My View:

  $view = new stdClass();
  $view->name = 'ledenlijst';
  $view->description = 'Lijst van alle leden van Akademos.';
  $view->access = array (
);
  $view->view_args_php = '';
  $view->page = TRUE;
  $view->page_title = 'Ledenlijst';
  $view->page_header = '<p>Op deze pagina vind je een lijst met alle huidige leden van Akademos.<br />
Klik op de foto van een persoon om naar zijn/haar profiel te gaan.  Waar &quot;pro&quot; staat, gaat het om tijdelijke professionele versterking.<br />
De volgorde van de leden is totaal willekeurig.</p>';
  $view->page_header_format = '2';
  $view->page_footer = 'Zin gekregen om mee te spelen? Neem <a href="meespelen">hier</a> alvast een kijkje!';
  $view->page_footer_format = '1';
  $view->page_empty = '';
  $view->page_empty_format = '1';
  $view->page_type = 'table';
  $view->url = 'ledenlijst';
  $view->use_pager = FALSE;
  $view->nodes_per_page = '0';
  $view->sort = array (
    array (
      'tablename' => 'profile_aanvoerder',
      'field' => 'value',
      'sortorder' => 'DESC',
      'options' => '',
    ),
  );
  $view->argument = array (
  );
  $view->field = array (
    array (
      'tablename' => 'profile_instrument',
      'field' => 'value',
      'label' => 'Instrument',
    ),
    array (
      'tablename' => 'profile_voornaam',
      'field' => 'value',
      'label' => 'Voornaam',
    ),
    array (
      'tablename' => 'profile_naam',
      'field' => 'value',
      'label' => 'Naam',
    ),
    array (
      'tablename' => 'users',
      'field' => 'uid',
      'label' => 'Afbeelding',
    ),
    array (
      'tablename' => 'profile_telefoon',
      'field' => 'value',
      'label' => 'Telefoon',
    ),
    array (
      'tablename' => 'profile_pro',
      'field' => 'value',
      'label' => 'Professioneel',
    ),
    array (
      'tablename' => 'usernode_users',
      'field' => 'access',
      'label' => 'Laatste pagina bezocht',
      'handler' => 'views_handler_field_date_small',
    ),
    array (
      'tablename' => 'usernode_users',
      'field' => 'login',
      'label' => 'Laatst ingelogd',
      'handler' => 'views_handler_field_date_small',
    ),
    array (
      'tablename' => 'profile_rvb',
      'field' => 'value',
      'label' => '',
    ),
  );
  $view->filter = array (
    array (
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => 'usernode',
),
    ),
    array (
      'tablename' => 'usernode_users',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array (
      'tablename' => 'users_roles',
      'field' => 'rid',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => '3',
),
    ),
  );
  $view->exposed_filter = array (
  );
  $view->requires = array(profile_aanvoerder, profile_instrument, profile_voornaam, profile_naam, users, profile_telefoon, profile_pro, usernode_users, profile_rvb, node, users_roles);
  $views[$view->name] = $view;

If tried removing and re-enabling some sort fields, but of course, it's just updating the page that repairs it temporarily.

Please advise soon. Thank you.

SabbeRubbish