justinlittman
commented
5 years ago The problem is caused by people without names (#356) as shown below:
rialtostaging=> SELECT p2i.country as country, p1.name as name, p2i.name as collab_name, p2i.uri, pub.metadata ->> 'title' as title, pub.metadata -> 'created_year' as created_year FROM people p1 LEFT OUTER JOIN people_publications pp ON p1.uri = pp.person_uri LEFT OUTER JOIN publications pub ON pp.publication_uri = pub.uri LEFT OUTER JOIN people_publications pp2 ON pub.uri = pp2.publication_uri LEFT OUTER JOIN (SELECT p2.uri, p2.name, p2ia.value as country FROM people p2, jsonb_array_elements_text(CASE WHEN jsonb_array_length(p2.metadata -> 'country_labels') > 0 THEN p2.metadata -> 'country_labels' ELSE '["Unknown"]' END) p2ia) p2i ON pp2.person_uri = p2i.uri WHERE p2i.uri != p1.uri AND p1.metadata -> 'schools' ? 'http://sul.stanford.edu/rialto/agents/orgs/school-of-engineering' AND p2i.country = 'Vietnam' ORDER BY p2i.country;
country | name | collab_name | uri |
title | created_year
---------+------------------+--------------------+-------------------------------------------------------------------------------+---------------
-----------------------------------------------------------------------------------------------------------------+--------------
Vietnam | Brian Rossi | Kenji Abe | http://sul.stanford.edu/rialto/agents/people/28af6f1ad58d150f035dc0d002919b00 | Search for CP
Violation in Neutrino and Antineutrino Oscillations by the T2K Experiment with 2.2 x 10(21) Protons on Target | 2018
Vietnam | Yinan Wang | Kenji Abe | http://sul.stanford.edu/rialto/agents/people/28af6f1ad58d150f035dc0d002919b00 | Search for CP
Violation in Neutrino and Antineutrino Oscillations by the T2K Experiment with 2.2 x 10(21) Protons on Target | 2018
Vietnam | Gary Glover | Hien M. Nguyen | http://sul.stanford.edu/rialto/agents/people/76627e6643f70ff1d8c834bc9d5db90c | Sparsely Sampl
ed functional Magnetic Resonance Imaging Using Low-rank and Sparsity Constraints | 2014
Vietnam | Ramesh Johari | | http://sul.stanford.edu/rialto/agents/people/ee1fb37a14c91deda5f62c092d9224e0 | Heavy Traffic
Approximation of Equilibria in Resource Sharing Games | 2012
Vietnam | Fan Zhang | | http://sul.stanford.edu/rialto/agents/people/0e38ecda4d067d86ae17b95a4ffb07ac | A global refer
ence for human genetic variation | 2015
Vietnam | Zhenzhen Weng | Christian G. Meyer | http://sul.stanford.edu/rialto/agents/people/579b36d97232106241af812ee261c5a7 | The Laser cali
bration of the ATLAS Tile Calorimeter during the LHC run 1 | 2016
Vietnam | Gary Glover | Hien M. Nguyen | http://sul.stanford.edu/rialto/agents/people/76627e6643f70ff1d8c834bc9d5db90c | A Modified Gen
eralized Series Approach: Application to Sparsely Sampled fMRI | 2013
Vietnam | Wei-Min Wu | | http://sul.stanford.edu/rialto/agents/people/cfab1a039ab05029fba718bc9787b35f | Methanogenesis
Facilitated by Geobiochemical Iron Cycle in a Novel Syntrophic Methanogenic Microbial Community | 2013
Vietnam | Gabriel Martinez | | http://sul.stanford.edu/rialto/agents/people/1fe5bb9bcb38f6f9b3cbcf7e9b8f4eb9 | Trends in futu
re health financing and coverage: future health spending and universal health coverage in 188 countries, 2016-40 | 2018
Vietnam | Gabriel Martinez | | http://sul.stanford.edu/rialto/agents/people/47d6bb393f76f140d590d29cd9b51b87 | Trends in futu
re health financing and coverage: future health spending and universal health coverage in 188 countries, 2016-40 | 2018
Vietnam | Gabriel Martinez | | http://sul.stanford.edu/rialto/agents/people/4cee1724f0f437825f1e82d2c985fada | Trends in futu
re health financing and coverage: future health spending and universal health coverage in 188 countries, 2016-40 | 2018
Vietnam | Gabriel Martinez | | http://sul.stanford.edu/rialto/agents/people/83fdde244b067902151007aa879c1066 | Trends in futu
re health financing and coverage: future health spending and universal health coverage in 188 countries, 2016-40 | 2018
Vietnam | David Golden | | http://sul.stanford.edu/rialto/agents/people/e65f9ebd743e5f1aca811cfcfd588e0f | Reactions of O
H with Butene Isomers: Measurements of the Overall Rates and a Theoretical Study | 2011
Vietnam | David Davidson | | http://sul.stanford.edu/rialto/agents/people/e65f9ebd743e5f1aca811cfcfd588e0f | Reactions of O
H with Butene Isomers: Measurements of the Overall Rates and a Theoretical Study | 2011
Vietnam | Ronald Hanson | | http://sul.stanford.edu/rialto/agents/people/e65f9ebd743e5f1aca811cfcfd588e0f | Reactions of O
H with Butene Isomers: Measurements of the Overall Rates and a Theoretical Study | 2011
Vietnam | Chengliang Fan | | http://sul.stanford.edu/rialto/agents/people/005a1c90de47e18e7fecd46c4060da15 | Comprehensive
molecular portraits of human breast tumours | 2012
Vietnam | Chengliang Fan | | http://sul.stanford.edu/rialto/agents/people/40554173f63e955ba5d6c7c8e79b449b | Comprehensive
molecular portraits of human breast tumours | 2012
(17 rows)
Perhaps due to inner join in detail query?
e.g.