FLOW
Follow FLOW:
TwitterFacebook
Families Genera Species Names Vernacular names Publications Authors Geographical distribution Associated taxa Fossils Images Type specimens repositories Synopsis Updates contactProjectFulgoromorpha
English
English
Content-type: text/html

Software error:

Could'nt execute sql request: ERROR:  more than one row returned by a subquery used as an expression
--SELECT	nc.index,
							nc.orthographe, 
							nc.autorite, 
							nc.ref_publication_princeps,
							n.orthographe, 
							n.ref_rang,
							n.ref_nom_parent,
							n.page_princeps,
							r.ordre,
							t.distribution_complete,
							t.plantes_completes,
							t.ref_rang,
							n.fossil,
							n.gen_type,
							td.en,
							td.en,
							n.ref_publication_designation,
							n.page_designation,
							(SELECT nom FROM auteurs where index = (SELECT ref_auteur FROM noms_x_auteurs WHERE ref_nom = nc.index AND position = 1)),
							txn.nom_label,
							(select get_parent_by_name(txn.ref_nom, 'family', 'notfull')),
							(select get_parent_by_name(txn.ref_nom_cible, 'family', 'notfull'))
							FROM noms_complets AS nc 
							LEFT JOIN noms AS n ON n.index = nc.index
							LEFT JOIN taxons_x_noms AS txn ON txn.ref_nom = nc.index
							LEFT JOIN taxons AS t ON t.index = txn.ref_taxon
							LEFT JOIN rangs AS r ON r.index = t.ref_rang
							LEFT JOIN types_designation AS td ON td.index = n.ref_type_designation
							WHERE t.index = 5085
							AND txn.ref_statut = 1;--

For help, please send mail to the webmaster (admin@example.com), giving this error message and the time and date of the error.