SELECT id_in_class FROM pagenames WHERE class='category' AND pagename='miller's-c.s.-ale-house'
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 's-c.s.-ale-house'' at line 1