Zum Hauptinhalt springen
Pünktliche und zuverlässige Entsorgung
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`='57' 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`='57' 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 Parey-Schleuse

Gelbe Tonne

Sa 02.01.
Do 28.01.
Do 25.02.
Do 25.03.
Do 22.04.
Fr 21.05.
Do 17.06.
Do 15.07.
Do 12.08.
Do 09.09.
Do 07.10.
Do 04.11.
Do 02.12.
Do 30.12.

Papier

Di 12.01.
Mo 01.02.
Mo 22.02.
Mo 15.03.
Mo 05.04.
Mo 26.04.
Di 18.05.
Mo 07.06.
Mo 28.06.
Mo 19.07.
Mo 09.08.
Mo 30.08.
Mo 20.09.
Mo 11.10.
Mo 01.11.
Mo 22.11.
Mo 13.12.

Biomüll

Do 14.01.
Mi 27.01.
Mi 10.02.
Mi 24.02.
Mi 10.03.
Mi 24.03.
Mi 07.04.
Mi 21.04.
Mi 05.05.
Do 20.05.
Mi 02.06.
Mi 16.06.
Mi 30.06.
Mi 14.07.
Mi 28.07.
Mi 11.08.
Mi 25.08.
Mi 08.09.
Mi 22.09.
Mi 06.10.
Mi 20.10.
Mi 03.11.
Mi 17.11.
Mi 01.12.
Mi 15.12.
Mi 29.12.

Restmüll

Di 12.01.
Mo 25.01.
Mo 08.02.
Mo 22.02.
Mo 08.03.
Mo 22.03.
Mo 05.04.
Mo 19.04.
Mo 03.05.
Di 18.05.
Mo 31.05.
Mo 14.06.
Mo 28.06.
Mo 12.07.
Mo 26.07.
Mo 09.08.
Mo 23.08.
Mo 06.09.
Mo 20.09.
Mo 04.10.
Mo 18.10.
Mo 01.11.
Mo 15.11.
Mo 29.11.
Mo 13.12.
Mo 27.12.