DBI::MySQL error: Invalid SQL: SELECT a.*,
g.title AS groupTitle,
g.id AS groupId,
h.title AS parentTitle,
IF (a.`typeId` = 1, a.companyName, CONCAT(a.firstName, ' ', a.lastName)) AS `userTitle`,
h.id AS parentId,
(SELECT COUNT(e.id) FROM `ela_projects` AS e WHERE e.`userId` = a.id) AS `projectsCount`,
(SELECT COUNT(i.id) FROM `ela_bids` AS i WHERE i.`userId` = a.id) AS `bidsCount`,
(SELECT COUNT(j.id) FROM `ela_projects` AS j,`ela_bids` AS k WHERE k.id = j.winnerId AND k.userId = a.id) AS `bidsCompleted`
FROM `ela_users` AS a
LEFT JOIN `ela_bids` AS b ON a.id = b.userId
LEFT JOIN `ela_usersHasGroups` AS f ON a.id = f.userId
LEFT JOIN `ela_projectGroups` AS g ON g.id = '53'
LEFT JOIN `ela_projectGroups` AS h ON h.id = g.parentId
WHERE `a`.`deleted` = '0' AND `a`.`published` = '1' AND `a`.`active` = '1' AND `a`.`email` = '' AND `a`.`password` = ''
GROUP BY a.id


Got error 122 from storage engine
File: /var/www/virtual/contract.lt/htdocs/models/users.php
Line: 71
Session halted