1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| SELECT t.gid_persons AS source,
(
select t3.count_publications
from count_publications_by_persons t3,
count_publications_by_persons t4
WHERE t3.count_publications > t4.count_publications
) as weight_source,
t1.gid_persons AS target,
(
select t3.count_publications
from count_publications_by_persons t3,
count_publications_by_persons t4
WHERE t3.count_publications < t4.count_publications
) as weight_target,
t.gid_publications
FROM personstopublications t,
personstopublications t1,
count_publications_by_persons t3,
count_publications_by_persons t4
WHERE t1.gid_persons > t.gid_persons
AND t.gid_publications = t1.gid_publications; |
Partager