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 rowsSELECT 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