fixed SQL query for listing flares