how the queries can generated for subpanels

[jitchavan]

how the queries can generated for subpanels means In which files the selected fields are used and the conditions in where clause are set.

[SugarDev.net]

It's a ListView query, from ListView.php

[jitchavan]

I know upto following things.I am using sugarcrm 4.5

1. leads/layout_defs.php - which contains the subpanel info.we can show/hide subpanels from there
2. there are forHistory.phps with the related modules.

But in the query emails_leads.deleted field comes up in where condition. As emails_leads is not a module .There is a relationship file metadata/emails_leadsMetadata.php with the relation between emails and leads table.

But i didn't get where in the query emails_leads.deleted=0 is configured .which is the file for that?