gistfile1.sql

SELECT `bt_accounts`.`id`, `bt_orders`.`id`, `bt_orders`.`amount`, `bt_orders`.`date`, `bt_orders`.`payment_complete`, `bt_users`.`first_name`, `bt_users`.`last_name`, `bt_users`.`email_address`, `bt_users_account`.`first_name` AS account_first_name, `bt_users_account`.`last_name` AS account_last_name
FROM (`bt_orders`)
LEFT JOIN `bt_prices` ON `bt_prices`.`id` = `bt_orders`.`price_id`
LEFT JOIN `bt_accounts` ON `bt_accounts`.`id` = `bt_orders`.`account_id`
LEFT JOIN `bt_users` AS bt_users_account ON `bt_users_account`.`id` = `bt_accounts`.`primary_user_id`
LEFT JOIN `bt_salespeople` ON `bt_salespeople`.`id` = `bt_orders`.`salesperson_id`
LEFT JOIN `bt_users` ON `bt_users`.`id` = `bt_salespeople`.`user_id`
ORDER BY `bt_orders`.`id` desc
LIMIT 10