Pünktliche und zuverlässige Entsorgung von Restmüll, Schadstoffen und Sperrmüll.
$this->db->replacePrefix((string) $query):
SELECT `routen`.`Jahr`
FROM `yk395_abhol_routen` AS `routen`
LEFT JOIN `yk395_abhol_route_ort_strasse` AS `ros` ON `ros`.`RouteID` = `routen`.`RouteID`
LEFT JOIN `yk395_abhol_ort` AS `orte` ON `orte`.`OrtID` = `ros`.`OrtID` AND `orte`.`Geloescht` IS NULL
LEFT JOIN `yk395_abhol_strassen` AS `strassen` ON (`strassen`.`StrasseID` = `ros`.`StrasseID` OR (`ros`.`StrasseID` = 0 AND `strassen`.`OrtID` = `orte`.`OrtID`)) AND `orte`.`NaherholGebiet` IS NULL AND `strassen`.`Geloescht` IS NULL
WHERE `routen`.`Geloescht` IS NULL AND `orte`.`OrtID` IS NOT NULL AND `routen`.`RouteID` IN (SELECT RouteID FROM yk395_abhol_routen_plan GROUP BY RouteID) AND `routen`.`Jahr`='2023' AND (`orte`.`NaherholGebiet`IS NULL OR `orte`.`NaherholGebiet`!='1')
GROUP BY `routen`.`Jahr`
ORDER BY `routen`.`Jahr` ASC
$this->db->replacePrefix((string) $query):
SELECT `orte`.`OrtID`, `orte`.`Ort`
FROM `yk395_abhol_routen` AS `routen`
LEFT JOIN `yk395_abhol_route_ort_strasse` AS `ros` ON `ros`.`RouteID` = `routen`.`RouteID`
LEFT JOIN `yk395_abhol_ort` AS `orte` ON `orte`.`OrtID` = `ros`.`OrtID` AND `orte`.`Geloescht` IS NULL
LEFT JOIN `yk395_abhol_strassen` AS `strassen` ON (`strassen`.`StrasseID` = `ros`.`StrasseID` OR (`ros`.`StrasseID` = 0 AND `strassen`.`OrtID` = `orte`.`OrtID`)) AND `orte`.`NaherholGebiet` IS NULL AND `strassen`.`Geloescht` IS NULL
WHERE `routen`.`Geloescht` IS NULL AND `orte`.`OrtID` IS NOT NULL AND `routen`.`RouteID` IN (SELECT RouteID FROM yk395_abhol_routen_plan GROUP BY RouteID) AND `routen`.`Jahr`='2023' AND (`orte`.`NaherholGebiet`IS NULL OR `orte`.`NaherholGebiet`!='1')
GROUP BY `orte`.`OrtID`, `orte`.`Ort`
ORDER BY `orte`.`Ort` ASC
$this->db->replacePrefix((string) $query):
SELECT `strassen`.`StrasseID`, `strassen`.`StrasseNr`
FROM `yk395_abhol_routen` AS `routen`
LEFT JOIN `yk395_abhol_route_ort_strasse` AS `ros` ON `ros`.`RouteID` = `routen`.`RouteID`
LEFT JOIN `yk395_abhol_ort` AS `orte` ON `orte`.`OrtID` = `ros`.`OrtID` AND `orte`.`Geloescht` IS NULL
LEFT JOIN `yk395_abhol_strassen` AS `strassen` ON (`strassen`.`StrasseID` = `ros`.`StrasseID` OR (`ros`.`StrasseID` = 0 AND `strassen`.`OrtID` = `orte`.`OrtID`)) AND `orte`.`NaherholGebiet` IS NULL AND `strassen`.`Geloescht` IS NULL
WHERE `routen`.`Geloescht` IS NULL AND `orte`.`OrtID` IS NOT NULL AND `routen`.`RouteID` IN (SELECT RouteID FROM yk395_abhol_routen_plan GROUP BY RouteID) AND `routen`.`Jahr`='2023' AND `strassen`.`OrtID`='114' AND (`orte`.`NaherholGebiet`IS NULL OR `orte`.`NaherholGebiet`!='1')
GROUP BY `strassen`.`StrasseID`, `strassen`.`StrasseNr`
ORDER BY `strassen`.`StrasseNr` ASC
$this->db->replacePrefix((string) $query):
SELECT `routen_plan`.`PlanDatum`, `routen`.`AbfallArt`
FROM `yk395_abhol_routen` AS `routen`
LEFT JOIN `yk395_abhol_route_ort_strasse` AS `ros` ON `ros`.`RouteID` = `routen`.`RouteID`
LEFT JOIN `yk395_abhol_ort` AS `orte` ON `orte`.`OrtID` = `ros`.`OrtID` AND `orte`.`Geloescht` IS NULL
LEFT JOIN `yk395_abhol_strassen` AS `strassen` ON (`strassen`.`StrasseID` = `ros`.`StrasseID` OR (`ros`.`StrasseID` = 0 AND `strassen`.`OrtID` = `orte`.`OrtID`)) AND `orte`.`NaherholGebiet` IS NULL AND `strassen`.`Geloescht` IS NULL
LEFT JOIN `yk395_abhol_routen_plan` AS `routen_plan` ON `routen_plan`.`RouteID` = `routen`.`RouteID`
WHERE `routen`.`Geloescht` IS NULL AND `orte`.`OrtID` IS NOT NULL AND `orte`.`OrtID`='114' AND `routen_plan`.`PlanID` IS NOT NULL AND `routen`.`Jahr`='2023' AND `strassen`.`StrasseID` IS NULL AND (`orte`.`NaherholGebiet`IS NULL OR `orte`.`NaherholGebiet`!='1')
GROUP BY `routen_plan`.`PlanDatum`, `routen`.`AbfallArt`
ORDER BY `routen_plan`.`PlanDatum` ASC
