Add exposed filters to administrative payment overview

    SELECT payment_status_item_payment.created AS payment_status_item_payment_created, payment_status_item_payment.STATUS AS payment_status_item_payment_status, payment.currency_code AS payment_currency_code, payment_method_payment.title_specific AS payment_method_payment_title_specific, payment.pid AS pid, SUM((amount * quantity * (tax_rate + 1))) AS amount_total
    FROM
    {payment} payment
    LEFT JOIN {payment_method} payment_method_payment ON payment.pmid = payment_method_payment.pmid
    LEFT JOIN {payment_line_item} payment_line_item_payment ON payment.pid = payment_line_item_payment.pid
    INNER JOIN {payment_status_item} payment_status_item_payment ON payment.psiid_last = payment_status_item_payment.psiid

where this fails

    WHERE (( (payment_line_item_payment.amount BETWEEN '10' AND '100') ))
    GROUP BY payment_status_item_payment_created, payment_status_item_payment_status, payment_currency_code, payment_method_payment_title_specific, pid
    ORDER BY payment_status_item_payment_created DESC
    LIMIT 50 OFFSET 0

Nice work :)