LINUX.ORG.RU

История изменений

Исправление shatsky, (текущая версия) :

filter.filter: 

"djmuslib_person" INNER JOIN "djmuslib_ext_person_category_people" ON (
    "djmuslib_person"."id" = "djmuslib_ext_person_category_people"."person_id"
)
INNER JOIN "djmuslib_ext_person_category" ON (
    "djmuslib_ext_person_category_people"."ext_person_category_id" = "djmuslib_ext_person_category"."id"
)
INNER JOIN "djmuslib_ext_person_category_people" T4 ON (
    "djmuslib_person"."id" = T4."person_id"
)
INNER JOIN "djmuslib_ext_person_category" T5 ON (
    T4."ext_person_category_id" = T5."id"
)
WHERE (
    "djmuslib_ext_person_category"."category" IN (
        performers
    )
    AND T5."category" IN (
        composers
    )
)
Q&Q: 
"djmuslib_person" INNER JOIN "djmuslib_ext_person_category_people" ON (
    "djmuslib_person"."id" = "djmuslib_ext_person_category_people"."person_id"
)
INNER JOIN "djmuslib_ext_person_category" ON (
    "djmuslib_ext_person_category_people"."ext_person_category_id" = "djmuslib_ext_person_category"."id"
)
WHERE (
    "djmuslib_ext_person_category"."category" IN (
        performers
    )
    AND "djmuslib_ext_person_category"."category" IN (
        composers
    )
)

Исходная версия shatsky, :

Работает: 

"djmuslib_person" INNER JOIN "djmuslib_ext_person_category_people" ON (
    "djmuslib_person"."id" = "djmuslib_ext_person_category_people"."person_id"
)
INNER JOIN "djmuslib_ext_person_category" ON (
    "djmuslib_ext_person_category_people"."ext_person_category_id" = "djmuslib_ext_person_category"."id"
)
INNER JOIN "djmuslib_ext_person_category_people" T4 ON (
    "djmuslib_person"."id" = T4."person_id"
)
INNER JOIN "djmuslib_ext_person_category" T5 ON (
    T4."ext_person_category_id" = T5."id"
)
WHERE (
    "djmuslib_ext_person_category"."category" IN (
        performers
    )
    AND T5."category" IN (
        composers
    )
)
Не работает: 
"djmuslib_person" INNER JOIN "djmuslib_ext_person_category_people" ON (
    "djmuslib_person"."id" = "djmuslib_ext_person_category_people"."person_id"
)
INNER JOIN "djmuslib_ext_person_category" ON (
    "djmuslib_ext_person_category_people"."ext_person_category_id" = "djmuslib_ext_person_category"."id"
)
WHERE (
    "djmuslib_ext_person_category"."category" IN (
        performers
    )
    AND "djmuslib_ext_person_category"."category" IN (
        composers
    )
)