$query = $db->query("SELECT *, u.specifiedusers LIKE '%\t$username\t%' AS specifieduser FROM $table_members m
                        LEFT JOIN $table_usergroups u ON u.specifiedusers LIKE '%\t$username\t%' OR (u.status=m.status AND ((u.creditshigher='0' AND u.creditslower='0' AND u.specifiedusers='') OR (m.credit>=u.creditshigher AND m.credit<u.creditslower)))
                        WHERE username='$username' ORDER BY specifieduser DESC");
$memberinfo = $db->fetch_array($query);