PHP код:
// sql (Top 10)
SELECT * FROM `fe_users` WHERE pid = 30 AND disable = 0 AND deleted = 0 ORDER BY lastlogin DESC LIMIT 10
// xDbMySQL (Top 10)
$rows = DB::run()->table("fe_users")->select('*')->wherePid(30)->orderDesc('lastlogin')->limit(10)->exec();
print_r($rows);