SELECT
`id`,
`storage_code`,
`article_no`,
`name`,
`cas_no`,
`molecular_formula`,
`batch_no`,
`purity`,
`receive_date`,
`expiry_date`,
`storage_condition`,
`last_report_no`,
`class_text`

FROM `bv_storage_view`
where `quantity`>0
limit 1000