SELECT /*+ FIRST_ROWS(21) */ * FROM ( SELECT sl_requests.id , sl_requests.sl_requests_number , TRIM(CONCAT(CONCAT(NVL(jt0.first_name,''),' '), CONCAT(NVL(jt0.last_name,''),' '))) sl_requests_contacts_name, jtl0.sl_requesta760ontacts_ida sl_requesta760ontacts_ida, sl_requests.phone , jt1.name req_proj , sl_requests.name , sl_requests.req_status , TRIM(CONCAT(CONCAT(NVL(jt2.first_name,''),' '), CONCAT(NVL(jt2.last_name,''),' '))) received , sl_requests.efficiency , sl_requests.assigned_user_id , sl_requests.system_id , sfav.id is_favorite FROM sl_requests LEFT JOIN sl_requests_contacts_c jtl0 ON sl_requests.id=jtl0.sl_request188cequests_idb AND jtl0.deleted=0
LEFT JOIN contacts jt0 ON jt0.id=jtl0.sl_requesta760ontacts_ida AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN sl_request_projects jt1 ON sl_requests.sl_request_projects_id_c = jt1.id AND jt1.deleted=0 LEFT JOIN users jt2 ON sl_requests.user_id_c = jt2.id AND jt2.deleted=0 LEFT JOIN sugarfavorites sfav ON sfav.module ='SL_Requests' AND sfav.record_id=sl_requests.id AND sfav.created_by='4aba52b8-2564-e689-f129-4e293369afd6' AND sfav.deleted=0 where ((TRIM(CONCAT(CONCAT(NVL(jt2.first_name,''),' '), CONCAT(NVL(jt2.last_name,''),' '))) like 'Елена Кучер%' ) AND (( TRIM(CONCAT(CONCAT(NVL(jt0.first_name,''),' '), CONCAT(NVL(jt0.last_name,''),' '))) like '€гей Сафронов%') OR ( jt0.first_name like '
€гей Сафронов%') OR ( jt0.last_name like '
€гей Сафронов%'))) AND sl_requests.deleted=0 ORDER BY sl_requests.sl_requests_number ASC) MSI WHERE ROWNUM <= 21
Bookmarks