Bug d'enchainement de requêtes

[Hiztaar]

Super, ça marche !

J'ai adapté le code, au final ça donne :

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.id 

            NOT IN     (

                SELECT     id_knowledge_parent 

                FROM     utg_knowledge_links

                WHERE     utg_knowledge_links.id_knowledge_child 

                NOT IN     (

                    SELECT     id_knowledge

                    FROM     utg_country_knowledge 

                    WHERE     id_country = $fief

                        )

                    )

                AND knowledge.active = 1

            ");