Catalog queries incorrectly restrict to a single station_number

[nmclrn]

The catalog queries all make use of the following subquery:

     JOIN (SELECT
                Station.station_num as station_num,
                Station.user as station_user,
                Observer.id as obs_id,
                Observer.eth_addr as eth_addr,
                Observer.name as user_name
                FROM Station,Observer
                WHERE Station.user = Observer.id
                LIMIT 1) Obs ON ParsedIOD.station_number = Obs.station_num

I think the LIMIT 1 here is a bug. It has the effect of limiting the whole catalog result set to a single station number (on my DB, ParsedIOD.station_number = 2420), which I don’t think is what we want. I believe I’ve inadvertently fixed some cases as part of query optimization, but other cases need attention.

[nmclrn]

Fixed by #18