Hallo zusammen,
gibt es eine Möglichkeit diese Select Abfrage zu einer zusammen zu legen.
gibt es eine Möglichkeit diese Select Abfrage zu einer zusammen zu legen.
Code:
select DATE_FORMAT (a.track_date, "%M") AS Monat, cl.name AS Kunde, SUM(a.count) as "Anzeigen" FROM nixq_banner_tracks a LEFT JOIN nixq_banners b ON (b.id = a.banner_id) LEFT JOIN nixq_banner_clients cl ON (cl.id = b.cid) LEFT JOIN nixq_categories c ON (c.id = b.catid) WHERE a.track_date >= '2018-01-01 00:00:00' AND a.track_date <= '2018-01-31 23:59:59' AND cl.id = '17' AND b.catid = '20' AND a.banner_id = '58' AND a.track_type = '1' Union select DATE_FORMAT (a.track_date, "%M") AS Monat, cl.name AS Kunde, SUM(a.count) as "klicks" FROM nixq_banner_tracks a LEFT JOIN nixq_banners b ON (b.id = a.banner_id) LEFT JOIN nixq_banner_clients cl ON (cl.id = b.cid) LEFT JOIN nixq_categories c ON (c.id = b.catid) WHERE a.track_date >= '2018-01-01 00:00:00' AND a.track_date <= '2018-01-31 23:59:59' AND cl.id = '17' AND b.catid = '20' AND a.banner_id = '58' AND a.track_type = '2'
Kommentar