SELECT R.id, R.date_arr, R.supplier
FROM (
  SELECT MIN(G.date_arr) as date_arr, G.supplier, G.id
  FROM tl_order_good G
  WHERE G.date_arr IS NOT NULL AND G.supplier != '' AND G.supplier != 3629
  GROUP BY G.date_arr, supplier
) T
LEFT JOIN (
    SELECT *
    FROM tl_order_good N
    WHERE N.date_arr IS NOT NULL AND N.supplier != '' AND N.supplier != 3629
    ORDER BY N.date_arr
          ) R ON R.supplier = T.supplier

SELECT R.id, R.date_arr, R.supplier
FROM (
  SELECT DISTINCT K.supplier
  FROM (SELECT MIN(G.date_arr), G.supplier
        FROM tl_order_good G
        WHERE G.date_arr IS NOT NULL AND G.supplier != '' AND G.supplier != 3629
        GROUP BY G.date_arr, G.supplier) K
) T
LEFT JOIN (
    SELECT *
    FROM tl_order_good N
    WHERE N.date_arr IS NOT NULL AND N.supplier != '' AND N.supplier != 3629
    ORDER BY N.date_arr
          ) R ON R.supplier = T.supplier
LIMIT 0, 500