Yes, the and item_receipts.bonded='b'

should be changed to where item_receipts.bonded='b' ,

Thank you all so much for replying this question, it offer me many valuable info.