- Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and ) group by menu ) as s2 on s.menu = s2.menu and s.dat' at line 8 SQL=select s.*, m.name as organo_name from jos_schedeosservatorio s inner join jos_menu m on s.menu = m.id inner join ( select menu, max(date) as date from jos_schedeosservatorio where menu in (select menu from jos_osservatoriomenulr where lft between and ) group by menu ) as s2 on s.menu = s2.menu and s.date = s2.date