/* Look for pg_query_params() in the code */ SELECT count(*) FROM "Accepted_Names" AS a LEFT JOIN "Synonyms" AS b ON a.unicod=b.an_unicod WHERE lower(a.genus || ' ' || a.species || ' ' || a.infraspecies) LIKE lower('$1') OR lower(b.genus || ' ' || b.species || ' ' || b.infraspecies) LIKE lower('$1') LIMIT $2 OFFSET $3 ;