[Koha] Click Tracker

[Ma. Victoria H. Silva-Manuel]

I am using this SQL to generate Click Tracker report:

SELECT count(*) AS 'No. of Times Clicked', biblio.title AS 'Title', URL
> FROM linktracker
>
JOIN biblio USING(biblionumber)

WHERE date(timeclicked) BETWEEN <<Date BETWEEN (yyyy-mm-dd)|date>> AND
> <<and (yyyy-mm-dd)|date>>

GROUP BY url


I want to add a drop down list for item type. I tried
adding items.itype=<<itype|itemtypes>> in WHERE part, but I'm getting the
following error when I run the report:

The following error was encountered:
> The database returned the following error:
> Unknown column 'items.itype' in 'where clause'
> Please check the log for further details.


What should I do?


-- 
Ma. Victoria H. Silva-Manuel
Registered Librarian, 3892