Expression #13 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jean.pl.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by<br /><br /><br />
        SELECT<br />
          p.*, pl.name, pl.path<br />
        FROM<br />
          sys_pages AS p LEFT JOIN sys_pages_languages AS pl ON (p.id=pl.id_page)<br />
          WHERE<br />
          pl.id_language=1 AND p.active='Y' AND pl.name != ""  group by p.id<br />
        <br />
          ORDER BY p.list<br />
        <br />
          <br />
          <br />
        ;<br />