Symfony Profiler

SELECT 
  p.id, 
  t.url as translation_url, 
  d.url as division_url, 
  (
    case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end
  ) as passage_num, 
  p.ordering as passage_order, 
  (
    case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end
  ) || '_' || t.url || (
    case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end
  ) as multi_spec 
FROM 
  expositionpassage p, 
  expositiondivision d, 
  expositiontranslationtext tt, 
  expositiontextunit tu, 
  expositiontranslation t, 
  expositionwork w 
WHERE 
  d.work_id = 1 
  and p.division_id = d.id 
  and p.ordering < 59580 
  and tt.translation_id = 114 
  and tt.placement_id = tu.id 
  and tu.passage_id = p.id 
  and t.id = tt.translation_id 
  and d.work_id = w.id 
order by 
  p.ordering desc 
limit 
  1

SELECT p.id, t.url as translation_url, d.url as division_url,  (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec  FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 1 and p.division_id = d.id and p.ordering < 59580 and tt.translation_id=114 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering desc limit 1;

select 
  * 
from 
  (
    SELECT 
      distinct on (di.ref_id) di.ref_id, 
      'bible_' || t.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, 
      true as is_bibleref, 
      1 as section_order, 
      (
        case when t.language_id in (
          select 
            language_id 
          from 
            expositiontranslation 
          where 
            id = 112
        ) then 1 else case when t.language_id = 123 then 2 else 3 end end
      ) as priority_order, 
      cb.url as book_url, 
      t.url as trans_url, 
      cc1.ordering as chapter_order1, 
      cc2.ordering as chapter_order2, 
      cv1.ordering as verse_order1, 
      cv2.ordering as verse_order2, 
      t.url as div_url, 
      0 as passage_order 
    FROM 
      refbible rb, 
      expositiontextunit tu, 
      expositiontranslationtext tt, 
      expositiondisplayitem di, 
      canonicalbibleverse cv1, 
      canonicalbiblechapter cc1, 
      canonicalbiblebook cb, 
      canonicalbibleverse cv2, 
      canonicalbiblechapter cc2, 
      biblebook b, 
      bibletranslation t 
    WHERE 
      tu.passage_id = 1410 
      and tu.id = tt.placement_id 
      and rb.container_id = di.ref_id 
      and di.container_id = tt.id 
      and di.ref_id is not null 
      and cv1.id = rb.startverse_id 
      and cv1.chapter_id = cc1.id 
      and cc1.book_id = cb.id 
      and cv2.id = rb.endverse_id 
      and cv2.chapter_id = cc2.id 
      and b.canonicalization_id = cb.id 
      and b.translation_id = t.id 
      and (
        t.enabled 
        and not t.restricted_access
      ) 
    order by 
      di.ref_id, 
      priority_order asc, 
      t.languagedefault desc
  ) as b 
union 
select 
  * 
from 
  (
    SELECT 
      distinct on (di.ref_id) di.ref_id, 
      (
        case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end
      ) || '_' || t.url || (
        case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end
      ) as multilink, 
      false as is_bibleref, 
      t2.ordering as section_order, 
      (
        case when t.id = 112 then 1 else case when t.language_id in (
          select 
            language_id 
          from 
            expositiontranslation 
          where 
            id = 112
        ) then 2 else case when t.language_id = 123 then 3 else 4 end end end
      ) as priority_order, 
      t.url as book_url, 
      t.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, 
      expositiontextunit tu, 
      expositiontextunit t2, 
      expositionpassage p, 
      expositiondivision d, 
      expositiontranslationtext tt, 
      expositiondisplayitem di, 
      expositionwork w, 
      expositiontranslation t 
    WHERE 
      tu.passage_id = 1410 
      and t2.id = re.startlocation_id 
      and p.id = t2.passage_id 
      and d.id = p.division_id 
      and re.container_id = di.ref_id 
      and tu.id = tt.placement_id 
      and di.container_id = tt.id 
      and di.ref_id is not null 
      and d.work_id = w.id 
      and w.id = t.work_id 
      and t.url is not null 
      and (
        t.ispublic 
        and not t.restricted_access
      ) 
      and w.ispublic 
    order by 
      di.ref_id, 
      priority_order asc, 
      t.islanguagedefault desc, 
      t.isoriginal desc
  ) as e

select * from (SELECT distinct on (di.ref_id) di.ref_id, 'bible_' || t.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, true as is_bibleref, 1 as section_order, (case when t.language_id in (select language_id from expositiontranslation where id = 112) then 1 else case when t.language_id = 123 then 2 else 3 end end ) as priority_order, cb.url as book_url, t.url as trans_url, cc1.ordering as chapter_order1, cc2.ordering as chapter_order2, cv1.ordering as verse_order1, cv2.ordering as verse_order2, t.url as div_url, 0 as passage_order FROM refbible rb, expositiontextunit tu, expositiontranslationtext tt, expositiondisplayitem di, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation t  WHERE tu.passage_id = 1410 and tu.id = tt.placement_id and rb.container_id = di.ref_id and di.container_id = tt.id and di.ref_id is not null and cv1.id = rb.startverse_id and cv1.chapter_id = cc1.id and cc1.book_id = cb.id and cv2.id = rb.endverse_id and cv2.chapter_id = cc2.id and b.canonicalization_id = cb.id and b.translation_id = t.id and  (t.enabled and not t.restricted_access)  order by di.ref_id, priority_order asc, t.languagedefault desc) as b union select * from (SELECT distinct on (di.ref_id) di.ref_id, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as multilink, false as is_bibleref, t2.ordering as section_order,  (case when t.id = 112 then 1 else case when t.language_id in (select language_id from expositiontranslation where id = 112) then 2 else case when t.language_id = 123 then 3 else 4 end end end) as priority_order, t.url as book_url, t.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, expositiontextunit tu, expositiontextunit t2, expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiondisplayitem di, expositionwork w, expositiontranslation t WHERE tu.passage_id = 1410 and t2.id = re.startlocation_id and p.id = t2.passage_id and d.id = p.division_id and re.container_id = di.ref_id and tu.id = tt.placement_id and di.container_id = tt.id and di.ref_id is not null and d.work_id = w.id and w.id = t.work_id and t.url is not null and  (t.ispublic and not t.restricted_access)  and w.ispublic order by di.ref_id, priority_order asc, t.islanguagedefault desc, t.isoriginal desc) as e;

SELECT 
  p.id, 
  t.url as translation_url, 
  d.url as division_url, 
  (
    case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end
  ) as passage_num, 
  p.ordering as passage_order, 
  (
    case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end
  ) || '_' || t.url || (
    case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end
  ) as multi_spec 
FROM 
  expositionpassage p, 
  expositiondivision d, 
  expositiontranslationtext tt, 
  expositiontextunit tu, 
  expositiontranslation t, 
  expositionwork w 
WHERE 
  d.work_id = 1 
  and p.division_id = d.id 
  and p.ordering > 35040 
  and tt.translation_id = 114 
  and tt.placement_id = tu.id 
  and tu.passage_id = p.id 
  and t.id = tt.translation_id 
  and d.work_id = w.id 
order by 
  p.ordering 
limit 
  1

SELECT p.id, t.url as translation_url, d.url as division_url, (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec  FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 1 and p.division_id = d.id and p.ordering > 35040 and tt.translation_id=114 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering limit 1;

SELECT 
  p.id, 
  t.url as translation_url, 
  d.url as division_url, 
  (
    case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end
  ) as passage_num, 
  p.ordering as passage_order, 
  (
    case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end
  ) || '_' || t.url || (
    case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end
  ) as multi_spec 
FROM 
  expositionpassage p, 
  expositiondivision d, 
  expositiontranslationtext tt, 
  expositiontextunit tu, 
  expositiontranslation t, 
  expositionwork w 
WHERE 
  d.work_id = 1 
  and p.division_id = d.id 
  and p.ordering > 59580 
  and tt.translation_id = 114 
  and tt.placement_id = tu.id 
  and tu.passage_id = p.id 
  and t.id = tt.translation_id 
  and d.work_id = w.id 
order by 
  p.ordering 
limit 
  1

SELECT p.id, t.url as translation_url, d.url as division_url, (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec  FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 1 and p.division_id = d.id and p.ordering > 59580 and tt.translation_id=114 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering limit 1;

select 
  * 
from 
  (
    SELECT 
      distinct on (di.ref_id) di.ref_id, 
      'bible_' || t.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, 
      true as is_bibleref, 
      1 as section_order, 
      (
        case when t.language_id in (
          select 
            language_id 
          from 
            expositiontranslation 
          where 
            id = 114
        ) then 1 else case when t.language_id = 123 then 2 else 3 end end
      ) as priority_order, 
      cb.url as book_url, 
      t.url as trans_url, 
      cc1.ordering as chapter_order1, 
      cc2.ordering as chapter_order2, 
      cv1.ordering as verse_order1, 
      cv2.ordering as verse_order2, 
      t.url as div_url, 
      0 as passage_order 
    FROM 
      refbible rb, 
      expositiontextunit tu, 
      expositiontranslationtext tt, 
      expositiondisplayitem di, 
      canonicalbibleverse cv1, 
      canonicalbiblechapter cc1, 
      canonicalbiblebook cb, 
      canonicalbibleverse cv2, 
      canonicalbiblechapter cc2, 
      biblebook b, 
      bibletranslation t 
    WHERE 
      tu.passage_id = 20346 
      and tu.id = tt.placement_id 
      and rb.container_id = di.ref_id 
      and di.container_id = tt.id 
      and di.ref_id is not null 
      and cv1.id = rb.startverse_id 
      and cv1.chapter_id = cc1.id 
      and cc1.book_id = cb.id 
      and cv2.id = rb.endverse_id 
      and cv2.chapter_id = cc2.id 
      and b.canonicalization_id = cb.id 
      and b.translation_id = t.id 
      and (
        t.enabled 
        and not t.restricted_access
      ) 
    order by 
      di.ref_id, 
      priority_order asc, 
      t.languagedefault desc
  ) as b 
union 
select 
  * 
from 
  (
    SELECT 
      distinct on (di.ref_id) di.ref_id, 
      (
        case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end
      ) || '_' || t.url || (
        case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end
      ) as multilink, 
      false as is_bibleref, 
      t2.ordering as section_order, 
      (
        case when t.id = 114 then 1 else case when t.language_id in (
          select 
            language_id 
          from 
            expositiontranslation 
          where 
            id = 114
        ) then 2 else case when t.language_id = 123 then 3 else 4 end end end
      ) as priority_order, 
      t.url as book_url, 
      t.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, 
      expositiontextunit tu, 
      expositiontextunit t2, 
      expositionpassage p, 
      expositiondivision d, 
      expositiontranslationtext tt, 
      expositiondisplayitem di, 
      expositionwork w, 
      expositiontranslation t 
    WHERE 
      tu.passage_id = 20346 
      and t2.id = re.startlocation_id 
      and p.id = t2.passage_id 
      and d.id = p.division_id 
      and re.container_id = di.ref_id 
      and tu.id = tt.placement_id 
      and di.container_id = tt.id 
      and di.ref_id is not null 
      and d.work_id = w.id 
      and w.id = t.work_id 
      and t.url is not null 
      and (
        t.ispublic 
        and not t.restricted_access
      ) 
      and w.ispublic 
    order by 
      di.ref_id, 
      priority_order asc, 
      t.islanguagedefault desc, 
      t.isoriginal desc
  ) as e

select * from (SELECT distinct on (di.ref_id) di.ref_id, 'bible_' || t.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, true as is_bibleref, 1 as section_order, (case when t.language_id in (select language_id from expositiontranslation where id = 114) then 1 else case when t.language_id = 123 then 2 else 3 end end ) as priority_order, cb.url as book_url, t.url as trans_url, cc1.ordering as chapter_order1, cc2.ordering as chapter_order2, cv1.ordering as verse_order1, cv2.ordering as verse_order2, t.url as div_url, 0 as passage_order FROM refbible rb, expositiontextunit tu, expositiontranslationtext tt, expositiondisplayitem di, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation t  WHERE tu.passage_id = 20346 and tu.id = tt.placement_id and rb.container_id = di.ref_id and di.container_id = tt.id and di.ref_id is not null and cv1.id = rb.startverse_id and cv1.chapter_id = cc1.id and cc1.book_id = cb.id and cv2.id = rb.endverse_id and cv2.chapter_id = cc2.id and b.canonicalization_id = cb.id and b.translation_id = t.id and  (t.enabled and not t.restricted_access)  order by di.ref_id, priority_order asc, t.languagedefault desc) as b union select * from (SELECT distinct on (di.ref_id) di.ref_id, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as multilink, false as is_bibleref, t2.ordering as section_order,  (case when t.id = 114 then 1 else case when t.language_id in (select language_id from expositiontranslation where id = 114) then 2 else case when t.language_id = 123 then 3 else 4 end end end) as priority_order, t.url as book_url, t.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, expositiontextunit tu, expositiontextunit t2, expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiondisplayitem di, expositionwork w, expositiontranslation t WHERE tu.passage_id = 20346 and t2.id = re.startlocation_id and p.id = t2.passage_id and d.id = p.division_id and re.container_id = di.ref_id and tu.id = tt.placement_id and di.container_id = tt.id and di.ref_id is not null and d.work_id = w.id and w.id = t.work_id and t.url is not null and  (t.ispublic and not t.restricted_access)  and w.ispublic order by di.ref_id, priority_order asc, t.islanguagedefault desc, t.isoriginal desc) as e;

SELECT 
  p.id, 
  t.url as translation_url, 
  d.url as division_url, 
  (
    case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end
  ) as passage_num, 
  p.ordering as passage_order, 
  (
    case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end
  ) || '_' || t.url || (
    case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end
  ) as multi_spec 
FROM 
  expositionpassage p, 
  expositiondivision d, 
  expositiontranslationtext tt, 
  expositiontextunit tu, 
  expositiontranslation t, 
  expositionwork w 
WHERE 
  d.work_id = 1 
  and p.division_id = d.id 
  and p.ordering < 35040 
  and tt.translation_id = 114 
  and tt.placement_id = tu.id 
  and tu.passage_id = p.id 
  and t.id = tt.translation_id 
  and d.work_id = w.id 
order by 
  p.ordering desc 
limit 
  1

SELECT p.id, t.url as translation_url, d.url as division_url,  (case when p.swedenborgsection is not null then p.swedenborgsection else cast(p.ordering as text) end) as passage_num, p.ordering as passage_order, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '_' || p.ordering end) as multi_spec  FROM expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiontextunit tu, expositiontranslation t, expositionwork w WHERE d.work_id = 1 and p.division_id = d.id and p.ordering < 35040 and tt.translation_id=114 and tt.placement_id = tu.id and tu.passage_id = p.id and t.id = tt.translation_id and d.work_id = w.id order by p.ordering desc limit 1;

select 
  * 
from 
  (
    SELECT 
      distinct on (di.ref_id) di.ref_id, 
      'bible_' || t.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, 
      true as is_bibleref, 
      1 as section_order, 
      (
        case when t.language_id in (
          select 
            language_id 
          from 
            expositiontranslation 
          where 
            id = 114
        ) then 1 else case when t.language_id = 123 then 2 else 3 end end
      ) as priority_order, 
      cb.url as book_url, 
      t.url as trans_url, 
      cc1.ordering as chapter_order1, 
      cc2.ordering as chapter_order2, 
      cv1.ordering as verse_order1, 
      cv2.ordering as verse_order2, 
      t.url as div_url, 
      0 as passage_order 
    FROM 
      refbible rb, 
      expositiontextunit tu, 
      expositiontranslationtext tt, 
      expositiondisplayitem di, 
      canonicalbibleverse cv1, 
      canonicalbiblechapter cc1, 
      canonicalbiblebook cb, 
      canonicalbibleverse cv2, 
      canonicalbiblechapter cc2, 
      biblebook b, 
      bibletranslation t 
    WHERE 
      tu.passage_id = 17893 
      and tu.id = tt.placement_id 
      and rb.container_id = di.ref_id 
      and di.container_id = tt.id 
      and di.ref_id is not null 
      and cv1.id = rb.startverse_id 
      and cv1.chapter_id = cc1.id 
      and cc1.book_id = cb.id 
      and cv2.id = rb.endverse_id 
      and cv2.chapter_id = cc2.id 
      and b.canonicalization_id = cb.id 
      and b.translation_id = t.id 
      and (
        t.enabled 
        and not t.restricted_access
      ) 
    order by 
      di.ref_id, 
      priority_order asc, 
      t.languagedefault desc
  ) as b 
union 
select 
  * 
from 
  (
    SELECT 
      distinct on (di.ref_id) di.ref_id, 
      (
        case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end
      ) || '_' || t.url || (
        case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end
      ) as multilink, 
      false as is_bibleref, 
      t2.ordering as section_order, 
      (
        case when t.id = 114 then 1 else case when t.language_id in (
          select 
            language_id 
          from 
            expositiontranslation 
          where 
            id = 114
        ) then 2 else case when t.language_id = 123 then 3 else 4 end end end
      ) as priority_order, 
      t.url as book_url, 
      t.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, 
      expositiontextunit tu, 
      expositiontextunit t2, 
      expositionpassage p, 
      expositiondivision d, 
      expositiontranslationtext tt, 
      expositiondisplayitem di, 
      expositionwork w, 
      expositiontranslation t 
    WHERE 
      tu.passage_id = 17893 
      and t2.id = re.startlocation_id 
      and p.id = t2.passage_id 
      and d.id = p.division_id 
      and re.container_id = di.ref_id 
      and tu.id = tt.placement_id 
      and di.container_id = tt.id 
      and di.ref_id is not null 
      and d.work_id = w.id 
      and w.id = t.work_id 
      and t.url is not null 
      and (
        t.ispublic 
        and not t.restricted_access
      ) 
      and w.ispublic 
    order by 
      di.ref_id, 
      priority_order asc, 
      t.islanguagedefault desc, 
      t.isoriginal desc
  ) as e

select * from (SELECT distinct on (di.ref_id) di.ref_id, 'bible_' || t.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, true as is_bibleref, 1 as section_order, (case when t.language_id in (select language_id from expositiontranslation where id = 114) then 1 else case when t.language_id = 123 then 2 else 3 end end ) as priority_order, cb.url as book_url, t.url as trans_url, cc1.ordering as chapter_order1, cc2.ordering as chapter_order2, cv1.ordering as verse_order1, cv2.ordering as verse_order2, t.url as div_url, 0 as passage_order FROM refbible rb, expositiontextunit tu, expositiontranslationtext tt, expositiondisplayitem di, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation t  WHERE tu.passage_id = 17893 and tu.id = tt.placement_id and rb.container_id = di.ref_id and di.container_id = tt.id and di.ref_id is not null and cv1.id = rb.startverse_id and cv1.chapter_id = cc1.id and cc1.book_id = cb.id and cv2.id = rb.endverse_id and cv2.chapter_id = cc2.id and b.canonicalization_id = cb.id and b.translation_id = t.id and  (t.enabled and not t.restricted_access)  order by di.ref_id, priority_order asc, t.languagedefault desc) as b union select * from (SELECT distinct on (di.ref_id) di.ref_id, (case when w.swedenborgtype is not null then 'swedenborg' else 'explanation' end) || '_' || t.url || (case when p.swedenborgsection is not null then '_' || p.swedenborgsection else '' end) as multilink, false as is_bibleref, t2.ordering as section_order,  (case when t.id = 114 then 1 else case when t.language_id in (select language_id from expositiontranslation where id = 114) then 2 else case when t.language_id = 123 then 3 else 4 end end end) as priority_order, t.url as book_url, t.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, expositiontextunit tu, expositiontextunit t2, expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiondisplayitem di, expositionwork w, expositiontranslation t WHERE tu.passage_id = 17893 and t2.id = re.startlocation_id and p.id = t2.passage_id and d.id = p.division_id and re.container_id = di.ref_id and tu.id = tt.placement_id and di.container_id = tt.id and di.ref_id is not null and d.work_id = w.id and w.id = t.work_id and t.url is not null and  (t.ispublic and not t.restricted_access)  and w.ispublic order by di.ref_id, priority_order asc, t.islanguagedefault desc, t.isoriginal desc) as e;