Symfony Profiler

SELECT 
  id 
FROM 
  language 
WHERE 
  shortcode = 'ru' 
limit 
  1

SELECT id FROM language WHERE shortcode = 'ru' limit 1;

SELECT 
  max(sl.datemod) 
FROM 
  ui_string_language sl, 
  ui_string s 
WHERE 
  sl.language_id in (363, 123) 
  and s.id = sl.ui_string_id 
  and s.is_active 
  and s.type_id in (1, 3)

SELECT max(sl.datemod) FROM ui_string_language sl, ui_string s WHERE sl.language_id in (363, 123) and s.id = sl.ui_string_id and s.is_active and s.type_id in (1, 3);

SELECT 
  distinct s.name, 
  case when sl2.id is null then sl.text else sl2.text end as text, 
  s.fix_quote 
FROM 
  (
    select 
      * 
    from 
      ui_string_language 
    where 
      language_id = 123
  ) sl, 
  ui_string s 
  left join (
    select 
      * 
    from 
      ui_string_language 
    where 
      language_id = 363 
      and text is not null 
      and text <> ''
  ) sl2 on s.id = sl2.ui_string_id 
where 
  s.id = sl.ui_string_id 
  and s.is_active 
  and s.type_id in (1, 3)

SELECT distinct s.name, case when sl2.id is null then sl.text else sl2.text end as text, s.fix_quote FROM (select * from ui_string_language where language_id = 123) sl, ui_string s left join (select * from ui_string_language where language_id = 363 and text is not null and text <> '') sl2 on s.id = sl2.ui_string_id where s.id = sl.ui_string_id and s.is_active and s.type_id in (1, 3);

SELECT 
  t0.id AS id_1, 
  t0.translatedTitle AS translatedtitle_2, 
  t0.name AS name_3, 
  t0.description AS description_4, 
  t0.url AS url_5, 
  t0.isPublic AS ispublic_6, 
  t0.audience AS audience_7, 
  t0.isOriginal AS isoriginal_8, 
  t0.isLanguageDefault AS islanguagedefault_9, 
  t0.type_id AS type_id_10, 
  t0.translationmethod_id AS translationmethod_id_11, 
  t0.public_file AS public_file_12, 
  t0.doc_link AS doc_link_13, 
  t0.work_id AS work_id_14, 
  t0.language_id AS language_id_15 
FROM 
  expositiontranslation t0 
WHERE 
  t0.url = ? 
  AND t0.isPublic = ? 
  AND t0.type_id = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.translatedTitle AS translatedtitle_2, t0.name AS name_3, t0.description AS description_4, t0.url AS url_5, t0.isPublic AS ispublic_6, t0.audience AS audience_7, t0.isOriginal AS isoriginal_8, t0.isLanguageDefault AS islanguagedefault_9, t0.type_id AS type_id_10, t0.translationmethod_id AS translationmethod_id_11, t0.public_file AS public_file_12, t0.doc_link AS doc_link_13, t0.work_id AS work_id_14, t0.language_id AS language_id_15 FROM expositiontranslation t0 WHERE t0.url = 'inner-meaning-of-luke-2-hi' AND t0.isPublic = 1 AND t0.type_id = 1 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2, 
  t0.fullTitle AS fulltitle_3, 
  t0.description AS description_4, 
  t0.url AS url_5, 
  t0.isPublic AS ispublic_6, 
  t0.audience AS audience_7, 
  t0.swedenborgType AS swedenborgtype_8 
FROM 
  expositionwork t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.fullTitle AS fulltitle_3, t0.description AS description_4, t0.url AS url_5, t0.isPublic AS ispublic_6, t0.audience AS audience_7, t0.swedenborgType AS swedenborgtype_8 FROM expositionwork t0 WHERE t0.id = 11146;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.url AS url_3, 
  t0.ordering AS ordering_4, 
  t0.work_id AS work_id_5, 
  t0.superdivision_id AS superdivision_id_6 
FROM 
  expositiondivision t0 
WHERE 
  t0.work_id = ? 
ORDER BY 
  t0.ordering ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.ordering AS ordering_4, t0.work_id AS work_id_5, t0.superdivision_id AS superdivision_id_6 FROM expositiondivision t0 WHERE t0.work_id = 11146 ORDER BY t0.ordering ASC;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.url AS url_3, 
  t0.ordering AS ordering_4, 
  t0.work_id AS work_id_5, 
  t0.superdivision_id AS superdivision_id_6 
FROM 
  expositiondivision t0 
WHERE 
  t0.superdivision_id = ? 
ORDER BY 
  t0.ordering ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.ordering AS ordering_4, t0.work_id AS work_id_5, t0.superdivision_id AS superdivision_id_6 FROM expositiondivision t0 WHERE t0.superdivision_id = 10414 ORDER BY t0.ordering ASC;

SELECT 
  t0.id AS id_1, 
  t0.ordering AS ordering_2, 
  t0.title AS title_3, 
  t0.swedenborgSection AS swedenborgsection_4, 
  t0.division_id AS division_id_5 
FROM 
  expositionpassage t0 
WHERE 
  t0.division_id = ? 
ORDER BY 
  t0.ordering ASC

SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.title AS title_3, t0.swedenborgSection AS swedenborgsection_4, t0.division_id AS division_id_5 FROM expositionpassage t0 WHERE t0.division_id = 10414 ORDER BY t0.ordering ASC;

SELECT 
  t0.id AS id_1, 
  t0.ordering AS ordering_2, 
  t0.subsection AS subsection_3, 
  t0.passage_id AS passage_id_4 
FROM 
  expositiontextunit t0 
WHERE 
  t0.passage_id = ? 
ORDER BY 
  t0.ordering ASC

SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.subsection AS subsection_3, t0.passage_id AS passage_id_4 FROM expositiontextunit t0 WHERE t0.passage_id = 48076 ORDER BY t0.ordering ASC;

SELECT 
  t0.id AS id_1, 
  t0.text AS text_2, 
  t0.textVector AS textvector_3, 
  t0.translation_id AS translation_id_4, 
  t0.placement_id AS placement_id_5 
FROM 
  expositiontranslationtext t0 
WHERE 
  t0.placement_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.textVector AS textvector_3, t0.translation_id AS translation_id_4, t0.placement_id AS placement_id_5 FROM expositiontranslationtext t0 WHERE t0.placement_id = 86674;

select 
  translationmethod_id 
from 
  expositiontranslation 
where 
  id = 70585

select translationmethod_id from expositiontranslation where id = 70585;

select 
  t2.id 
from 
  expositiontranslation t1, 
  expositiontranslation t2 
where 
  t1.id = 70585 
  and t1.work_id = t2.work_id 
  and t2.isoriginal 
order by 
  case when t2.language_id = 123 then 1 else 2 end

select t2.id from expositiontranslation t1, expositiontranslation t2 where t1.id = 70585 and t1.work_id = t2.work_id and t2.isoriginal order by case when t2.language_id = 123 then 1 else 2 end;

SELECT 
  array_to_string(
    array_agg(
      (
        CASE WHEN p.name is not null then p.name else (
          case when p.title is null then '' else p.title || ' ' end
        ) || (
          case when p.firstname is null then '' else p.firstname || ' ' end
        ) || (
          case when p.middlename is null then '' else p.middlename || ' ' end
        ) || (
          case when p.lastname is null then '' else p.lastname || ' ' end
        ) || (
          case when p.suffix is null then '' else p.suffix || ' ' end
        ) end
      )
    ), 
    ', '
  ) as authors 
FROM 
  translation_bibliographicdata tbg, 
  bibliographicdata_person bp, 
  person p 
WHERE 
  tbg.translation_id = 18620 
  and tbg.bibliographicdata_id = bp.bibliographicdata_id 
  and bp.person_id = p.id

SELECT array_to_string(array_agg( (CASE WHEN p.name is not null then p.name else (case when p.title is null then '' else p.title || ' ' end) || (case when p.firstname is null then '' else p.firstname || ' ' end) || (case when p.middlename is null then '' else p.middlename || ' ' end) || (case when p.lastname is null then '' else p.lastname || ' ' end) || (case when p.suffix is null then '' else p.suffix || ' ' end) end) ), ', ') as authors  FROM translation_bibliographicdata tbg, bibliographicdata_person bp, person p WHERE tbg.translation_id = 18620 and tbg.bibliographicdata_id = bp.bibliographicdata_id and bp.person_id = p.id;

select 
  (
    case when l.nativename is not null 
    and l.nativename <> '' then l.nativename else l.name end
  ) as language_name 
from 
  expositiontranslation t, 
  language l 
where 
  t.id = 70585 
  and l.id = t.language_id

select (case when l.nativename is not null and l.nativename <> '' then l.nativename else l.name end) as language_name from expositiontranslation t, language l where t.id = 70585 and l.id = t.language_id;

SELECT 
  c.url 
FROM 
  expositionwork w, 
  work_category wc, 
  concept_work cl, 
  expositiontranslation t, 
  concept c 
WHERE 
  w.id = 11146 
  and wc.work_id = w.id 
  and t.work_id = w.id 
  and cl.work_id = w.id 
  and c.id = cl.concept_id 
  and wc.category_id = 12

SELECT c.url FROM expositionwork w, work_category wc, concept_work cl, expositiontranslation t, concept c WHERE w.id = 11146 and wc.work_id = w.id and t.work_id = w.id and cl.work_id = w.id and c.id = cl.concept_id and wc.category_id = 12;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.description AS description_3, 
  t0.url AS url_4, 
  t0.indexPage AS indexpage_5 
FROM 
  expositioncategory t0 
  INNER JOIN work_category ON t0.id = work_category.category_id 
WHERE 
  work_category.work_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.url AS url_4, t0.indexPage AS indexpage_5 FROM expositioncategory t0 INNER JOIN work_category ON t0.id = work_category.category_id WHERE work_category.work_id = 11146;

SELECT 
  text_style_override 
FROM 
  language 
WHERE 
  id = 177

SELECT text_style_override  FROM language WHERE id = 177;

SELECT 
  t.name 
FROM 
  texttospeech t, 
  texttospeechlanguage tl 
WHERE 
  tl.language_id = 177 
  and t.id = tl.tts_id 
order by 
  tl.is_standard desc 
limit 
  1

SELECT t.name FROM texttospeech t, texttospeechlanguage tl WHERE tl.language_id = 177 and t.id = tl.tts_id order by tl.is_standard 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 = 11146 
  and p.division_id = d.id 
  and p.ordering < 1 
  and tt.translation_id = 70585 
  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 = 11146 and p.division_id = d.id and p.ordering < 1 and tt.translation_id=70585 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 = 11146 
  and p.division_id = d.id 
  and p.ordering > 1 
  and tt.translation_id = 70585 
  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 = 11146 and p.division_id = d.id and p.ordering > 1 and tt.translation_id=70585 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 
  t.name, 
  t.translatedtitle, 
  (
    case when b.datecreated is null then '' else ' (' || b.datecreated || ')' end
  ) as datestr, 
  w.title as work_title, 
  t.isoriginal, 
  t.language_id 
FROM 
  language l, 
  expositionwork w, 
  expositiontranslation t 
  left join (
    select 
      tb.translation_id, 
      b.datecreated 
    from 
      bibliographicdata b, 
      translation_bibliographicdata tb 
    where 
      b.id = tb.bibliographicdata_id
  ) as b on t.id = b.translation_id 
WHERE 
  t.id = 70585 
  and t.work_id = w.id 
  and t.language_id = l.id

SELECT t.name, t.translatedtitle, (case when b.datecreated is null then '' else ' (' || b.datecreated || ')' end) as datestr, w.title as work_title, t.isoriginal, t.language_id FROM language l, expositionwork w, expositiontranslation t left join (select tb.translation_id, b.datecreated from bibliographicdata b, translation_bibliographicdata tb where b.id = tb.bibliographicdata_id) as b on t.id = b.translation_id WHERE t.id = 70585 and t.work_id = w.id and t.language_id = l.id;

select 
  text 
from 
  ui_string_language 
where 
  ui_string_id = 469 
  and language_id = 177

select text from ui_string_language where ui_string_id = 469 and language_id = 177;

select 
  language_id 
from 
  expositiontranslation 
where 
  id = 70585

select language_id from expositiontranslation where id = 70585;

select 
  array_to_string(
    array_agg(DISTINCT d.ref_id), 
    ','
  ) as ref 
from 
  expositiontextunit t, 
  expositiontranslationtext tt, 
  expositiondisplayitem d 
where 
  t.passage_id = 48076 
  and tt.translation_id = 70585 
  and t.id = tt.placement_id 
  and d.container_id = tt.id 
  and d.type_id = 2

select array_to_string(array_agg(DISTINCT d.ref_id),',') as ref from expositiontextunit t, expositiontranslationtext tt, expositiondisplayitem d where t.passage_id = 48076 and tt.translation_id = 70585 and t.id = tt.placement_id and d.container_id = tt.id and d.type_id = 2;

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 = 177 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 = 48076 
          and t.id = tc.textunit_id 
          and rc.id = tc.combinedreference_id 
          and rc.id not in (
            1919, 2883, 2884, 4414, 4431, 4578, 4928, 
            5397, 7413, 8200, 8201, 8555, 12551, 
            13415, 13530, 16210, 24653, 25037, 
            28429, 32952, 32958, 33818, 37792, 
            65239, 65240, 65242, 65249, 65251, 
            65254, 65255, 65256, 108100, 135392, 
            136694, 147066, 147938, 147939, 147940
          ) 
          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 = 70585 then 1 else case when trans.language_id = 177 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 = 48076 
          and t.id = tc.textunit_id 
          and rc.id = tc.combinedreference_id 
          and rc.id not in (
            1919, 2883, 2884, 4414, 4431, 4578, 4928, 
            5397, 7413, 8200, 8201, 8555, 12551, 
            13415, 13530, 16210, 24653, 25037, 
            28429, 32952, 32958, 33818, 37792, 
            65239, 65240, 65242, 65249, 65251, 
            65254, 65255, 65256, 108100, 135392, 
            136694, 147066, 147938, 147939, 147940
          ) 
          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 = 177 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 = 48076 and t.id = tc.textunit_id and rc.id = tc.combinedreference_id  and rc.id not in (1919,2883,2884,4414,4431,4578,4928,5397,7413,8200,8201,8555,12551,13415,13530,16210,24653,25037,28429,32952,32958,33818,37792,65239,65240,65242,65249,65251,65254,65255,65256,108100,135392,136694,147066,147938,147939,147940) 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 = 70585 then 1 else case when trans.language_id = 177 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 = 48076 and t.id = tc.textunit_id and rc.id = tc.combinedreference_id  and rc.id not in (1919,2883,2884,4414,4431,4578,4928,5397,7413,8200,8201,8555,12551,13415,13530,16210,24653,25037,28429,32952,32958,33818,37792,65239,65240,65242,65249,65251,65254,65255,65256,108100,135392,136694,147066,147938,147939,147940) 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 
  di1.text as footnote, 
  array_to_string(
    array_agg(
      di3.text 
      order by 
        di3.ordering
    ), 
    ' '
  ) as footnote_text 
from 
  expositiondisplayitem di1, 
  (
    select 
      di2.* 
    from 
      expositiondisplayitem di2, 
      expositiontranslationtext tt, 
      expositiontextunit tu 
    where 
      tu.passage_id = 48076 
      and tt.translation_id = 70585 
      and tu.id = tt.placement_id 
      and di2.container_id = tt.id 
    order by 
      di2.ordering
  ) as di3 
where 
  di3.containingitem_id = di1.id 
group by 
  di1.text

select di1.text as footnote, array_to_string(array_agg(di3.text order by di3.ordering),' ') as footnote_text from expositiondisplayitem di1, (select di2.* from expositiondisplayitem di2, expositiontranslationtext tt, expositiontextunit tu where tu.passage_id = 48076 and tt.translation_id = 70585 and tu.id = tt.placement_id and di2.container_id = tt.id order by di2.ordering) as di3 where di3.containingitem_id = di1.id group by di1.text;