dr_john_mp wrote:

>
> The problem is with (M.PROGRESS > 0). PROGRESS is an integer field
> and there is a single valid record with a value of 1.
>
> Changing the condition to (M.PROGRESS >= 1) correctly returns the
> record.

IIRC, it's a known bug in 2.0.0. Worth upgrading to 2.0.1.


Dmitry