SELECT
    l.i_rec,
    c.nn,
    c.time,
    c.info,
    c.type,
    c.source
FROM list AS l
JOIN content AS c
    ON l.i_dep = c.dep
   AND l.i_rec = c.rec
WHERE l.i_dep = ''
  AND l.dat1 <= '2025-12-12 15:45:13'
  AND l.dat2 >= '2025-12-12 15:45:13'
  AND c.time > 0
  AND (c.type = 0 OR c.type = 4)
ORDER BY l.i_rec, c.nn;
Nav ierakstu priekš i_dep =