[Koha] Subject Wise Report

I am try to write a query in which all fields from items, biblio, bilioitems tables are required to be shown. But I am facing difficulties to show subject heading and classification number. I also tried extractvalue() function to show subject heading but error displayed. Has anyone the solution of this issue? Thanks.