ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'g.status' in 'field list' <br> <br> <br>SELECT SQL_CALC_FOUND_ROWS t.*, v.*,<br />
					sum(r.pocetPotvrdenych) as pocetPotvrdenych,<br />
					sum(r.pocetNahradnikov) as pocetNahradnikov,<br />
					sum(r.pocetHracovSpolu) as pocetHracovSpolu,<br />
					sum(r.pocetOdhlasenych) as pocetOdhlasenych,<br />
					sum(r.pocetNepotvrdenych) as pocetNepotvrdenych,<br />
					sum(r.pocetNepotvrdenychG) as pocetNepotvrdenychG,<br />
					sum(r.pocetPotvrdenychG) as pocetPotvrdenychG,<br />
					sum(r.pocetNahradnikovG) as pocetNahradnikovG,<br />
					count(r.idrunda) as pocetRund <br />
					FROM turnaje t  <br />
		            <br />
					     LEFT JOIN <br />
						   ( SELECT <br />
									rundy.nazov,<br />
									rundy.idrunda,<br />
									rundy.idturnaj,<br />
									count(if(s.potvrdeny='1',1,NULL)) as pocetPotvrdenych,<br />
									count(if(s.nahradnik='1',1,NULL)) as pocetNahradnikov,<br />
									count(if(s.potvrdeny='0',1,NULL)) as pocetNepotvrdenych,<br />
									count(if(s.potvrdeny='3',1,NULL)) as pocetOdhlasenych,<br />
									count(if(g.status='0',1,NULL)) as pocetNepotvrdenychG,<br />
									count(if(g.status='1',1,NULL)) as pocetPotvrdenychG,<br />
									count(if(g.waitinglist='1',1,NULL)) as pocetNahradnikovG,<br />
									count(s.id) as pocetHracovSpolu<br />
									FROM rundy rundy <br />
									LEFT JOIN spojenia s <br />
									ON s.idrunda = rundy.idrunda<br />
									LEFT JOIN groups g <br />
									ON g.idrunda = rundy.idrunda<br />
									<br />
								GROUP BY rundy.idrunda<br />
							) <br />
							as r <br />
							ON r.idturnaj = t.id <br />
						LEFT JOIN <br />
						   ( SELECT <br />
						   			vote.voteid,<br />
									count(if(vote.vote='1',1,NULL)) as good,<br />
									count(if(vote.vote='2',1,NULL)) as bad<br />
								FROM votes vote <br />
								GROUP BY vote.voteid<br />
							) <br />
							as v <br />
							ON v.voteid = t.id WHERE  t.ukoncenie < NOW()  GROUP BY t.id ORDER BY t.ukoncenie DESC  LIMIT 5 OFFSET 1<hr>exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'g.status' in 'field list'' in /domains1/gh268600/public/library/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /domains1/gh268600/public/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /domains1/gh268600/public/library/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#2 /domains1/gh268600/public/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#3 /domains1/gh268600/public/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT SQL_CALC...', Array)
#4 /domains1/gh268600/public/library/Zend/Db/Adapter/Abstract.php(706): Zend_Db_Adapter_Pdo_Abstract->query('SELECT SQL_CALC...', Array)
#5 /domains1/gh268600/public/application/modules/frontoffice/models/Turnaje.php(120): Zend_Db_Adapter_Abstract->fetchAll('SELECT SQL_CALC...')
#6 /domains1/gh268600/public/application/modules/frontoffice/controllers/IndexController.php(672): Frontoffice_Model_Turnaje->fetchTurnaje(' t.ukoncenie < ...', 't.ukoncenie DES...', '1', '5')
#7 /domains1/gh268600/public/library/Zend/Controller/Action.php(513): IndexController->blogAction()
#8 /domains1/gh268600/public/library/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('blogAction')
#9 /domains1/gh268600/public/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#10 /domains1/gh268600/public/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#11 /domains1/gh268600/public/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#12 /domains1/gh268600/public/www_root/index.php(72): Zend_Application->run()
#13 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'g.status' in 'field list'' in /domains1/gh268600/public/library/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /domains1/gh268600/public/library/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /domains1/gh268600/public/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /domains1/gh268600/public/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT SQL_CALC...', Array)
#3 /domains1/gh268600/public/library/Zend/Db/Adapter/Abstract.php(706): Zend_Db_Adapter_Pdo_Abstract->query('SELECT SQL_CALC...', Array)
#4 /domains1/gh268600/public/application/modules/frontoffice/models/Turnaje.php(120): Zend_Db_Adapter_Abstract->fetchAll('SELECT SQL_CALC...')
#5 /domains1/gh268600/public/application/modules/frontoffice/controllers/IndexController.php(672): Frontoffice_Model_Turnaje->fetchTurnaje(' t.ukoncenie < ...', 't.ukoncenie DES...', '1', '5')
#6 /domains1/gh268600/public/library/Zend/Controller/Action.php(513): IndexController->blogAction()
#7 /domains1/gh268600/public/library/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('blogAction')
#8 /domains1/gh268600/public/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#9 /domains1/gh268600/public/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /domains1/gh268600/public/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /domains1/gh268600/public/www_root/index.php(72): Zend_Application->run()
#12 {main}