SELECT cost_group_charge.*, cost_group.cost_group_desc, school.school_name  
FROM cost_group_charge  
LEFT JOIN cost_group ON (cost_group.cost_group_id=cost_group_charge.cost_group_id)  
LEFT JOIN school ON (school.school_id=cost_group_charge.rdcaccount_id)  
WHERE cost_group_charge.rdcaccount_id='7'    
ORDER BY cost_group_charge.age_group_id, cost_group_seq_nbr, cost_group_charge.banner_req  =>Count=86

SELECT cost_group_charge.*, cost_group.cost_group_desc, school.school_name  
FROM cost_group_charge  
LEFT JOIN cost_group ON (cost_group.cost_group_id=cost_group_charge.cost_group_id)  
LEFT JOIN school ON (school.school_id=cost_group_charge.rdcaccount_id)  
WHERE ( cost_group_charge.cost_group_id='SDA2' ) OR ( cost_group_charge.cost_group_id='SDA3' ) AND cost_group_charge.rdcaccount_id IN ('1', '7')    
ORDER BY cost_group_charge.age_group_id, cost_group_seq_nbr, cost_group_charge.banner_req  =>Count=6

(( cost_group_id='SDA2' ) OR (cost_group_id='SDA3' )) AND rdcaccount_id IN ('1', '7')

$where2 = $this->_cm_initialise($where, $selection, $search);
if ($where2 != $where) {
    // this was changed in _cm_initialise(), so use the new version
    $where = $where2;
} else {
    if (!empty($selection)) {
        // $selection takes precedence over $where
        $where     = $selection;
        $selection = null;
    } // if
} // if

    function _cm_initialise ($where, &$selection, $search)
    // perform any initialisation for the current task.
    // NOTE: $selection is passed by reference as it may be amended.
    // NOTE: $search    is only available for OUTPUT tasks.
    {
        // customisable code goes here

        return $where;

    } // _cm_initialise 

    function _cm_initialise ($where, &$selection, $search)
    // perform any initialisation for the current task.
    // NOTE: $selection is passed by reference as it may be amended.
    // NOTE: $search    is only available for OUTPUT tasks.
    {
        $selection = null;

        return $where;

    } // _cm_initialise