Signalements - Il reste des signalements à passer en façade

[louptheron]

Ces navires ne sont pas trouvés dans la table vessels.

SELECT id, internal_reference_number, vessel_name, vessel_id, value->>'seaFront' FROM reportings WHERE value->>'seaFront' IN ('OUTREMEROI', 'OUTREMEROA');
  id   | internal_reference_number | vessel_name  | vessel_id |  ?column?  
-------+---------------------------+--------------+-----------+------------
  4938 | FRA000425127              | AMAZONE      |   1218115 | OUTREMEROA
 39186 | FRA000925754              | TREVIGNON    |   1245696 | OUTREMEROI
 35201 | FRA000919640              | KRACHE DI FE |   1243179 | OUTREMEROA
 53992 | FRA000931030              | HAIRI DJEMA  |   1717624 | OUTREMEROI
 53993 | FRA000930819              | JAGUAR       |   1711061 | OUTREMEROI
 57990 | FRA000930819              | JAGUAR       |   1711061 | OUTREMEROI
(6 rows)