Bug d'enchainement de requêtes

[Hiztaar]

Bon, je cale sur le cas où il y a plusieurs dépendances pour un même knowledge.

Pour le reste, la version remaniée fonctionnelle dans le cas d'un seul héritage :

Code PHP :

<?php 

$available_knowledges = $this->db->query("

            SELECT      knowledge.id, knowledge.name, knowledge.family, knowledge.description, knowledge.img_url,

                        knowledge.time_to_discover, knowledge.price

            FROM         utg_knowledge knowledge

            WHERE         knowledge.active = 1 

            AND         knowledge.id 

            IN     (

                SELECT        utg_knowledge_links.id_knowledge_child 

                FROM         utg_knowledge_links

                WHERE         utg_knowledge_links.id_knowledge_parent    

                   IN     (

                    SELECT ALL         utg_country_knowledge.id_knowledge

                    FROM         utg_country_knowledge 

                    WHERE         utg_country_knowledge.id_country = $fief

                        )    

                    )

            AND            knowledge.id

            NOT IN    (

                    SELECT         utg_country_knowledge.id_knowledge

                    FROM         utg_country_knowledge 

                    WHERE         utg_country_knowledge.id_country = $fief

                    )

            ");