[BioSQL-l] Problem listing all species(final nodes) of Fungi -Web example

[Peter Cock]

On Monday, October 8, 2012, alejandro wrote:

> Hi Peter,
>
> Sorry about spam, I had a connection problem and I thought the messages
> were not sent.
>
> I'm using MySQL 14.14
>
> mysql  Ver 14.14 Distrib 5.5.24, for debian-linux-gnu (x86_64) using
> readline 6.2
>
>
> BioSQL 1.0.1, just updated. The query I was running is the example
> provided on the web:
>
>  SELECT DISTINCT include.ncbi_taxon_id FROM taxon
>     INNER JOIN taxon AS include ON
>       (include.left_value BETWEEN taxon.left_value
>         AND taxon.right_value)
>  WHERE taxon.taxon_id IN
>    (SELECT taxon_id FROM taxon_name
>     WHERE name LIKE '%fungi%')
>
> The query doesn't work neither when I use MySQL Workbench nor through
> mysql console.
>
>
Hmm. I guess you'll have to do a little debugging,
for example breaking down the SQL statement into
smaller simpler queries and checking they are
giving sensible values. I would start with asking
for the count of rows in table taxon - perhaps
loading the taxonomy failed and the table is
still empty?

Peter