gistfile1.php

ORM::for_table('orders')
    ->select('users.fb_uid')
    ->select('order_items.quantity')
    ->join('users', array('users.id', '=', 'orders.user_id'))
    ->join('user_settings', 'user_settings.user_id', '=', 'orders.user_id')
    ->join('order_items', 'order_items.order_id', '=', 'orders.id')
    ->where('order_items.deleted', false)
    ->where('user_settings.store_id', $store_id)
    ->find_many();