AfeefaDe / afeefa-backend-ui

content management system for the afeefa frontend
7 stars 2 forks source link

Kausa Leipzig hat parent Orga von Dresden #420

Closed kakenbok closed 6 years ago

kakenbok commented 6 years ago

scheint nicht mehr so zu sein:

select o1.title, o1.area, o2.title, o2.area from orgas o1
inner join orgas o2
on o1.parent_orga_id = o2.id
where o2.id <> 1
and o1.area <> o2.area
kakenbok commented 6 years ago

Jedoch gilt dies für 2 Events:

select o1.title, o1.area, o2.title, o2.area from events o1
inner join orgas o2
on o1.orga_id = o2.id
where o2.id <> 1
and o1.area <> o2.area
{
    "table": "UnknownTable",
    "rows":
    [
        {
            "id": 1449,
            "title": "Integrationsforum Leipzig 2017",
            "area": "leipzig",
            "id": 1571,
            "title": "Deutsche Gesellschaft e. V.",
            "area": "dresden"
        },
        {
            "id": 1621,
            "title": "Meine Werte – Deine Werte: Was hält unsere Gesellschaft zusammen?",
            "area": "leipzig",
            "id": 1571,
            "title": "Deutsche Gesellschaft e. V.",
            "area": "dresden"
        }
    ]
}
kakenbok commented 6 years ago

habe beide (alte events 2017) über redaktionsbereich gefixt.