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 'WHERE  (recdate between '201001000000' and '201002000000')) as txx, (select r...' at line 1