Покажи мне разницу в двух SQL запросах  1) -  with lard$ as

     (select NVL(lard.access_type_id, 0) as access_type_id,
             lard.int_param1,
             lal.loy_id as loyId,
             (SELECT l.loy_name
              FROM loyalty l
              WHERE lal.loy_id = l.loy_id
                AND lal.action_date >= l.stime
                AND lal.action_date < l.etime) as loyName,
          DECODE(lal.action_type,
                 1,
                 :sendMessage,
                 2,
                 :applyBonus,
                 3,
                 :actionWithService) as actionType,
          CASE WHEN lal.action_type = 1
              THEN  (SELECT lm.msg_name     FROM notify_template lm    WHERE lm.msg_id = lal.action_param)
              WHEN lal.action_type = 2
              THEN  (SELECT pb.pbonus_name     FROM payment_bonus pb    WHERE pb.pbonus_id = lal.action_param)
              WHEN lal.action_type = 3 THEN  (SELECT ls.loy_serv_name     FROM loyalty_service ls    WHERE ls.loy_serv_id = lal.action_param)
              ELSE  :notDefined  END  as action,
          lal.action_date as date,
          lal.try_count as tryCount,
          lal.executed_date as executedDate
      from  loyalty_action_list lal
      left join loyalty_level ll  on ll.loy_level_id = lal.loy_level_id
          and ll.smst_id = 1
          and ll.stime <= :target_date
          and ll.etime > :target_date
      left join loyalty_access_rules_detail lard  on lard.lar_id = ll.lar_id
          and lard.smst_id = 1
          and lard.stime <= :target_date
          and lard.etime > :target_date
    where lal.clnt_id = :clnt_id
        and :target_date <= lal.action_date)


 select lal.* from lard$ lal where  (lal.access_type_id <> 15)  or (lal.access_type_id = 15 and  lal.int_param1 in  (select sh.trpl_id  from subs_history sh  where sh.clnt_id = :clnt_id AND sh.stime <= lal.action_date and sh.etime > lal.action_date))
                             order by loyaltyId offset 0 rows  fetch next 50 rows only;                 2) - with lard$ as
 (select NVL(lard.access_type_id, 0) as access_type_id,
         lard.int_param1,
         lal.loy_id,
         (SELECT l.loy_name
            FROM loyalty l
           WHERE lal.loy_id = l.loy_id
             AND lal.action_date >= l.stime
             AND lal.action_date < l.etime) loy_name,
         DECODE(lal.action_type,
                1,
                :Sendmessage,
                2,
                :Connectabonus,
                3,
                :Executeactionwithservice) action_type,
         CASE
           WHEN lal.action_type = 1 THEN
            (SELECT lm.msg_name
               FROM notify_template lm
              WHERE lm.msg_id = lal.action_param)
           WHEN lal.action_type = 2 THEN
            (SELECT pb.pbonus_name
               FROM payment_bonus pb
              WHERE pb.pbonus_id = lal.action_param)
           WHEN lal.action_type = 3 THEN
            (SELECT ls.loy_serv_name
               FROM loyalty_service ls
              WHERE ls.loy_serv_id = lal.action_param)
           ELSE
            :Notdefined
         END action_param,
         lal.action_date,
         lal.try_count,
         lal.executed_date

    FROM loyalty_action_list lal
    left join loyalty_level ll
      on ll.loy_level_id = lal.loy_level_id
     and ll.smst_id = 1
     and ll.stime <= :target_date
     and ll.etime > :target_date
    left join loyalty_access_rules_detail lard
      on lard.lar_id = ll.lar_id
     and lard.smst_id = 1
     and lard.stime <= :target_date
     and lard.etime > :target_date
   where lal.clnt_id = :clnt_id
     AND :target_date <= lal.action_date)

SELECT lal.*
  FROM lard$ lal
 where (lal.access_type_id <> 15)
    or (lal.access_type_id = 15 and
       lal.int_param1 in
       (select sh.trpl_id
           from subs_history sh
          where sh.clnt_id = :clnt_id
            AND sh.stime <= lal.action_date
            and sh.etime > lal.action_date))