Årsbesøk | Besøk hittil |
År |
Barn/Unge |
% andel |
Voksne |
Eldre |
Totalt |
diff-% |
Barn/Unge |
Voksne |
Eldre |
Totalt |
Warning: Undefined array key "avd" in /customers/0/d/a/hemmingstad.no/httpd.www/cg/stat_bess.php on line 185
Warning: Undefined array key "avd" in /customers/0/d/a/hemmingstad.no/httpd.www/cg/stat_bess.php on line 186
Warning: Undefined array key "avd" in /customers/0/d/a/hemmingstad.no/httpd.www/cg/stat_bess.php on line 187
Warning: Undefined variable $filt in /customers/0/d/a/hemmingstad.no/httpd.www/cg/stat_bess.php on line 197
Warning: Undefined variable $kunde_filt in /customers/0/d/a/hemmingstad.no/httpd.www/cg/stat_bess.php on line 198
object(PDOStatement)#6 (1) {
["queryString"]=>
string(1195) "SELECT
(select count(ida) from hks_avtaler d2 where `dato` BETWEEN '2000-01-01' AND '2000-12-31' and avdeling= and barn=0 and unge=0 and voksne=0 and eldre=0 and fraarr=0 and avlyst=0 and ikke_mott=0 group by year(dato)) as ureg,
(select count(ida) from hks_avtaler d2 where year(dato)=2000 and avdeling=) as reg2,
(select count(ida) from hks_avtaler d2 where `dato` BETWEEN '2000-01-01' AND '2000-12-31' and avdeling= and ikke_mott=0 and (barn+unge+voksne+eldre+fraarr) > 0 and avlyst=0 group by year(dato)) as reg,
sum(barn+unge+voksne+eldre+fraarr) as tot,
sum(barn + unge) as 'bu',
sum(voksne + fraarr) as 'vo',
sum(eldre) as 'el'
FROM `hks_avtaler` d2
WHERE
year(`dato`) = 2000
AND avlyst = 0
AND ikke_mott = 0
AND d2.avdeling=
GROUP BY year(dato)
"
}
Fatal error: Uncaught Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and barn=0 and unge=0 and voksne=0 and eldre=0 and fraarr=0 and avlyst=0 and ...' at line 2SELECT
(select count(ida) from hks_avtaler d2 where `dato` BETWEEN '2000-01-01' AND '2000-12-31' and avdeling= and barn=0 and unge=0 and voksne=0 and eldre=0 and fraarr=0 and avlyst=0 and ikke_mott=0 group by year(dato)) as ureg,
(select count(ida) from hks_avtaler d2 where year(dato)=2000 and avdeling=) as reg2,
(select count(ida) from hks_avtaler d2 where `dato` BETWEEN '2000-01-01' AND '2000-12-31' and avdeling= and ikke_mott=0 and (barn+unge+voksne+eldre+fraarr) > 0 and avlyst=0 group by year(dato)) as reg,
sum(barn+unge+voksne+eldre+fraarr) as tot,
sum(barn + unge) as 'bu',
sum(voksne + fraarr) as 'vo',
sum(eldre) as 'el'
FROM `hks_avtaler` d2
WHERE
year(`dato`) = 2000
AND avlyst = 0
AND ikke_mott = 0
AND d2.avdeling=
GROUP BY year(dato)
in /customers/0/d/a/hemmingstad.no/httpd.www/cg/class/database.php:37
Stack trace:
#0 /customers/0/d/a/hemmingstad.no/httpd.www/cg/stat_bess.php(203): Database->getRow('SELECT \n ...')
#1 {main}
thrown in /customers/0/d/a/hemmingstad.no/httpd.www/cg/class/database.php on line 37