Inspecting MySQL SELECT Queries in Admin Lists
SQL Query Debugging Guide

Inspecting MySQL SELECT Queries in Admin Lists
SQL Query Debugging Guide

The READ List SELECT query is sent by your table main class, in admin/class/crud/YourTable.php.

Revealing the `SELECT` query

The SQL query sent to your server to get the matching records depends on several parameters:

User's rights on the active table
Active filters
Relations (including user's rights on the related table(s)
Sorting
Pagination

PHPCG analyses these parameters and builds the query for you.

To display the SQL query on your page (for debugging purpose):

Open your table main class (admin/class/crud/YourTable.php)
Uncomment the following line:
// echo $qry_start . $qry_restriction . $active_filters_join_queries . $filters_where_qry . $qry_sorting;