What SQL query is used in the LIBRARY report example to fetch book and category data?

The SQL query used is: SELECT C.Category AS Category, Book, Writer FROM Books B WITH (NOLOCK) LEFT JOIN Categories C WITH (NOLOCK) ON C.UserTableID=B.CategoryID WHERE B.CategoryID='$PCategories$'