X-Git-Url: http://mop.ddnsfree.com/gitweb/?p=brisk.git;a=blobdiff_plain;f=sql%2Fsql.d%2F910-usernet_devel.sql;h=9efb9f9603af7d8c4b5472a0d215daa4a81308c5;hp=d0822205c74fd79e1e3d8d151392283386229407;hb=a277a83b5415d5abc56625fd56d8f043cd77062f;hpb=dc35e3289fd4266bb12ed7c6ec5beab02c1a48de diff --git a/sql/sql.d/910-usernet_devel.sql b/sql/sql.d/910-usernet_devel.sql index d082220..9efb9f9 100644 --- a/sql/sql.d/910-usernet_devel.sql +++ b/sql/sql.d/910-usernet_devel.sql @@ -69,3 +69,5 @@ SELECT un.owner, ur.target, SUM(ur.skill * un.trust) AS num, SUM(un.trust) AS de SELECT us.login, pa.* FROM #PFX#usersnet_party pa, #PFX#users as us WHERE pa.target = us.code AND pa.owner = 10101; +SELECT * FROM #PFX#usersnet_widefriend ORDER BY owner, target, friend; +SELECT * FROM #PFX#usersnet_narrowfriend ORDER BY owner, target, friend;