Symfony Profiler

select 
  * 
from 
  (
    SELECT 
      distinct on (verse_id, term_text) * 
    from 
      (
        select 
          cbb.bibleverse_id as verse_id, 
          t.id as term_id, 
          lower(t.text) as term_text, 
          c.url as concept_url, 
          char_length(t.text) as text_len, 
          ct.translatedtitle as title, 
          ct.explanation_id, 
          c.id as concept_id 
        FROM 
          verse_concept vc, 
          term_concept tc, 
          term t, 
          concept c, 
          (
            select 
              * 
            from 
              canonicalbibleverse_bibleverse 
            where 
              bibleverse_id in (
                1443001, 1443000, 1442999, 1442998, 
                1442997, 1442996, 1442995, 1442994, 
                1442993, 1442992, 1442991, 1442990, 
                1442989, 1442988, 1442987, 1442986, 
                1442985, 1442984, 1442983, 1442982, 
                1442981, 1442980, 1442979, 1442978, 
                1442977, 1442976, 1442975, 1442974, 
                1442973, 1442972, 1442971, 1442970, 
                1442969, 1442968, 1442967, 1442966, 
                1442965, 1442964, 1442963, 1442962, 
                1442961, 1442960, 1442959, 1442958, 
                1442957, 1442956, 1442955, 1442954, 
                1442953, 1442952, 1442951, 1442950, 
                1442949, 1442948, 1442947, 1442946, 
                1442945, 1442944, 1442943, 1442942, 
                1442941, 1442940, 1442939, 1442938, 
                1442937, 1442936, 1442935, 1442934, 
                1442933, 1442932, 1442931, 1442930, 
                1442929, 1442928, 1442927, 1442926, 
                1442925, 1442924, 1442923, 1442922, 
                1442921, 1442920, 1442919, 1442918, 
                1442917, 1442916
              )
          ) as cbb, 
          bibleverse bv, 
          (
            select 
              distinct on (cl.concept_id) cl.concept_id, 
              trans.translatedtitle, 
              trans.id as explanation_id, 
              case when trans.language_id = 150 then 1 else 2 end as ordering 
            from 
              concept_work cl, 
              expositiontranslation trans 
            where 
              trans.language_id in (150, 123) 
              and cl.work_id = trans.work_id 
            order by 
              cl.concept_id, 
              ordering
          ) as ct 
        WHERE 
          cbb.canonicalbibleverse_id = vc.verse_id 
          and tc.concept_id = vc.concept_id 
          and t.id = tc.term_id 
          and c.id = tc.concept_id 
          and t.language_id = 150 
          and ct.concept_id = c.id 
          and cbb.bibleverse_id = bv.id 
          and case when t.text is not null 
          and (
            bv.content ~ * (
              '\y' || replace(
                replace(
                  replace(
                    replace(t.text, ')', '\)'), 
                    '(', 
                    '\('
                  ), 
                  ']', 
                  '\]'
                ), 
                '[', 
                '\['
              ) || '\y'
            )
          ) then true else false end 
        order by 
          cbb.bibleverse_id, 
          lower(t.text), 
          term_id
      ) as t1
  ) as t 
order by 
  verse_id, 
  char_length(term_text) desc

select * from (SELECT distinct on (verse_id, term_text) * from (select cbb.bibleverse_id as verse_id, t.id as term_id, lower(t.text) as term_text, c.url as concept_url, char_length(t.text) as text_len, ct.translatedtitle as title, ct.explanation_id, c.id as concept_id FROM verse_concept vc, term_concept tc, term t, concept c, (select * from canonicalbibleverse_bibleverse where bibleverse_id in (1443001,1443000,1442999,1442998,1442997,1442996,1442995,1442994,1442993,1442992,1442991,1442990,1442989,1442988,1442987,1442986,1442985,1442984,1442983,1442982,1442981,1442980,1442979,1442978,1442977,1442976,1442975,1442974,1442973,1442972,1442971,1442970,1442969,1442968,1442967,1442966,1442965,1442964,1442963,1442962,1442961,1442960,1442959,1442958,1442957,1442956,1442955,1442954,1442953,1442952,1442951,1442950,1442949,1442948,1442947,1442946,1442945,1442944,1442943,1442942,1442941,1442940,1442939,1442938,1442937,1442936,1442935,1442934,1442933,1442932,1442931,1442930,1442929,1442928,1442927,1442926,1442925,1442924,1442923,1442922,1442921,1442920,1442919,1442918,1442917,1442916)) as cbb, bibleverse bv, (select distinct on (cl.concept_id) cl.concept_id, trans.translatedtitle, trans.id as explanation_id, case when trans.language_id = 150 then 1 else 2 end as ordering from concept_work cl, expositiontranslation trans where trans.language_id in (150, 123) and cl.work_id = trans.work_id order by cl.concept_id, ordering) as ct  WHERE cbb.canonicalbibleverse_id = vc.verse_id and tc.concept_id = vc.concept_id and t.id = tc.term_id and c.id = tc.concept_id and t.language_id = 150 and ct.concept_id = c.id and cbb.bibleverse_id = bv.id and case when t.text is not null and (bv.content ~* ('\y' || replace(replace(replace(replace(t.text, ')', '\)'), '(', '\('), ']', '\]'), '[', '\[') || '\y')) then true else false end order by cbb.bibleverse_id, lower(t.text), term_id) as t1) as t order by verse_id, char_length(term_text) desc;

SELECT 
  v.id, 
  cv.ordering as verse_order, 
  scc.ordering as chapter_order, 
  t.id as translation_id, 
  scc.id as cchapter_id, 
  v.chapter_id, 
  'bible' || '_' || bt.url || '_' || cb.url || '_' || c.ordering || '_' || v.indexdisplay as bible_spec, 
  'explanation' || '_' || t.url as explanation_spec, 
  bt.url as bible_trans_url, 
  cb.url as book_url, 
  v.indexdisplay as verse_index, 
  case when t.language_id = 150 then 1 else case when t.language_id = 116 then 2 else case when t.language_id = 123 then 4 end end end as lang_order, 
  bt.language_id 
FROM 
  (
    select 
      * 
    from 
      biblestory 
    where 
      level_id = 2
  ) as bs, 
  canonicalbibleverse cv, 
  (
    select 
      * 
    from 
      canonicalbibleverse_bibleverse 
    where 
      bibleverse_id in (
        1443001, 1443000, 1442999, 1442998, 
        1442997, 1442996, 1442995, 1442994, 
        1442993, 1442992, 1442991, 1442990, 
        1442989, 1442988, 1442987, 1442986, 
        1442985, 1442984, 1442983, 1442982, 
        1442981, 1442980, 1442979, 1442978, 
        1442977, 1442976, 1442975, 1442974, 
        1442973, 1442972, 1442971, 1442970, 
        1442969, 1442968, 1442967, 1442966, 
        1442965, 1442964, 1442963, 1442962, 
        1442961, 1442960, 1442959, 1442958, 
        1442957, 1442956, 1442955, 1442954, 
        1442953, 1442952, 1442951, 1442950, 
        1442949, 1442948, 1442947, 1442946, 
        1442945, 1442944, 1442943, 1442942, 
        1442941, 1442940, 1442939, 1442938, 
        1442937, 1442936, 1442935, 1442934, 
        1442933, 1442932, 1442931, 1442930, 
        1442929, 1442928, 1442927, 1442926, 
        1442925, 1442924, 1442923, 1442922, 
        1442921, 1442920, 1442919, 1442918, 
        1442917, 1442916
      )
  ) as cvv, 
  canonicalbiblechapter scc, 
  expositionwork w, 
  expositiontranslation t, 
  expositiontranslationtext tt, 
  story_work sw, 
  biblechapter c, 
  biblebook b, 
  bibletranslation bt, 
  canonicalbiblebook cb, 
  bibleverse v 
WHERE 
  w.ispublic 
  and t.ispublic 
  and t.language_id in (150, 116, 123) 
  and v.id = cvv.bibleverse_id 
  and cv.id = cvv.canonicalbibleverse_id 
  and bs.startverse_id = cv.id 
  and cv.chapter_id = scc.id 
  and v.verse_id is null 
  and sw.story_id = bs.id 
  and w.id = sw.work_id 
  and t.work_id = w.id 
  and v.chapter_id = c.id 
  and b.id = c.book_id 
  and b.translation_id = bt.id 
  and scc.book_id = cb.id 
  and t.id = tt.translation_id 
  and tt.text is not null 
  and tt.text <> '' 
order by 
  cv.ordering, 
  lang_order, 
  t.is_modern desc, 
  w.ordering, 
  t.islanguagedefault desc 
limit 
  1

SELECT v.id, cv.ordering as verse_order, scc.ordering as chapter_order, t.id as translation_id, scc.id as cchapter_id, v.chapter_id, 'bible' || '_' || bt.url || '_' || cb.url  || '_' || c.ordering  || '_' || v.indexdisplay as bible_spec, 'explanation' || '_' || t.url as explanation_spec, bt.url as bible_trans_url, cb.url as book_url, v.indexdisplay as verse_index, case when t.language_id = 150 then 1 else case when t.language_id = 116 then 2 else case when t.language_id = 123 then 4 end  end  end as lang_order, bt.language_id FROM (select * from biblestory where level_id = 2) as bs, canonicalbibleverse cv, (select * from canonicalbibleverse_bibleverse where bibleverse_id in (1443001,1443000,1442999,1442998,1442997,1442996,1442995,1442994,1442993,1442992,1442991,1442990,1442989,1442988,1442987,1442986,1442985,1442984,1442983,1442982,1442981,1442980,1442979,1442978,1442977,1442976,1442975,1442974,1442973,1442972,1442971,1442970,1442969,1442968,1442967,1442966,1442965,1442964,1442963,1442962,1442961,1442960,1442959,1442958,1442957,1442956,1442955,1442954,1442953,1442952,1442951,1442950,1442949,1442948,1442947,1442946,1442945,1442944,1442943,1442942,1442941,1442940,1442939,1442938,1442937,1442936,1442935,1442934,1442933,1442932,1442931,1442930,1442929,1442928,1442927,1442926,1442925,1442924,1442923,1442922,1442921,1442920,1442919,1442918,1442917,1442916)) as cvv,  canonicalbiblechapter scc, expositionwork w, expositiontranslation t, expositiontranslationtext tt, story_work sw, biblechapter c, biblebook b, bibletranslation bt, canonicalbiblebook cb, bibleverse v WHERE w.ispublic and t.ispublic and t.language_id in (150,116,123) and v.id = cvv.bibleverse_id and cv.id = cvv.canonicalbibleverse_id and bs.startverse_id = cv.id and cv.chapter_id = scc.id and v.verse_id is null and sw.story_id = bs.id and w.id = sw.work_id and t.work_id=w.id and v.chapter_id = c.id and b.id = c.book_id and b.translation_id=bt.id and scc.book_id = cb.id and t.id = tt.translation_id and tt.text is not null and tt.text <> '' order by cv.ordering, lang_order, t.is_modern desc, w.ordering, t.islanguagedefault desc limit 1;

select 
  t3.* 
from 
  (
    select 
      * 
    from 
      (
        SELECT 
          distinct on (tc.textunit_id, rc.id) tc.textunit_id, 
          rc.id as ref_id, 
          rc.originallinktext as link_text, 
          cc1.book_id, 
          rb.startverse_id as startloc_id, 
          rb.endverse_id as endloc_id, 
          true as is_bibleref, 
          'bible_' || trans.url || '_' || cb.url || '_' || cc1.ordering || (
            case when cc1.id <> cc2.id then '-' || cc2.ordering else '' end
          ) || '_' || cv1.ordering || (
            case when rb.startverse_id <> rb.endverse_id then '-' || cv2.ordering else '' end
          ) as multilink_text, 
          cc1.ordering as ordering1, 
          cv1.ordering as ordering2, 
          (
            case when trans.language_id = 150 then 2 else case when trans.language_id = 123 then case when trans.languagedefault then 3 else 4 end end end
          ) as priority_order, 
          cb.url as book_url, 
          trans.url as trans_url, 
          cc1.ordering as chapter_order1, 
          cc2.ordering as chapter_order2, 
          cv1.ordering as verse_order1, 
          cv2.ordering as verse_order2, 
          trans.url as div_url, 
          0 as passage_order 
        FROM 
          refbible rb, 
          refcombined rc, 
          textunit_combinedreference tc, 
          expositiontextunit t, 
          canonicalbibleverse cv1, 
          canonicalbiblechapter cc1, 
          canonicalbiblebook cb, 
          canonicalbibleverse_bibleverse cbb1, 
          bibleverse v1, 
          biblechapter c1, 
          canonicalbibleverse cv2, 
          canonicalbiblechapter cc2, 
          biblebook b, 
          bibletranslation trans 
        WHERE 
          t.passage_id = 36741 
          and t.id = tc.textunit_id 
          and rc.id = tc.combinedreference_id 
          and rc.id not in (
            23173, 76995, 76997, 108368, 121685, 
            131198, 137831
          ) 
          and rb.container_id = rc.id 
          and cv1.id = rb.startverse_id 
          and cv1.chapter_id = cc1.id 
          and cc1.book_id = cb.id 
          and cv1.id = cbb1.canonicalbibleverse_id 
          and v1.id = cbb1.bibleverse_id 
          and v1.chapter_id = c1.id 
          and c1.book_id = b.id 
          and cv2.id = rb.endverse_id 
          and cv2.chapter_id = cc2.id 
          and b.translation_id = trans.id 
          and trans.enabled 
        order by 
          tc.textunit_id, 
          rc.id, 
          priority_order asc, 
          trans.languagedefault desc
      ) as b 
    union 
    select 
      * 
    from 
      (
        SELECT 
          distinct on (tc.textunit_id, rc.id) tc.textunit_id, 
          rc.id as ref_id, 
          rc.originallinktext as link_text, 
          d.work_id as book_id, 
          re.startlocation_id as startloc_id, 
          re.endlocation_id as endloc_id, 
          false as is_bibleref, 
          (
            case when w.swedenborgtype is not null then 'swedenborg_' else 'explanation_' end
          ) || trans.url || (
            case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end
          ) as multilink_text, 
          p.ordering as ordering1, 
          t2.ordering as ordering2, 
          (
            case when trans.id = 62055 then 1 else case when trans.language_id = 150 then 2 else case when trans.language_id = 123 then case when trans.islanguagedefault then 3 else 4 end end end end
          ) as priority_order, 
          trans.url as book_url, 
          trans.url as trans_url, 
          0 as chapter_order1, 
          0 as chapter_order2, 
          0 as verse_order1, 
          0 as verse_order2, 
          d.url as div_url, 
          p.ordering as passage_order 
        FROM 
          refexposition re, 
          refcombined rc, 
          textunit_combinedreference tc, 
          expositiontextunit t, 
          expositiontextunit t2, 
          expositionpassage p, 
          expositiondivision d, 
          expositionwork w, 
          expositiontranslation trans, 
          expositiontranslationtext tt 
        WHERE 
          t.passage_id = 36741 
          and t.id = tc.textunit_id 
          and rc.id = tc.combinedreference_id 
          and rc.id not in (
            23173, 76995, 76997, 108368, 121685, 
            131198, 137831
          ) 
          and re.container_id = rc.id 
          and t2.id = re.startlocation_id 
          and p.id = t2.passage_id 
          and d.id = p.division_id 
          and d.work_id = w.id 
          and w.id = trans.work_id 
          and trans.url is not null 
          and trans.ispublic 
          and w.ispublic 
          and t2.id = tt.placement_id 
          and trans.id = tt.translation_id 
        order by 
          tc.textunit_id, 
          rc.id, 
          priority_order asc, 
          trans.islanguagedefault desc, 
          trans.isoriginal desc
      ) as e
  ) as t3 
order by 
  split_part(link_text, ' ', 1), 
  book_id, 
  ordering1, 
  ordering2

select t3.* from  (select * from (SELECT distinct on (tc.textunit_id, rc.id) tc.textunit_id, rc.id as ref_id, rc.originallinktext as link_text, cc1.book_id, rb.startverse_id as startloc_id, rb.endverse_id as endloc_id, true as is_bibleref, 'bible_' || trans.url || '_' || cb.url || '_' || cc1.ordering || (case when cc1.id <> cc2.id then '-' || cc2.ordering else '' end) || '_' || cv1.ordering || (case when rb.startverse_id <> rb.endverse_id then '-' || cv2.ordering else '' end) as multilink_text, cc1.ordering as ordering1, cv1.ordering as ordering2, (case when trans.language_id = 150 then 2 else case when trans.language_id = 123 then case when trans.languagedefault then 3 else 4 end end end) as priority_order, cb.url as book_url, trans.url as trans_url, cc1.ordering as chapter_order1, cc2.ordering as chapter_order2, cv1.ordering as verse_order1, cv2.ordering as verse_order2, trans.url as div_url, 0 as passage_order  FROM refbible rb, refcombined rc, textunit_combinedreference tc, expositiontextunit t, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse_bibleverse cbb1, bibleverse v1, biblechapter c1, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation trans WHERE t.passage_id = 36741 and t.id = tc.textunit_id and rc.id = tc.combinedreference_id  and rc.id not in (23173,76995,76997,108368,121685,131198,137831) and rb.container_id = rc.id and cv1.id = rb.startverse_id and cv1.chapter_id = cc1.id and cc1.book_id = cb.id and cv1.id = cbb1.canonicalbibleverse_id and v1.id = cbb1.bibleverse_id and v1.chapter_id = c1.id and c1.book_id = b.id and cv2.id = rb.endverse_id and cv2.chapter_id = cc2.id and b.translation_id = trans.id and trans.enabled order by tc.textunit_id, rc.id, priority_order asc, trans.languagedefault desc) as b union select * from (SELECT distinct on (tc.textunit_id, rc.id) tc.textunit_id, rc.id as ref_id, rc.originallinktext as link_text, d.work_id as book_id, re.startlocation_id as startloc_id, re.endlocation_id as endloc_id, false as is_bibleref, (case when w.swedenborgtype is not null then 'swedenborg_' else 'explanation_' end) || trans.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as multilink_text, p.ordering as ordering1, t2.ordering as ordering2, (case when trans.id = 62055 then 1 else case when trans.language_id = 150 then 2 else case when trans.language_id = 123 then case when trans.islanguagedefault then 3 else 4 end end end end) as priority_order, trans.url as book_url, trans.url as trans_url, 0 as chapter_order1, 0 as chapter_order2, 0 as verse_order1, 0 as verse_order2, d.url as div_url, p.ordering as passage_order FROM refexposition re, refcombined rc, textunit_combinedreference tc, expositiontextunit t, expositiontextunit t2, expositionpassage p, expositiondivision d, expositionwork w, expositiontranslation trans, expositiontranslationtext tt WHERE t.passage_id = 36741 and t.id = tc.textunit_id and rc.id = tc.combinedreference_id  and rc.id not in (23173,76995,76997,108368,121685,131198,137831) and re.container_id = rc.id and t2.id = re.startlocation_id and p.id = t2.passage_id and d.id = p.division_id and d.work_id = w.id and w.id = trans.work_id and trans.url is not null and trans.ispublic and w.ispublic and t2.id = tt.placement_id and trans.id = tt.translation_id order by tc.textunit_id, rc.id, priority_order asc, trans.islanguagedefault desc, trans.isoriginal desc) as e) as t3 order by split_part(link_text, ' ', 1), book_id, ordering1, ordering2;

SELECT 
  DISTINCT v.id 
FROM 
  bibleverse v, 
  bibleverse mainv, 
  biblechapter c, 
  biblebook b, 
  bibletranslation t, 
  canonicalbibleverse cv, 
  canonicalbiblechapter cc, 
  canonicalbiblebook cb, 
  canonicalbibleverse_bibleverse cvv 
WHERE 
  (
    (
      v.id = mainv.id 
      AND v.verse_id IS NULL
    ) 
    OR (v.verse_id = mainv.id)
  ) 
  AND mainv.chapter_id = c.id 
  AND c.book_id = b.id 
  AND b.translation_id = t.id 
  AND t.enabled 
  AND cv.chapter_id = cc.id 
  AND cc.book_id = cb.id 
  AND cv.id = cvv.canonicalbibleverse_id 
  AND v.id = cvv.bibleverse_id 
  AND t.id =: bible_translation_id 
  AND cb.id =: canonical_book_id 
  AND cc.ordering >= : canonical_first_chapter_ord 
  AND cc.ordering <= : canonical_last_chapter_ord 
  AND (
    cc.ordering > : canonical_first_chapter_ord 
    OR cv.ordering >= : canonical_first_verse_ord
  ) 
  AND (
    cc.ordering < : canonical_last_chapter_ord 
    OR cv.ordering <= : canonical_last_verse_ord
  )

SELECT DISTINCT v.id FROM bibleverse v, bibleverse mainv, biblechapter c, biblebook b, bibletranslation t, canonicalbibleverse cv, canonicalbiblechapter cc, canonicalbiblebook cb, canonicalbibleverse_bibleverse cvv WHERE ( (v.id=mainv.id AND v.verse_id IS NULL) OR (v.verse_id=mainv.id) ) AND mainv.chapter_id=c.id AND c.book_id=b.id AND b.translation_id=t.id AND t.enabled AND cv.chapter_id=cc.id AND cc.book_id=cb.id AND cv.id=cvv.canonicalbibleverse_id AND v.id=cvv.bibleverse_id AND t.id=62 AND cb.id=7 AND cc.ordering >= 3 AND cc.ordering <= 5 AND (cc.ordering > 3 OR cv.ordering >= 1) AND (cc.ordering < 5 OR cv.ordering <= 31);

SELECT 
  t0.id AS id_1, 
  t0.ordering AS ordering_2, 
  t0.chapter_id AS chapter_id_3 
FROM 
  canonicalbibleverse t0 
  INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id 
WHERE 
  canonicalbibleverse_bibleverse.bibleverse_id = ?

SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = 1443001;

SELECT 
  t0.id AS id_1, 
  t0.indexDisplay AS indexdisplay_2, 
  t0.ordering AS ordering_3, 
  t0.content AS content_4, 
  t0.contentVector AS contentvector_5, 
  t0.chapter_id AS chapter_id_6, 
  t0.verse_id AS verse_id_7 
FROM 
  bibleverse t0 
WHERE 
  t0.verse_id = ? 
ORDER BY 
  t0.ordering ASC

SELECT t0.id AS id_1, t0.indexDisplay AS indexdisplay_2, t0.ordering AS ordering_3, t0.content AS content_4, t0.contentVector AS contentvector_5, t0.chapter_id AS chapter_id_6, t0.verse_id AS verse_id_7 FROM bibleverse t0 WHERE t0.verse_id = 1443001 ORDER BY t0.ordering ASC;

select 
  * 
from 
  (
    SELECT 
      distinct on (p.id) p.id, 
      w.swedenborgtype, 
      t.translatedtitle AS title, 
      p.swedenborgsection as num, 
      'swedenborg' || '_' || t.url || (
        case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end
      ) as ref_column_spec, 
      t.url as translation_url, 
      d.url as division_url, 
      w.ordering as work_order, 
      p.ordering, 
      case when t.language_id = 150 then 1 else 2 end as lang_order 
    FROM 
      expositionwork w, 
      expositiontranslation t, 
      expositionpassage p, 
      expositiondivision d 
    WHERE 
      p.id in (
        SELECT 
          DISTINCT passage_id 
        FROM 
          verse_passage 
        WHERE 
          verse_id in (
            16494, 16495, 16496, 16497, 16498, 16499, 
            16500, 16501, 16502, 16503, 16504, 
            16505, 16506, 16507, 16508, 16509, 
            16510, 16511, 16512, 16513, 16514, 
            16515, 16516, 16517, 16518, 16519, 
            16520, 16521, 16522, 16523, 16524, 
            16525, 16526, 16527, 16528, 16529, 
            16530, 16531, 16532, 16533, 16534, 
            16535, 16536, 16537, 16538, 16539, 
            16540, 16541, 16542, 16543, 16544, 
            16545, 16546, 16547, 16548, 16549, 
            16550, 16551, 16552, 16553, 16554, 
            16555, 16556, 16557, 16558, 16559, 
            16560, 16561, 16562, 16563, 16564, 
            16565, 16566, 16567, 16568, 16569, 
            16570, 16571, 16572, 16573, 16574, 
            16575, 16576, 16577, 16578, 16579
          )
      ) 
      and p.id not in (
        SELECT 
          DISTINCT passage_id 
        FROM 
          chapter_passage 
        WHERE 
          chapter_id in (716, 715, 714) 
        union 
        SELECT 
          DISTINCT passage_id 
        FROM 
          verse_passage 
        WHERE 
          verse_id in (
            16494, 16495, 16496, 16497, 16498, 16499, 
            16500, 16501, 16502, 16503, 16504, 
            16505, 16506, 16507, 16508, 16509, 
            16510, 16511, 16512, 16513, 16514, 
            16515, 16516, 16517, 16518, 16519, 
            16520, 16521, 16522, 16523, 16524, 
            16525, 16526, 16527, 16528, 16529, 
            16530, 16531, 16532, 16533, 16534, 
            16535, 16536, 16537, 16538, 16539, 
            16540, 16541, 16542, 16543, 16544, 
            16545, 16546, 16547, 16548, 16549, 
            16550, 16551, 16552, 16553, 16554, 
            16555, 16556, 16557, 16558, 16559, 
            16560, 16561, 16562, 16563, 16564, 
            16565, 16566, 16567, 16568, 16569, 
            16570, 16571, 16572, 16573, 16574, 
            16575, 16576, 16577, 16578, 16579
          ) 
          and iscorepassage
      ) 
      and w.swedenborgtype is not null 
      and t.work_id = w.id 
      and d.work_id = w.id 
      and p.division_id = d.id 
      and t.id in (
        SELECT 
          distinct on (w.id) t.id 
        FROM 
          expositionwork w, 
          expositiontranslation t, 
          expositionpassage p, 
          expositiondivision d 
        WHERE 
          p.id in (
            SELECT 
              DISTINCT passage_id 
            FROM 
              verse_passage 
            WHERE 
              verse_id in (
                16494, 16495, 16496, 16497, 16498, 16499, 
                16500, 16501, 16502, 16503, 16504, 
                16505, 16506, 16507, 16508, 16509, 
                16510, 16511, 16512, 16513, 16514, 
                16515, 16516, 16517, 16518, 16519, 
                16520, 16521, 16522, 16523, 16524, 
                16525, 16526, 16527, 16528, 16529, 
                16530, 16531, 16532, 16533, 16534, 
                16535, 16536, 16537, 16538, 16539, 
                16540, 16541, 16542, 16543, 16544, 
                16545, 16546, 16547, 16548, 16549, 
                16550, 16551, 16552, 16553, 16554, 
                16555, 16556, 16557, 16558, 16559, 
                16560, 16561, 16562, 16563, 16564, 
                16565, 16566, 16567, 16568, 16569, 
                16570, 16571, 16572, 16573, 16574, 
                16575, 16576, 16577, 16578, 16579
              )
          ) 
          and p.id not in (
            SELECT 
              DISTINCT passage_id 
            FROM 
              chapter_passage 
            WHERE 
              chapter_id in (716, 715, 714) 
            union 
            SELECT 
              DISTINCT passage_id 
            FROM 
              verse_passage 
            WHERE 
              verse_id in (
                16494, 16495, 16496, 16497, 16498, 16499, 
                16500, 16501, 16502, 16503, 16504, 
                16505, 16506, 16507, 16508, 16509, 
                16510, 16511, 16512, 16513, 16514, 
                16515, 16516, 16517, 16518, 16519, 
                16520, 16521, 16522, 16523, 16524, 
                16525, 16526, 16527, 16528, 16529, 
                16530, 16531, 16532, 16533, 16534, 
                16535, 16536, 16537, 16538, 16539, 
                16540, 16541, 16542, 16543, 16544, 
                16545, 16546, 16547, 16548, 16549, 
                16550, 16551, 16552, 16553, 16554, 
                16555, 16556, 16557, 16558, 16559, 
                16560, 16561, 16562, 16563, 16564, 
                16565, 16566, 16567, 16568, 16569, 
                16570, 16571, 16572, 16573, 16574, 
                16575, 16576, 16577, 16578, 16579
              ) 
              and iscorepassage
          ) 
          and t.work_id = w.id 
          and d.work_id = w.id 
          and p.division_id = d.id 
          and t.language_id in (150, 123) 
          and t.ispublic 
          and w.ispublic 
          and t.url is not null 
          and t.url <> '' 
          AND t.type_id = 1 
        order by 
          w.id, 
          t.islanguagedefault desc 
        limit 
          1
      ) 
    order by 
      p.id, 
      lang_order
  ) as t2 
order by 
  work_order, 
  title, 
  ordering