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 ') where web__menu.url='product_search.html'' at line 3

SELECT web__page.* from web__page
LEFT JOIN web__menu on(web__page.ID_web__menu=web__menu.ID AND
web__page.ID_web__langue=) where web__menu.url='product_search.html'