Posts from janvier 23, 2019

SELECT p.cardnumber, p.surname, p.firstname, p.phone, p.address, p.city, p.email, c.date_due, (TO_DAYS(curdate())-TO_DAYS( date_due)) AS ‘Jours de retards’, i.itype, b.title,[…]

SELECT c.date_due, p.categorycode, b.title, b.author, i.itemcallnumber, i.barcode, i.location FROM issues c LEFT JOIN items i ON (c.itemnumber=i.itemnumber)[…]

SELECT b.budget_name, format(sum(o.listprice*o.quantity),2) AS ‘amount spent’ FROM aqorders o LEFT JOIN aqbudgets b USING (budget_id) WHERE o.datereceived[…]

SELECT YEAR (issuedate) AS ANNEE, categorycode AS CATEGORIE, COUNT(DISTINCT borrowernumber) AS NB_LECTEURS FROM ( SELECT issuedate, borrowernumber[…]