
Pünktliche und zuverlässige Entsorgung
von Restmüll, Schadstoffen und Sperrmüll.
von Restmüll, Schadstoffen und Sperrmüll.

$this->db->replacePrefix((string) $query):
SELECT `routen`.`Jahr` FROM `lpno0_abhol_routen` AS `routen` LEFT JOIN `lpno0_abhol_route_ort_strasse` AS `ros` ON `ros`.`RouteID` = `routen`.`RouteID` LEFT JOIN `lpno0_abhol_ort` AS `orte` ON `orte`.`OrtID` = `ros`.`OrtID` AND `orte`.`Geloescht` IS NULL LEFT JOIN `lpno0_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 lpno0_abhol_routen_plan GROUP BY RouteID) AND `routen`.`Jahr`>='2026' AND `routen`.`Jahr`<='2027' 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 `lpno0_abhol_routen` AS `routen` LEFT JOIN `lpno0_abhol_route_ort_strasse` AS `ros` ON `ros`.`RouteID` = `routen`.`RouteID` LEFT JOIN `lpno0_abhol_ort` AS `orte` ON `orte`.`OrtID` = `ros`.`OrtID` AND `orte`.`Geloescht` IS NULL LEFT JOIN `lpno0_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 lpno0_abhol_routen_plan GROUP BY RouteID) AND `routen`.`Jahr`='2027' 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 `lpno0_abhol_routen` AS `routen` LEFT JOIN `lpno0_abhol_route_ort_strasse` AS `ros` ON `ros`.`RouteID` = `routen`.`RouteID` LEFT JOIN `lpno0_abhol_ort` AS `orte` ON `orte`.`OrtID` = `ros`.`OrtID` AND `orte`.`Geloescht` IS NULL LEFT JOIN `lpno0_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 lpno0_abhol_routen_plan GROUP BY RouteID) AND `routen`.`Jahr`='2027' AND `strassen`.`OrtID`='102' 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 `lpno0_abhol_routen` AS `routen` LEFT JOIN `lpno0_abhol_route_ort_strasse` AS `ros` ON `ros`.`RouteID` = `routen`.`RouteID` LEFT JOIN `lpno0_abhol_ort` AS `orte` ON `orte`.`OrtID` = `ros`.`OrtID` AND `orte`.`Geloescht` IS NULL LEFT JOIN `lpno0_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 `lpno0_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`='102' AND `routen_plan`.`PlanID` IS NOT NULL AND `routen`.`Jahr`='2027' 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
Abfallkalender 2027
Bereich: alle Straßen
Abholtermine 2027 für Wahlitz
Gelbe Tonne
Di 26.01.
Di 23.02.
Di 23.03.
Di 20.04.
Mi 19.05.
Di 15.06.
Di 13.07.
Di 10.08.
Di 07.09.
Di 05.10.
Di 02.11.
Di 30.11.
Di 28.12.
Papier
Mi 13.01.
Di 02.02.
Di 23.02.
Di 16.03.
Di 06.04.
Di 27.04.
Mi 19.05.
Di 08.06.
Di 29.06.
Di 20.07.
Di 10.08.
Di 31.08.
Di 21.09.
Di 12.10.
Di 02.11.
Di 23.11.
Di 14.12.
Biomüll
Do 07.01.
Di 19.01.
Di 02.02.
Di 16.02.
Di 02.03.
Di 16.03.
Mi 31.03.
Di 13.04.
Di 27.04.
Di 11.05.
Di 25.05.
Di 08.06.
Di 22.06.
Di 06.07.
Di 20.07.
Di 03.08.
Di 17.08.
Di 31.08.
Di 14.09.
Di 28.09.
Di 12.10.
Di 26.10.
Di 09.11.
Di 23.11.
Di 07.12.
Di 21.12.
Restmüll
Mo 04.01.
Sa 16.01.
Fr 29.01.
Fr 12.02.
Fr 26.02.
Fr 12.03.
Sa 27.03.
Fr 09.04.
Fr 23.04.
Sa 08.05.
Sa 22.05.
Fr 04.06.
Fr 18.06.
Fr 02.07.
Fr 16.07.
Fr 30.07.
Fr 13.08.
Fr 27.08.
Fr 10.09.
Fr 24.09.
Fr 08.10.
Fr 22.10.
Fr 05.11.
Fr 19.11.
Fr 03.12.
Fr 17.12.
Fr 31.12.