What is wrong with this query?
I get the error: Scanning error before 'Apponte\Models\E...' when parsing: SELECT a.id, a.label, a.link, Deriv1.Count FROM Apponte\Models\Entities\Menu
a LEFT OUTER JOIN (SELECT parent, COUNT(*) AS Count FROM Apponte\Models\Entities\Menu
GROUP BY parent) Deriv1 ON a.id = Deriv1.parent where id=5 (226)
$query = new Query("SELECT a.id, a.label, a.link, Deriv1.Count FROM `Apponte\Models\Entities\Menu` a LEFT OUTER JOIN (SELECT parent, COUNT(*) AS Count FROM `Apponte\Models\Entities\Menu` GROUP BY parent) Deriv1 ON a.id = Deriv1.parent where id=5", $this->getDI());
// Execute the query returning a result if any
$menu = $query->execute();