SELECT app_id, app_name
	FROM app a
  LEFT JOIN `pos` p ON (pos_app = app_id)
  LEFT JOIN `exp` e ON (exp_app = app_id)
  LEFT JOIN `tde` t ON (tde_app = app_id)
  LEFT JOIN `rec` r ON (rec_app = app_id)
  WHERE app_date BETWEEN '06-11-23 08:00:00' AND '07-11-24 08:00:00'
  AND app_state = 22
  AND pos_pos = 10
  GROUP BY app_id
  LIMIT 0, 10

-- Returns 2 rows

SELECT app_id, app_name, GROUP_CONCAT(DISTINCT exp_type)
	FROM app a
  LEFT JOIN `pos` p ON (pos_app = app_id)
  LEFT JOIN `exp` e ON (exp_app = app_id)
  LEFT JOIN `tde` t ON (tde_app = app_id)
  LEFT JOIN `rec` r ON (rec_app = app_id)
  WHERE app_date BETWEEN '06-11-23 08:00:00' AND '07-11-24 08:00:00'
  AND app_state = 22
  AND pos_pos = 10
  GROUP BY app_id
  LIMIT 0, 10

-- Returns 1 row