Unknown column name 'table.column' in 'field list'

You use the alias A for your table items.

use A.id in your select instead of items.Id and you should be fine