SELECT receipt.`date` "Дата/время", receipt_item_properties.value "Номер сертификата"
FROM receipt_item
JOIN receipt ON (receipt.`cash_id` = receipt_item.`cash_id` AND receipt.`id` = receipt_item.`receipt_header`)
JOIN receipt_item_properties ON (receipt_item.`cash_id` = receipt_item_properties.`cash_id` AND receipt_item_properties.`receipt_item` = receipt_item.id)
WHERE receipt.`store` = 22
AND receipt_item.item = 154945
AND receipt_item_properties.`code` = 'ACCOUNT'
ORDER BY receipt.date;
and receipt.`result` = 0