title: Database query failed: Column 'id' in field list is ambiguous
body: <pre><code>       SELECT  realestate.id,node.id,node.name
                  from realestate,
                  (SELECT
                      GROUP_CONCAT(parent.name_en ORDER BY parent.lft DESC) AS name,id
                    FROM
                      address AS node JOIN address AS parent
                      ON node.lft BETWEEN parent.lft AND parent.rgt  
                    WHERE node.lft &gt;={$lft} and node.rgt &lt;={$rgt}
                    GROUP BY node.name) as node
          INNER JOIN users ON id_user = users.id
          LEFT JOIN pic ON id_realestate = realestate.id
          WHERE node.id = realestate.address_id
  </code></pre>
  
  <p>I tried to modify it several times and this error message would not disappear "Database query failed: Column 'id' in field list is ambiguous". is there any idea on how to solve this?</p>