MariaDB [monkey]> select f.name ,  concat(concat(f.lat,','),lon) coord , IF(f.sponsor = 0,IF(park is not null,park,'NoEx'),'Sponso') TypeEX  from forts f where f.id not in ( select fort_id from raids ) ;
+-------------------------------------+------------------------------------+--------+
| name                                | coord                              | TypeEX |
+-------------------------------------+------------------------------------+--------+
| Monument aux morts de Colombes      | 48.92330700000000,2.25030400000000 | NoEx   |
| Le vieux clocher de Colombes        | 48.92331900000000,2.25260400000000 | NoEx   |
| Mairie de Colombes                  | 48.92232500000000,2.25443500000000 | NoEx   |
| Mémorial Pour La Résistance 39-45   | 48.92186300000000,2.24086200000000 | NoEx   |
| Aire de jeu République              | 48.92109100000000,2.24767800000000 | NoEx   |
| Aux Morts Pour La France            | 48.92182700000000,2.24413700000000 | NoEx   |
| Le Souffle de la Création           | 48.92282100000000,2.25712100000000 | NoEx   |
+-------------------------------------+------------------------------------+--------+
7 rows in set (0.00 sec)