test 7 code index.php select p.id, p.domain, p.page, p.form, p.mobpage, p.valid, m.keymenu as menu, ifnull(sm.keymenu,'#') as submenu, IFNULL(p.getid, 0) as getid, pt.title, IFNULL(pt.head,pt.title) as head from pages as p inner join menusite as m on p.idmenu = m.id left join menusite as sm on ifnull(m.idmenu, 0) = sm.id left join pagetitle as pt on p.id = pt.id and pt.lang = 'fr' where p.domain = 'staubin' and p.page = 'agenda'object(cls_page)#2 (14) { ["id"]=> int(0) ["domain"]=> string(0) "" ["page"]=> string(0) "" ["like"]=> bool(false) ["form"]=> string(6) "agenda" ["menu"]=> string(0) "" ["submenu"]=> string(0) "" ["idget"]=> int(0) ["title"]=> string(0) "" ["titlefr"]=> string(0) "" ["head"]=> string(0) "" ["headfr"]=> string(0) "" ["valid"]=> bool(false) ["info"]=> object(cls_pageinfo)#9 (18) { ["id"]=> int(0) ["defsite"]=> NULL ["site"]=> string(0) "" ["page"]=> string(0) "" ["title"]=> string(0) "" ["idinfo"]=> int(0) ["info"]=> string(0) "" ["dtinfo"]=> object(DateTime)#10 (3) { ["date"]=> string(26) "1901-01-01 00:00:00.000000" ["timezone_type"]=> int(3) ["timezone"]=> string(12) "Europe/Paris" } ["href"]=> string(0) "" ["img"]=> bool(false) ["name"]=> string(0) "" ["ext"]=> string(3) "jpg" ["width"]=> int(0) ["height"]=> int(0) ["version"]=> int(0) ["alt"]=> string(0) "" ["althref"]=> string(0) "" ["msgAno"]=> string(0) "" } }