brauch hilfe bei mySQL

[gonzoMD]

SELECT
  journal.VRENUM,
  journal.KUN_NAME1,
  journal.KUN_NAME2,
  journal.KUN_NAME3,
  journal.INFO
FROM
  journalpos
 INNER JOIN journal ON (journalpos.JOURNAL_ID = journal.REC_ID)
 INNER JOIN (SELECT artikel.REC_ID FROM ARTIKEL WHERE MENGE_AKT >= 0) on (journalpos.ARTIKEL_ID = artikel.REC_ID)
WHERE
  (journal.QUELLE = 3) AND
  (journal.INFO IS NOT NULL) AND
  (journal.INFO >= '') AND
  (journal.INFO NOT LIKE '%vers%') AND
  (journal.INFO NOT LIKE '%storn%') AND
  (artikel.MENGE_AKT >= 0) AND
  (journal.VRENUM NOT LIKE '%STORNO%') AND
  ((journal.SHOP_STATUS = 1) OR
  (journal.SHOP_STATUS = 2))
GROUP BY VRENUM;