The READ List SELECT query is sent by your table main class, in admin/class/crud/YourTable.php.
SELECT queryThe SQL query sent to your server to get the matching records depends on several parameters:
PHPCG analyses these parameters and builds the query for you.
To display the SQL query on your page (for debugging purpose):
conf/conf.php file and set the DEBUG_DB_QUERIES constant to true.Configuration → Settings → check Simulate and debug.DEBUG_DB_QUERIES back to false when you're done.