CB

When filtering by a column that requires a JOIN and is present in the query it always uses the "a." table as instead of doing proper lookup. To test add the below filter to CB > User Management then filter by Enabled/Disabled.

<filter name="block" value="block" valuetype="sql:int" type="xml:user_block" label="" blanktext="- Select Enabled -" />

This functionality is traced as follows.

TableBrowser > _prepareXmlSqlQuery > process_filter