Årsbesøk | Besøk hittil |
År |
Barn/Unge |
% andel |
Voksne |
Eldre |
Totalt |
diff-% |
Barn/Unge |
Voksne |
Eldre |
Totalt |
object(PDOStatement)#5 (1) {
["queryString"]=>
string(1199) "SELECT
(select count(ida) from hks_avtaler d2 where `dato` BETWEEN '1980-01-01' AND '1980-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)='1980' and avdeling=) as reg2,
(select count(ida) from hks_avtaler d2 where `dato` BETWEEN '1980-01-01' AND '1980-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`) = '1980'
AND avlyst = 0
AND ikke_mott = 0
AND d2.avdeling=
GROUP BY year(dato)
"
}