$collection = Mage::getModel("customer/customer")->getCollection()
->addAttributeToSelect('firstname')
->addAttributeToFilter('grisk_college_new_id', array('in' =>$collegeid))
->addFieldToFilter('group_id', array('in' => array(4, 5)))
->addAttributeToFilter('physical_verify', array('null' => true), 'left')
->addFieldToFilter('assigned_campus_manager',array('like' => '%_/' . $custid . "%"));
SELECT
e
.*,at_grisk_college_new_id
.value
ASgrisk_college_new_id
,at_physical_verify
.value
ASphysical_verify
,at_assigned_campus_manager
.value
ASassigned_campus_manager
FROMcustomer_entity
ASe
INNER JOINcustomer_entity_int
ASat_grisk_college_new_id
ON (at_grisk_college_new_id
.entity_id
=e
.entity_id
) AND (at_grisk_college_new_id
.attribute_id
= '275') LEFT JOINcustomer_entity_int
ASat_physical_verify
ON (at_physical_verify
.entity_id
=e
.entity_id
) AND (at_physical_verify
.attribute_id
= '209') INNER JOINcustomer_entity_varchar
ASat_assigned_campus_manager
ON (at_assigned_campus_manager
.entity_id
=e
.entity_id
) AND (at_assigned_campus_manager
.attribute_id
= '183') WHERE (e
.entity_type_id
= '1') AND (at_grisk_college_new_id.value IN('')) AND (e
.group_id
IN(4, 5)) AND (at_physical_verify.value IS NULL) AND (at_assigned_campus_manager.value LIKE '%_/%')
How can I make it more efficient ?