beoDbMysql->query method of beoDbMysql class: Subquery returns more than 1 row
$sql= SELECT (SELECT link FROM textpage_categories as c WHERE c.full_url = u.full_url AND lang='en') as `clink`, (SELECT name FROM textpage_categories as c WHERE c.full_url = u.full_url AND lang='en') as `ctitle`, (SELECT active FROM textpage_categories as c WHERE c.full_url = u.full_url AND lang='en') as `cactive`, (SELECT link FROM textpages as p WHERE p.full_url = u.full_url AND lang='en') as `link`, (SELECT title FROM textpages as p WHERE p.full_url = u.full_url AND lang='en') as `title`, (SELECT active FROM textpages as p WHERE p.full_url = u.full_url AND lang='en') as `active`, (SELECT link FROM galleries as g WHERE g.full_url = u.full_url AND lang='en') as `glink`, (SELECT title FROM galleries as g WHERE g.full_url = u.full_url AND lang='en') as `gtitle`, (SELECT active FROM galleries as g WHERE g.full_url = u.full_url AND lang='en') as `gactive`, (SELECT link FROM forums as f WHERE f.full_url = u.full_url) as `flink`, (SELECT title FROM forums as f WHERE f.full_url = u.full_url) as `ftitle`, (SELECT if(LENGTH(flink)>0,2,0) FROM DUAL) as `factive`, u.parent_url, u.tbl, u.url, u.full_url, u.order FROM `textpage_fullurl` as u WHERE u.`url` IN (SELECT `url` FROM `textpage_fullurl` WHERE `textpage_fullurl`.`parent_url`='planes_projects') HAVING (`active`='2' OR `cactive`='2' OR `gactive`='2' OR `factive`='2') ORDER BY `order` ASC