exported_view.php

<?php

$view = new view;
$view->name = 'userthing';
$view->description = '';
$view->tag = 'default';
$view->base_table = 'users';
$view->human_name = 'userthing';
$view->core = 7;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Master */
$handler = $view->new_display('default', 'Master', 'default');
$handler->display->display_options['title'] = 'userthing';
$handler->display->display_options['access']['type'] = 'perm';
$handler->display->display_options['access']['perm'] = 'access user profiles';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['query']['options']['query_comment'] = FALSE;
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '10';
$handler->display->display_options['style_plugin'] = 'default';
$handler->display->display_options['row_plugin'] = 'fields';
$handler->display->display_options['row_options']['hide_empty'] = 0;
$handler->display->display_options['row_options']['default_field_elements'] = 1;
/* Relationship: User: User (field_thingy_user) - reverse */
$handler->display->display_options['relationships']['reverse_field_thingy_user_node']['id'] = 'reverse_field_thingy_user_node';
$handler->display->display_options['relationships']['reverse_field_thingy_user_node']['table'] = 'users';
$handler->display->display_options['relationships']['reverse_field_thingy_user_node']['field'] = 'reverse_field_thingy_user_node';
$handler->display->display_options['relationships']['reverse_field_thingy_user_node']['required'] = 0;
/* Field: User: Name */
$handler->display->display_options['fields']['name']['id'] = 'name';
$handler->display->display_options['fields']['name']['table'] = 'users';
$handler->display->display_options['fields']['name']['field'] = 'name';
$handler->display->display_options['fields']['name']['label'] = '';
$handler->display->display_options['fields']['name']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['name']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['name']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['name']['alter']['word_boundary'] = 0;
$handler->display->display_options['fields']['name']['alter']['ellipsis'] = 0;
$handler->display->display_options['fields']['name']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['name']['alter']['trim'] = 0;
$handler->display->display_options['fields']['name']['alter']['html'] = 0;
$handler->display->display_options['fields']['name']['hide_empty'] = 0;
$handler->display->display_options['fields']['name']['empty_zero'] = 0;
$handler->display->display_options['fields']['name']['link_to_user'] = 1;
$handler->display->display_options['fields']['name']['overwrite_anonymous'] = 0;
/* Sort criterion: User: Created date */
$handler->display->display_options['sorts']['created']['id'] = 'created';
$handler->display->display_options['sorts']['created']['table'] = 'users';
$handler->display->display_options['sorts']['created']['field'] = 'created';
$handler->display->display_options['sorts']['created']['order'] = 'DESC';
/* Filter criterion: User: Active */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'users';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = '1';
$handler->display->display_options['filters']['status']['group'] = 1;
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;
/* Filter criterion: Content: User (field_thingy_user) */
$handler->display->display_options['filters']['field_thingy_user_uid']['id'] = 'field_thingy_user_uid';
$handler->display->display_options['filters']['field_thingy_user_uid']['table'] = 'field_data_field_thingy_user';
$handler->display->display_options['filters']['field_thingy_user_uid']['field'] = 'field_thingy_user_uid';
$handler->display->display_options['filters']['field_thingy_user_uid']['relationship'] = 'reverse_field_thingy_user_node';
$handler->display->display_options['filters']['field_thingy_user_uid']['operator'] = 'empty';

/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page');
$handler->display->display_options['path'] = 'userthing';
$translatables['userthing'] = array(
  t('Master'),
  t('userthing'),
  t('more'),
  t('Apply'),
  t('Reset'),
  t('Sort by'),
  t('Asc'),
  t('Desc'),
  t('Items per page'),
  t('- All -'),
  t('Offset'),
  t('field_thingy_user'),
  t('Page'),
);

query.sql

SELECT users.name AS users_name, users.uid AS uid, users.created AS users_created
FROM 
{users} users
LEFT JOIN {field_data_field_thingy_user} field_data_field_thingy_user ON users.uid = field_data_field_thingy_user.field_thingy_user_uid
LEFT JOIN {node} field_thingy_user_users ON field_data_field_thingy_user.entity_id = field_thingy_user_users.nid
LEFT JOIN {field_data_field_thingy_user} field_thingy_user_users__field_data_field_thingy_user ON field_thingy_user_users.nid = field_thingy_user_users__field_data_field_thingy_user.entity_id AND (field_thingy_user_users__field_data_field_thingy_user.entity_type = 'node' AND field_thingy_user_users__field_data_field_thingy_user.deleted = '0')
WHERE (( (users.status <> '0') AND (field_thingy_user_users__field_data_field_thingy_user.field_thingy_user_uid IS NULL ) ))
ORDER BY users_created DESC
LIMIT 10 OFFSET 0