[Koha] SQL report for URL

Hi Please, can anyone help me to create a SQL report for getting the URL of all the items based on the collections in Koha. -- With Regards Prajeesh Bhaskaran Reference Assistant (Library) Mahatma Gandhi University, Kerala, India.