$testthis = DB::table('orders')
    ->join('transactions_paypal', function($join) {
        $join->on('orders.trans_ordercode', '=', 'transactions_paypal.hash')
            ->where('transactions_paypal.complete', true);
    })
    ->join('transactions_worldpay', function($join) {
        $join->on('orders.trans_ordercode', '=', 'transactions_worldpay.hash')
            ->where('transactions_worldpay.complete', true);
    })
//    ->join('transactions_worldpay', 'orders.trans_ordercode', '=', 'transactions_worldpay.hash')
    ->select('orders.*', 'transactions_paypal.complete')
//    ->whereNotNull('transactions_paypal.complete')
    ->get();