SELECT        SUM(receipts_data.amount * items.price) AS VALUE, clients.name, receipts.DATE
FROM            receipts_data INNER JOIN
                         receipts ON receipts_data.receipt_id = receipts.receipt_id INNER JOIN
                         clients ON receipts.client_id = clients.id INNER JOIN
                         items ON receipts_data.code = items.id
WHERE        (receipts_data.receipt_id = '1/TES/11/2020')
GROUP BY clients.name