select s.code AS "Seller code"
                            , s.description AS "Seller description"
                            , coalesce(c.code, '') AS "Customer code"
                            , coalesce(replace(c.description, ',', ' '), '') AS "Customer description"  
                    from  crm_seller s left
                            OUTER JOIN crm_customer c  on c.seller_id = s.id
                    where(  s.code ilike '%' || :SEARCH_CRITERION 
                            || '%'  or s.description ilike '%' || :SEARCH_CRITERION || '%'  or c.code ilike '%' 
                            || :SEARCH_CRITERION || '%'  or c.description ilike '%' || :SEARCH_CRITERION || '%'  )  
                    and (  s.code ilike '%' || :SELLER || '%'  or s.description ilike '%' || :SELLER || '%'  )  
                    order by s.code
                            ,c.code