Creating dual filter in Classifier can cause bad SQL query

[dlogan]

Reported on the Forum.

Within Classifier, click the filter drop down ("cells from ...") > * create new filter* Then name the filter and select any two WHERE clauses, e.g. ImageNumber = 1 AND Image_Count_Cells > 3.

The resulting MySQL query duplicates the table in the FROM clause (e.g. "FROM Per_Image, Per_Image")

The workaround is to create the Filter in the properties file, or by specifying filters in ExportToDatabase.