Views order and optional relationships

Null values go first.

http://dev.mysql.com/doc/refman/5.0/en/working-with-null.html

Happy accident is that once the view is 'reversed', most recently added go first.

TODO: Make sure that whenever a node is promoted to a continuum, it gets promoted to front page, too-- so that it doesn't suddenly drop off when it is promoted.

Sep 12 15:33:22 simone drupal: https://sdl-test.agariclabs.org|1315856002|php|216.254.99.7|https://sdl-test.agariclabs.org/nodequeue/autocomplete/4/s|https://sdl-test.agariclabs.org/admin/structure/nodequeue/4/view|1||PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ')) AND (LOWER(n.title) LIKE LOWER('%s%')) #012LIMIT 10 OFFSET 0' at line 1: SELECT n.nid AS nid, n.title AS title#012FROM #012{node} n#012WHERE (n.type IN ()) AND (LOWER(n.title) LIKE LOWER(:string)) #012LIMIT 10 OFFSET 0; Array#012(#012 [:string] => %s%#012)#012 in nodequeue_api_autocomplete() (line 1804 of /var/local/drupal/sdl-test/web/sites/all/modules/contrib/nodequeue/nodequeue.module).
Sep 12 15:34:40 simone drupal: https://sdl-test.agariclabs.org|1315856080|php|216.254.99.7|https://sdl-test.agariclabs.org/admin/structure/nodequeue/4/edit|https://sdl-test.agariclabs.org/admin/structure/nodequeue/4/edit|1||PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'i18n' at row 1: UPDATE {nodequeue_queue} SET name=:db_update_placeholder_0, title=:db_update_placeholder_1, subqueue_title=:db_update_placeholder_2, size=:db_update_placeholder_3, link=:db_update_placeholder_4, link_remove=:db_update_placeholder_5, owner=:db_update_placeholder_6, show_in_links=:db_update_placeholder_7, show_in_tab=:db_update_placeholder_8, show_in_ui=:db_update_placeholder_9, i18n=:db_update_placeholder_10, reverse=:db_update_placeholder_11, reference=:db_update_placeholder_12#012WHERE (qid = :db_condition_placeholder_0) ; Array#012(#012 [:db_update_placeholder_0] => news_continuum#012 [:db_update_placeholder_1] => News continuum#012 [:db_update_placeholder_2] => #012 [:db_update_placeholder_3] => 20#012 [:db_update_placeholder_4] => Add to Top News#012 [:db_update_placeholder_5] => Pop off Top News#012 [:db_update_placeholder_6] => nodequeue#012 [:db_update_placeholder_7] => 1#012 [:db_update_placeholder_8] => 1#012 [:db_update_placeholder_9] => 1#012 [:db_update_placeholder_10] => #012 [:db_update_placeholder_11] => 1#012 [:db_update_placeholder_12] => 0#012 [:db_condition_placeholder_0] => 4#012)#012 in nodequeue_save() (line 937 of /var/local/drupal/sdl-test/web/sites/all/modules/contrib/nodequeue/nodequeue.module).
Sep 12 15:34:41 simone drupal: https://sdl-test.agariclabs.org|1315856081|page not found|216.254.99.7|https://sdl-test.agariclabs.org/sites/all/themes/cubed/logo.png|https://sdl-test.agariclabs.org/admin/structure/nodequeue/4/edit|1||sites/all/themes/cubed/logo.png