SELECT tu.userid as me_userid, ou.userid as other_userid, vu.username as other_username, trans.inventid, trans.ip, trans.time, tu.transid, trans_type.id as transtypeid, trans_type.name as transtype, amount, store_items.name as item FROM toribash_com.trans, toribash_com.trans_type, toribash_com.store_items, toribash_com.trans_user as tu, toribash_com.trans_user as ou, vbb_user as vu WHERE toribash_com.trans.id = tu.transid AND toribash_com.trans.id = ou.transid AND ou.trans_typeid = toribash_com.trans_type.id AND tu.userid=1879706 AND vu.userid=ou.userid AND ou.userid <> 1879706 AND toribash_com.store_items.itemid = toribash_com.trans.itemid AND trans.id > 6333018 - 1000000 ORDER BY time desc LIMIT 30