hup_sql

SELECT DISTINCT betardatum
       ,GROUP_CONCAT(DISTINCT (CASE WHEN (betardatum >= '$startdate 00:00:00'
                                     AND betardatum <= '$enddate 00:00:00')
                               THEN betarszam END) SEPARATOR ',') AS betarszam
       ,COUNT(betarszam) AS betarolva
      ,DISTINCT kitardatum
      ,GROUP_CONCAT(DISTINCT (CASE WHEN kitardatum <= '$enddate 00:00:00'
                                    AND kitardatum >= '$startdate 00:00:00'
                              THEN szlsz END) SEPARATOR ',') AS szlsz
      ,COUNT(szlsz) AS kitarolva
  FROM goods_in
 WHERE ((betardatum>='$startdate 00:00:00'
   AND betardatum <= '$enddate 00:00:00')
    OR (kitardatum <= '$enddate 00:00:00'
   AND kitardatum >= '$startdate 00:00:00'))
   AND supplier='$supplier'
   AND kikapcs = 0
   AND aruaz = szuloaz
 GROUP BY betardatum, kitardatum