SELECT i.id, i.total, i.duedate, i.currency_id,
            i.client_id, i.payment_module, d.group_id, m.filename
            FROM hb_invoices i
            JOIN hb_client_access d ON d.id=i.client_id
            JOIN hb_modules_configuration m ON m.id=i.payment_module
            WHERE i.status IN ('Unpaid','Receiptunpaid') AND client_id IN (
                SELECT fv.client_id FROM hb_client_fields_values fv JOIN hb_client_fields f ON (fv.field_id=f.id)
                WHERE fv.value!=''
                AND f.code='mollieid' )
                AND m.filename LIKE '%mollie%'
            ORDER BY client_id DESC