Select geoJSON string from fix DB

CALL toGeoJSON(sender);

SELECT
  CONCAT('{
    "type": "LineString",
    "coordinates": [',
      `linestring`,
    '],
    "properties": {
      "name": ', `quoted_sender`, ',
      "popupContent": ', `quoted_sender`,
    '}}') as `geoJSON`
FROM (
  SELECT
    `sender`,
    CONCAT('"', `sender`, '"') as `quoted_sender`,
    GROUP_CONCAT(CONCAT('[', longitude, ',', latitude, ']')
      ORDER BY time ASC SEPARATOR ', ') as `linestring`
  FROM `beats`
    WHERE sender = 'lunch1'
      GROUP BY sender
) as `geometry`;

toGeoJSON('sender')

SELECT
  CONCAT('{
    "type": "LineString",
    "coordinates": [',
      `linestring`,
    '],
    "properties": {
      "name": ', `quoted_sender`, ',
      "popupContent": ', `quoted_sender`,
    '}}') as `geoJSON`
FROM (
  SELECT
    `sender`,
    CONCAT('"', `sender`, '"') as `quoted_sender`,
    GROUP_CONCAT(CONCAT('[', longitude, ',', latitude, ']')
      ORDER BY time ASC SEPARATOR ', ') as `linestring`
  FROM `beats`
    WHERE sender = 'lunch1'
      GROUP BY sender
) as `geometry`;