evo ovo radi
PreuzmiIzvorni kôd (SQL):
SELECT t1.datum, t1.kg, t1.voce FROM prodaja AS t1 INNER JOIN prodaja AS t2 ON t1.kg = t2.kg AND t1.datum = t2.datum WHERE TRIM(t2.voce)='jabuka' AND (TRIM(t2.kg) <> '0' OR TRIM(t1.voce)='jabuka') ORDER BY t1.datum LIMIT 1000