Warning: Undefined variable $host in /customers/0/d/a/hemmingstad.no/httpd.www/cg/class/PDO_lister_class2.php on line 87 Warning: Undefined array key "avd" in /customers/0/d/a/hemmingstad.no/httpd.www/cg/program14d.php on line 17 Warning: Undefined variable $fttype in /customers/0/d/a/hemmingstad.no/httpd.www/cg/program14d.php on line 17 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 YEAR(d2.dato) = YEAR(NOW()) AND ikke_mott=0 AND d2.avlyst=0 GROUP BY ku...' at line 1

---

----SELECT id, if(forening='',0,1) as t, if(forening='',concat('+',etternavn,', ',fornavn),forening) as label FROM hks_kunder2 d1, hks_avtaler d2 WHERE id = d2.kunde AND d2.avdeling= AND YEAR(d2.dato) = YEAR(NOW()) AND ikke_mott=0 AND d2.avlyst=0 GROUP BY kunde ORDER BY label in /customers/0/d/a/hemmingstad.no/httpd.www/cg/class/PDO_lister_class2.php:230 Stack trace: #0 /customers/0/d/a/hemmingstad.no/httpd.www/cg/program14d.php(30): lister->select(NULL) #1 {main} thrown in /customers/0/d/a/hemmingstad.no/httpd.www/cg/class/PDO_lister_class2.php on line 230