#SET GLOBAL myisam_stats_method = nulls_equal; -> does NOT help
#CHECK TABLE drdat, mitarbeiter, firma, stadt, fsdaten, fahrt;

# does not come back without straigh_join
# ft has to come AFTER dstop.

EXPLAIN
SELECT
  #STRAIGHT_JOIN
  f.name AS drdat_firma_name, s.name AS drdat_stadt_name, f.rechnung_vor_tag AS drdat_rechnung_vor_tag, d.firma_id AS drdat_firma_id , d.stadt_id AS drdat_stadt_id , d.mnr_id AS drdat_mnr_id , d.abrechnungstyp AS drdat_abrechnungstyp, d.druckdatum AS drdat_druckdatum_alt , d.fahrten_von  AS drdat_fahrten_von_alt, d.fahrten_bis  AS drdat_fahrten_bis_alt, IF(fs.drdat_tag IS NULL OR fs.drdat_intervall_einheit='D', IF(fs.drdat_intervall_einheit='M', ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), IF(fs.drdat_intervall_einheit='W', ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall DAY))), IF(fs.drdat_intervall_einheit='M', IF(GREATEST(ADDDATE(d.druckdatum, INTERVAL 10 DAY), IFNULL(d.fahrten_bis,'0000-00-00')) > IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0'))), ADDDATE(IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0'))),INTERVAL fs.drdat_intervall MONTH), IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')))), IF(GREATEST(ADDDATE(d.druckdatum, INTERVAL 3 DAY),IFNULL(d.fahrten_bis,'0000-00-00')) > IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY)), ADDDATE(IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY)),INTERVAL fs.drdat_intervall*7 DAY), IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY))))) AS drdat_druckdatum
, IF(IF(fs.drdat_tag IS NULL OR fs.drdat_intervall_einheit='D', IF(fs.drdat_intervall_einheit='M', ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), IF(fs.drdat_intervall_einheit='W', ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall DAY))), IF(fs.drdat_intervall_einheit='M', IF(GREATEST(ADDDATE(d.druckdatum, INTERVAL 10 DAY), IFNULL(d.fahrten_bis,'0000-00-00')) > IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0'))), ADDDATE(IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0'))),INTERVAL fs.drdat_intervall MONTH), IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')))), IF(GREATEST(ADDDATE(d.druckdatum, INTERVAL 3 DAY),IFNULL(d.fahrten_bis,'0000-00-00')) > IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY)), ADDDATE(IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY)),INTERVAL fs.drdat_intervall*7 DAY), IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY))))) > NOW(), 'zukuenftig','zu_starten') AS drdat_status
, ADDDATE(d.fahrten_bis, INTERVAL 1 DAY) AS drdat_fahrten_von
, IF(fs.drdat_intervall_einheit='M', IF(DAYOFMONTH(IF(fs.drdat_tag IS NULL OR fs.drdat_intervall_einheit='D', IF(fs.drdat_intervall_einheit='M', ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), IF(fs.drdat_intervall_einheit='W', ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall DAY))), IF(fs.drdat_intervall_einheit='M', IF(GREATEST(ADDDATE(d.druckdatum, INTERVAL 10 DAY), IFNULL(d.fahrten_bis,'0000-00-00')) > IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0'))), ADDDATE(IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0'))),INTERVAL fs.drdat_intervall MONTH), IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')))), IF(GREATEST(ADDDATE(d.druckdatum, INTERVAL 3 DAY),IFNULL(d.fahrten_bis,'0000-00-00')) > IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY)), ADDDATE(IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY)),INTERVAL fs.drdat_intervall*7 DAY), IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY)))))) >= f.rechnung_vor_tag, SUBDATE(CONCAT(DATE_FORMAT(IF(fs.drdat_tag IS NULL OR fs.drdat_intervall_einheit='D', IF(fs.drdat_intervall_einheit='M', ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), IF(fs.drdat_intervall_einheit='W', ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall DAY))), IF(fs.drdat_intervall_einheit='M', IF(GREATEST(ADDDATE(d.druckdatum, INTERVAL 10 DAY), IFNULL(d.fahrten_bis,'0000-00-00')) > IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0'))), ADDDATE(IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0'))),INTERVAL fs.drdat_intervall MONTH), IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')))), IF(GREATEST(ADDDATE(d.druckdatum, INTERVAL 3 DAY),IFNULL(d.fahrten_bis,'0000-00-00')) > IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY)), ADDDATE(IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY)),INTERVAL fs.drdat_intervall*7 DAY), IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY))))),'%Y-%m-'),LPAD(f.rechnung_vor_tag,2,'0')), INTERVAL 1 DAY), SUBDATE(CONCAT(DATE_FORMAT(SUBDATE(IF(fs.drdat_tag IS NULL OR fs.drdat_intervall_einheit='D', IF(fs.drdat_intervall_einheit='M', ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), IF(fs.drdat_intervall_einheit='W', ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall DAY))), IF(fs.drdat_intervall_einheit='M', IF(GREATEST(ADDDATE(d.druckdatum, INTERVAL 10 DAY), IFNULL(d.fahrten_bis,'0000-00-00')) > IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0'))), ADDDATE(IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0'))),INTERVAL fs.drdat_intervall MONTH), IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')))), IF(GREATEST(ADDDATE(d.druckdatum, INTERVAL 3 DAY),IFNULL(d.fahrten_bis,'0000-00-00')) > IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY)), ADDDATE(IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY)),INTERVAL fs.drdat_intervall*7 DAY), IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY))))), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(f.rechnung_vor_tag,2,'0')), INTERVAL 1 DAY)), IF(fs.drdat_intervall_einheit='W', SUBDATE(IF(fs.drdat_tag IS NULL OR fs.drdat_intervall_einheit='D', IF(fs.drdat_intervall_einheit='M', ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), IF(fs.drdat_intervall_einheit='W', ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall DAY))), IF(fs.drdat_intervall_einheit='M', IF(GREATEST(ADDDATE(d.druckdatum, INTERVAL 10 DAY), IFNULL(d.fahrten_bis,'0000-00-00')) > IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0'))), ADDDATE(IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0'))),INTERVAL fs.drdat_intervall MONTH), IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')))), IF(GREATEST(ADDDATE(d.druckdatum, INTERVAL 3 DAY),IFNULL(d.fahrten_bis,'0000-00-00')) > IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY)), ADDDATE(IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY)),INTERVAL fs.drdat_intervall*7 DAY), IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY))))), INTERVAL MOD(DAYOFWEEK(IF(fs.drdat_tag IS NULL OR fs.drdat_intervall_einheit='D', IF(fs.drdat_intervall_einheit='M', ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), IF(fs.drdat_intervall_einheit='W', ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall DAY))), IF(fs.drdat_intervall_einheit='M', IF(GREATEST(ADDDATE(d.druckdatum, INTERVAL 10 DAY), IFNULL(d.fahrten_bis,'0000-00-00')) > IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0'))), ADDDATE(IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0'))),INTERVAL fs.drdat_intervall MONTH), IF(DAYOFMONTH(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH))<fs.drdat_tag, CONCAT(DATE_FORMAT(SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH), INTERVAL 1 MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')),CONCAT(DATE_FORMAT(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall MONTH),'%Y-%m-'),LPAD(fs.drdat_tag,2,'0')))), IF(GREATEST(ADDDATE(d.druckdatum, INTERVAL 3 DAY),IFNULL(d.fahrten_bis,'0000-00-00')) > IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY)), ADDDATE(IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY)),INTERVAL fs.drdat_intervall*7 DAY), IF(DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))<fs.drdat_tag, SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL 7-(fs.drdat_tag-DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))) DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY), INTERVAL DAYOFWEEK(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall*7 DAY))-fs.drdat_tag DAY))))))-f.rechnung_vor_tag+13, 7)+1 DAY), SUBDATE(ADDDATE(d.druckdatum, INTERVAL fs.drdat_intervall DAY), INTERVAL f.rechnung_vor_tag DAY))) AS drdat_fahrten_bis
, d.vb AS drdat_vb_alt, NULL AS drdat_gesetzt_am, NULL AS drdat_gesetzt_von_id, NULL AS drdat_gesetzt_von_name, NULL AS drdat_massen_am, NULL AS drdat_massen_von_id, NULL AS drdat_massen_von_name, NULL AS drdat_verbucht_am, NULL AS drdat_verbucht_von_id, NULL AS drdat_verbucht_von_name, NULL AS drdat_faktura_am, NULL AS drdat_faktura_von_id, NULL AS drdat_faktura_von_name, NULL AS drdat_liquiditaet_am, NULL AS drdat_liquiditaet_von_id, NULL AS drdat_liquiditaet_von_name, NULL AS drdat_bemerkung, fs.debimanagement AS drdat_debimanagement 
FROM drdat d
  LEFT JOIN mitarbeiter sb_mit ON d.erstellt_von_id=sb_mit.id  
  LEFT JOIN mitarbeiter mas_mit ON d.massenrechnungen_von_id=mas_mit.id  
  LEFT JOIN mitarbeiter vb_mit ON d.verbucht_von_id=vb_mit.id  
  LEFT JOIN mitarbeiter fk_mit ON d.faktura_von_id=fk_mit.id  
  LEFT JOIN mitarbeiter lq_mit ON d.liquiditaet_von_id=lq_mit.id  
 INNER JOIN firma f ON d.firma_id=f.id  
 INNER JOIN stadt s ON d.stadt_id=s.id  
 INNER JOIN fsdaten fs ON d.firma_id=fs.firma_id AND d.stadt_id=fs.stadt_id
                                                 AND d.stadt_id=fs.abr_stadt_id
  LEFT JOIN drdat dstop ON d.firma_id=dstop.firma_id AND d.stadt_id=dstop.stadt_id
                                                     AND d.druckdatum<dstop.druckdatum
                                                     AND dstop.abrechnungstyp='MASSEN'
 INNER JOIN fsdaten fst USE INDEX (firma_id) ON fst.firma_id=d.firma_id AND fst.abr_stadt_id=d.stadt_id
 INNER JOIN fahrt ft ON ft.firma_id=d.firma_id AND ft.firma_id=fst.firma_id
                                               AND ft.stadt_id=fst.stadt_id
                                               AND ft.druckdatum='0000-00-00'
                                               AND ft.drdat_id IS NULL
WHERE d.druckdatum!='1910-10-10'
  AND d.druckdatum!='1911-11-11'
  AND d.druckdatum!='1912-12-12'
  AND d.abrechnungstyp='MASSEN'
  AND dstop.id IS NULL
  AND fs.stadt_id=fs.abr_stadt_id
  AND d.firma_id IN (1,2,3,4,5,9,10,11,12,99,100,102,103,104,111,200,201,202,203,204,205,206,209,300,302,328,329,330,331,332,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,500,501,1000,2000,3000,4000,5000,5100,5200,5300,5500,6000,7000,8000)
GROUP BY d.firma_id, d.stadt_id,drdat_druckdatum
HAVING drdat_druckdatum < ADDDATE(NOW(), INTERVAL 20 DAY)
   AND drdat_status IN ('zu_starten')
ORDER BY drdat_druckdatum
;
/*

# Without straight_join

+----+-------------+---------+--------+---------------------------------------------+------------+---------+-----------------------------------------------+------+----------------------------------------------+
| id | select_type | table   | type   | possible_keys                               | key        | key_len | ref                                           | rows | Extra                                        |
+----+-------------+---------+--------+---------------------------------------------+------------+---------+-----------------------------------------------+------+----------------------------------------------+
| 1  | SIMPLE      | fst     | ALL    | firma_id                                    |            |         |                                               | 325  | Using where; Using temporary; Using filesort |
| 1  | SIMPLE      | s       | eq_ref | PRIMARY                                     | PRIMARY    | 4       | dbrent.fst.abr_stadt_id                       | 1    |                                              |
| 1  | SIMPLE      | fs      | eq_ref | PRIMARY,firma_id                            | PRIMARY    | 8       | dbrent.fst.firma_id,dbrent.s.id               | 2    | Using where                                  |
| 1  | SIMPLE      | f       | eq_ref | PRIMARY                                     | PRIMARY    | 4       | dbrent.fs.firma_id                            | 1    | Using where                                  |
| 1  | SIMPLE      | ft      | ref    | druckdatum,drdat_id_rechnung_neu,neu_relauf | neu_relauf | 13      | dbrent.fst.firma_id,const,dbrent.fst.stadt_id | 8    | Using where                                  |
| 1  | SIMPLE      | d       | ref    | uniqueindex,firma_id                        | firma_id   | 8       | dbrent.fs.firma_id,dbrent.fs.abr_stadt_id     | 115  | Using where                                  |
| 1  | SIMPLE      | dstop   | ref    | uniqueindex,firma_id                        | firma_id   | 8       | dbrent.f.id,dbrent.s.id                       | 115  | Using where; Not exists                      |
| 1  | SIMPLE      | sb_mit  | eq_ref | PRIMARY                                     | PRIMARY    | 4       | dbrent.d.erstellt_von_id                      | 1    | Using index                                  |
| 1  | SIMPLE      | mas_mit | eq_ref | PRIMARY                                     | PRIMARY    | 4       | dbrent.d.massenrechnungen_von_id              | 1    | Using index                                  |
| 1  | SIMPLE      | vb_mit  | eq_ref | PRIMARY                                     | PRIMARY    | 4       | dbrent.d.verbucht_von_id                      | 1    | Using index                                  |
| 1  | SIMPLE      | fk_mit  | eq_ref | PRIMARY                                     | PRIMARY    | 4       | dbrent.d.faktura_von_id                       | 1    | Using index                                  |
| 1  | SIMPLE      | lq_mit  | eq_ref | PRIMARY                                     | PRIMARY    | 4       | dbrent.d.liquiditaet_von_id                   | 1    | Using index                                  |
+----+-------------+---------+--------+---------------------------------------------+------------+---------+-----------------------------------------------+------+----------------------------------------------+

# With straight_join

+----+-------------+---------+--------+---------------------------------------------+------------+---------+-----------------------------------------------+------+----------------------------------------------+
| id | select_type | table   | type   | possible_keys                               | key        | key_len | ref                                           | rows | Extra                                        |
+----+-------------+---------+--------+---------------------------------------------+------------+---------+-----------------------------------------------+------+----------------------------------------------+
| 1  | SIMPLE      | d       | ALL    | uniqueindex,firma_id                        |            |         |                                               | 8616 | Using where; Using temporary; Using filesort |
| 1  | SIMPLE      | sb_mit  | eq_ref | PRIMARY                                     | PRIMARY    | 4       | dbrent.d.erstellt_von_id                      | 1    | Using index                                  |
| 1  | SIMPLE      | mas_mit | eq_ref | PRIMARY                                     | PRIMARY    | 4       | dbrent.d.massenrechnungen_von_id              | 1    | Using index                                  |
| 1  | SIMPLE      | vb_mit  | eq_ref | PRIMARY                                     | PRIMARY    | 4       | dbrent.d.verbucht_von_id                      | 1    | Using index                                  |
| 1  | SIMPLE      | fk_mit  | eq_ref | PRIMARY                                     | PRIMARY    | 4       | dbrent.d.faktura_von_id                       | 1    | Using index                                  |
| 1  | SIMPLE      | lq_mit  | eq_ref | PRIMARY                                     | PRIMARY    | 4       | dbrent.d.liquiditaet_von_id                   | 1    | Using index                                  |
| 1  | SIMPLE      | f       | ALL    | PRIMARY                                     |            |         |                                               | 45   | Using where                                  |
| 1  | SIMPLE      | s       | eq_ref | PRIMARY                                     | PRIMARY    | 4       | dbrent.d.stadt_id                             | 2    |                                              |
| 1  | SIMPLE      | fs      | eq_ref | PRIMARY,firma_id                            | PRIMARY    | 8       | dbrent.f.id,dbrent.d.stadt_id                 | 2    | Using where                                  |
| 1  | SIMPLE      | dstop   | ref    | uniqueindex,firma_id                        | firma_id   | 8       | dbrent.f.id,dbrent.s.id                       | 115  | Using where; Not exists                      |
| 1  | SIMPLE      | fst     | ref    | firma_id                                    | firma_id   | 8       | dbrent.d.firma_id,dbrent.fs.abr_stadt_id      | 5    | Using where                                  |
| 1  | SIMPLE      | ft      | ref    | druckdatum,drdat_id_rechnung_neu,neu_relauf | neu_relauf | 13      | dbrent.fst.firma_id,const,dbrent.fst.stadt_id | 8    | Using where                                  |
+----+-------------+---------+--------+---------------------------------------------+------------+---------+-----------------------------------------------+------+----------------------------------------------+
*/