Symfony Profiler

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

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

SELECT 
  max(sl.datemod) 
FROM 
  ui_string_language sl, 
  ui_string s 
WHERE 
  sl.language_id in (246, 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 (246, 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 = 246 
      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 = 246 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 
  language_id 
from 
  bibletranslation 
where 
  url = 'greek-tischendorf'

select language_id from bibletranslation where url = 'greek-tischendorf';

SELECT 
  t0.id AS id_1, 
  t0.languageDefault AS languagedefault_2, 
  t0.name AS name_3, 
  t0.abbreviation AS abbreviation_4, 
  t0.copyright AS copyright_5, 
  t0.notice AS notice_6, 
  t0.license AS license_7, 
  t0.url AS url_8, 
  t0.enabled AS enabled_9, 
  t0.language_id AS language_id_10 
FROM 
  bibletranslation t0 
WHERE 
  t0.url = ? 
  AND t0.enabled = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.languageDefault AS languagedefault_2, t0.name AS name_3, t0.abbreviation AS abbreviation_4, t0.copyright AS copyright_5, t0.notice AS notice_6, t0.license AS license_7, t0.url AS url_8, t0.enabled AS enabled_9, t0.language_id AS language_id_10 FROM bibletranslation t0 WHERE t0.url = 'greek-tischendorf' AND t0.enabled = 1 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.siteDefault AS sitedefault_2, 
  t0.name AS name_3, 
  t0.frenchName AS frenchname_4, 
  t0.nativeName AS nativename_5, 
  t0.bibliographicCode AS bibliographiccode_6, 
  t0.terminologicCode AS terminologiccode_7, 
  t0.shortCode AS shortcode_8, 
  t0.rightToLeft AS righttoleft_9, 
  t0.searchLibrary AS searchlibrary_10 
FROM 
  language t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.siteDefault AS sitedefault_2, t0.name AS name_3, t0.frenchName AS frenchname_4, t0.nativeName AS nativename_5, t0.bibliographicCode AS bibliographiccode_6, t0.terminologicCode AS terminologiccode_7, t0.shortCode AS shortcode_8, t0.rightToLeft AS righttoleft_9, t0.searchLibrary AS searchlibrary_10 FROM language t0 WHERE t0.id = 163;

SELECT 
  b0_.id AS id_0, 
  b0_.ordering AS ordering_1, 
  b0_.name AS name_2, 
  b0_.url AS url_3, 
  b1_.id AS id_4, 
  b1_.languageDefault AS languagedefault_5, 
  b1_.name AS name_6, 
  b1_.abbreviation AS abbreviation_7, 
  b1_.copyright AS copyright_8, 
  b1_.notice AS notice_9, 
  b1_.license AS license_10, 
  b1_.url AS url_11, 
  b1_.enabled AS enabled_12, 
  c2_.id AS id_13, 
  c2_.ordering AS ordering_14, 
  c2_.name AS name_15, 
  c2_.url AS url_16, 
  c2_.apocryphal AS apocryphal_17, 
  c2_.deuterocanonical AS deuterocanonical_18, 
  b0_.translation_id AS translation_id_19, 
  b0_.canonicalization_id AS canonicalization_id_20, 
  b1_.language_id AS language_id_21, 
  c2_.testament_id AS testament_id_22 
FROM 
  biblebook b0_ 
  INNER JOIN bibletranslation b1_ ON b0_.translation_id = b1_.id 
  INNER JOIN canonicalbiblebook c2_ ON b0_.canonicalization_id = c2_.id 
  INNER JOIN language l3_ ON b1_.language_id = l3_.id 
WHERE 
  c2_.url = ? 
  AND b0_.translation_id = ? 
ORDER BY 
  b0_.ordering ASC

SELECT b0_.id AS id_0, b0_.ordering AS ordering_1, b0_.name AS name_2, b0_.url AS url_3, b1_.id AS id_4, b1_.languageDefault AS languagedefault_5, b1_.name AS name_6, b1_.abbreviation AS abbreviation_7, b1_.copyright AS copyright_8, b1_.notice AS notice_9, b1_.license AS license_10, b1_.url AS url_11, b1_.enabled AS enabled_12, c2_.id AS id_13, c2_.ordering AS ordering_14, c2_.name AS name_15, c2_.url AS url_16, c2_.apocryphal AS apocryphal_17, c2_.deuterocanonical AS deuterocanonical_18, b0_.translation_id AS translation_id_19, b0_.canonicalization_id AS canonicalization_id_20, b1_.language_id AS language_id_21, c2_.testament_id AS testament_id_22 FROM biblebook b0_ INNER JOIN bibletranslation b1_ ON b0_.translation_id = b1_.id INNER JOIN canonicalbiblebook c2_ ON b0_.canonicalization_id = c2_.id INNER JOIN language l3_ ON b1_.language_id = l3_.id WHERE c2_.url = 'hebrews' AND b0_.translation_id = 126 ORDER BY b0_.ordering ASC;

SELECT 
  t0.id AS id_1, 
  t0.ordering AS ordering_2, 
  t0.book_id AS book_id_3 
FROM 
  biblechapter t0 
WHERE 
  t0.book_id = ? 
  AND t0.ordering = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.book_id AS book_id_3 FROM biblechapter t0 WHERE t0.book_id = 6395 AND t0.ordering = '11' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.ordering AS ordering_2, 
  t0.name AS name_3, 
  t0.url AS url_4, 
  t0.apocryphal AS apocryphal_5, 
  t0.deuterocanonical AS deuterocanonical_6, 
  t0.testament_id AS testament_id_7 
FROM 
  canonicalbiblebook t0 
WHERE 
  t0.url = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.name AS name_3, t0.url AS url_4, t0.apocryphal AS apocryphal_5, t0.deuterocanonical AS deuterocanonical_6, t0.testament_id AS testament_id_7 FROM canonicalbiblebook t0 WHERE t0.url = 'hebrews' LIMIT 1;

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.chapter_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.chapter_id = 111242 ORDER BY t0.ordering ASC;

SELECT 
  t0.id AS id_1, 
  t0.languageDefault AS languagedefault_2, 
  t0.name AS name_3, 
  t0.abbreviation AS abbreviation_4, 
  t0.copyright AS copyright_5, 
  t0.notice AS notice_6, 
  t0.license AS license_7, 
  t0.url AS url_8, 
  t0.enabled AS enabled_9, 
  t0.language_id AS language_id_10 
FROM 
  bibletranslation t0 
WHERE 
  t0.url = ? 
  AND t0.enabled = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.languageDefault AS languagedefault_2, t0.name AS name_3, t0.abbreviation AS abbreviation_4, t0.copyright AS copyright_5, t0.notice AS notice_6, t0.license AS license_7, t0.url AS url_8, t0.enabled AS enabled_9, t0.language_id AS language_id_10 FROM bibletranslation t0 WHERE t0.url = 'greek-tischendorf' AND t0.enabled = 1 LIMIT 1;

select 
  show_bible_chapter_summary 
from 
  language 
where 
  id = 163

select show_bible_chapter_summary from language where id = 163;

SELECT 
  t0.id AS id_1, 
  t0.ordering AS ordering_2, 
  t0.book_id AS book_id_3 
FROM 
  canonicalbiblechapter t0 
WHERE 
  t0.book_id = ? 
ORDER BY 
  t0.ordering ASC

SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.book_id AS book_id_3 FROM canonicalbiblechapter t0 WHERE t0.book_id = 78 ORDER BY t0.ordering ASC;

select 
  id 
from 
  language 
where 
  shortcode = 'la'

select id from language where shortcode = 'la';

select 
  language_id 
from 
  bibletranslation 
where 
  url = 'greek-tischendorf'

select language_id from bibletranslation where url = 'greek-tischendorf';

select 
  show_bible_chapter_summary 
from 
  language 
where 
  id = 163

select show_bible_chapter_summary from language where id = 163;

SELECT 
  bs.chapter_id, 
  t.id as translation_id, 
  t.url, 
  t.is_modern, 
  t.translatedtitle as explanationtitle, 
  case when t.language_id = 163 then 2 else case when t.language_id = 246 then 3 else case when t.language_id = 123 then 5 else 6 end end end as lang_order 
FROM 
  expositionwork w, 
  expositiontranslation t, 
  expositiontranslationtext tt, 
  story_work sw, 
  biblestory bs 
WHERE 
  bs.chapter_id = 975 
  and sw.story_id = bs.id 
  and w.id = sw.work_id 
  and t.work_id = w.id 
  and t.id = tt.translation_id 
  and tt.text is not null 
  and tt.text <> '' 
  and (
    t.language_id in (163, 246, 123)
  ) 
  and w.ispublic 
  AND t.ispublic 
order by 
  lang_order, 
  t.is_modern desc, 
  t.islanguagedefault desc 
limit 
  1

SELECT bs.chapter_id, t.id as translation_id, t.url, t.is_modern, t.translatedtitle as explanationtitle, case when t.language_id = 163 then 2 else case when t.language_id = 246 then 3 else case when t.language_id = 123 then 5 else 6 end  end  end as lang_order FROM expositionwork w, expositiontranslation t, expositiontranslationtext tt, story_work sw, biblestory bs WHERE bs.chapter_id = 975 and sw.story_id = bs.id and w.id = sw.work_id and t.work_id=w.id and t.id = tt.translation_id and tt.text is not null and tt.text <> '' and (t.language_id in (163,246,123)) and w.ispublic AND t.ispublic order by lang_order, t.is_modern desc, t.islanguagedefault desc limit 1;

SELECT 
  b.id, 
  b.name, 
  cb.id as canonical_id, 
  cb.url as canonical_book_url, 
  case when cb.testament_id = 1 then 'Vetus Testamentum' else case when cb.testament_id = 2 then 'Novum Testamentum' else case when cb.testament_id = 3 then 'Apocrypha' end end end as testament_name, 
  t.url as translation_url, 
  min(c.ordering) as first_chapter_order, 
  cb.testament_id 
FROM 
  biblebook b, 
  biblechapter c, 
  canonicalbiblebook cb, 
  bibletranslation t 
WHERE 
  b.translation_id = 126 
  and b.canonicalization_id = cb.id 
  and t.id = b.translation_id 
  and c.book_id = b.id 
group by 
  b.id, 
  b.name, 
  cb.id, 
  cb.url, 
  testament_name, 
  t.url 
order by 
  cb.testament_id, 
  cb.id

SELECT b.id, b.name, cb.id as canonical_id, cb.url as canonical_book_url, case when cb.testament_id = 1 then 'Vetus Testamentum' else case when cb.testament_id = 2 then 'Novum Testamentum' else case when cb.testament_id = 3 then 'Apocrypha' end end end as testament_name, t.url as translation_url, min(c.ordering) as first_chapter_order, cb.testament_id FROM biblebook b, biblechapter c, canonicalbiblebook cb, bibletranslation t WHERE b.translation_id = 126 and b.canonicalization_id = cb.id and t.id = b.translation_id and c.book_id = b.id group by b.id, b.name, cb.id, cb.url, testament_name, t.url order by cb.testament_id, cb.id;

SELECT 
  c.id, 
  t.url as translation_url, 
  cb.url as book_url, 
  c.ordering as chapter_order, 
  'bible' || '_' || t.url || '_' || cb.url || '_' || c.ordering as chapter_multi_spec, 
  b.name as book_name 
FROM 
  bibletranslation t, 
  biblebook b, 
  biblechapter c, 
  canonicalbiblebook cb 
WHERE 
  c.book_id in (
    select 
      book_id 
    from 
      biblechapter 
    where 
      id = 111242
  ) 
  and c.ordering > (
    select 
      ordering 
    from 
      biblechapter 
    where 
      id = 111242
  ) 
  and c.book_id = b.id 
  and b.canonicalization_id = cb.id 
  and b.translation_id = t.id 
order by 
  c.ordering 
limit 
  1

SELECT c.id, t.url as translation_url, cb.url as book_url, c.ordering as chapter_order, 'bible' || '_' || t.url || '_' || cb.url  || '_' || c.ordering as chapter_multi_spec, b.name as book_name FROM bibletranslation t, biblebook b, biblechapter c, canonicalbiblebook cb WHERE c.book_id in (select book_id from biblechapter where id = 111242) and c.ordering > (select ordering from biblechapter where id = 111242) and c.book_id = b.id and b.canonicalization_id = cb.id and b.translation_id = t.id order by c.ordering limit 1;

SELECT 
  c.id, 
  t.url as translation_url, 
  cb.url as book_url, 
  c.ordering as chapter_order, 
  'bible' || '_' || t.url || '_' || cb.url || '_' || c.ordering as chapter_multi_spec, 
  b.name as book_name 
FROM 
  bibletranslation t, 
  biblebook b, 
  biblechapter c, 
  canonicalbiblebook cb 
WHERE 
  c.book_id in (
    select 
      book_id 
    from 
      biblechapter 
    where 
      id = 111242
  ) 
  and c.ordering < (
    select 
      ordering 
    from 
      biblechapter 
    where 
      id = 111242
  ) 
  and c.book_id = b.id 
  and b.canonicalization_id = cb.id 
  and b.translation_id = t.id 
order by 
  c.ordering desc 
limit 
  1

SELECT c.id, t.url as translation_url, cb.url as book_url, c.ordering as chapter_order, 'bible' || '_' || t.url || '_' || cb.url  || '_' || c.ordering as chapter_multi_spec, b.name as book_name FROM bibletranslation t, biblebook b, biblechapter c, canonicalbiblebook cb WHERE c.book_id in (select book_id from biblechapter where id = 111242) and c.ordering < (select ordering from biblechapter where id = 111242) and c.book_id = b.id and b.canonicalization_id = cb.id and b.translation_id = t.id order by c.ordering desc limit 1;

SELECT 
  credit 
from 
  bibletranslation 
WHERE 
  url = 'greek-tischendorf'

SELECT credit from bibletranslation WHERE url = 'greek-tischendorf';

select 
  t.language_id, 
  l.bibliographiccode, 
  c.book_id, 
  b.translation_id, 
  v.chapter_id 
from 
  bibleverse v, 
  biblechapter c, 
  biblebook b, 
  bibletranslation t, 
  language l 
where 
  v.id = 2944137 
  and v.chapter_id = c.id 
  and c.book_id = b.id 
  and b.translation_id = t.id 
  and t.language_id = l.id

select t.language_id, l.bibliographiccode, c.book_id, b.translation_id, v.chapter_id from bibleverse v, biblechapter c, biblebook b, bibletranslation t, language l where v.id = 2944137 and v.chapter_id = c.id and c.book_id = b.id and b.translation_id = t.id and t.language_id = l.id;

select 
  string_agg(distinct cv.id :: text, ',') as cverse_ids, 
  string_agg(distinct cc.id :: text, ',') as cchapter_ids, 
  string_agg(
    distinct cc.ordering :: text, 
    ',' 
    order by 
      cc.ordering :: text
  ) as cchapter_orders 
from 
  canonicalbibleverse cv, 
  canonicalbiblechapter cc, 
  canonicalbiblebook cb, 
  bibleverse v, 
  (
    select 
      * 
    from 
      canonicalbibleverse_bibleverse 
    where 
      bibleverse_id in (
        2944137, 2944136, 2944135, 2944134, 
        2944133, 2944132, 2944131, 2944130, 
        2944129, 2944128, 2944127, 2944126, 
        2944125, 2944124, 2944123, 2944122, 
        2944121, 2944120, 2944119, 2944118, 
        2944117, 2944116, 2944115, 2944114, 
        2944113, 2944112, 2944111, 2944110, 
        2944109, 2944108, 2944107, 2944106, 
        2944105, 2944104, 2944103, 2944102, 
        2944101, 2944100, 2944099, 2944098
      )
  ) as cvv 
where 
  v.id in (
    2944137, 2944136, 2944135, 2944134, 
    2944133, 2944132, 2944131, 2944130, 
    2944129, 2944128, 2944127, 2944126, 
    2944125, 2944124, 2944123, 2944122, 
    2944121, 2944120, 2944119, 2944118, 
    2944117, 2944116, 2944115, 2944114, 
    2944113, 2944112, 2944111, 2944110, 
    2944109, 2944108, 2944107, 2944106, 
    2944105, 2944104, 2944103, 2944102, 
    2944101, 2944100, 2944099, 2944098
  ) 
  and v.id = cvv.bibleverse_id 
  and cv.id = cvv.canonicalbibleverse_id 
  and cv.chapter_id = cc.id

select string_agg(distinct cv.id::text, ',') as cverse_ids, string_agg(distinct cc.id::text, ',') as cchapter_ids, string_agg(distinct cc.ordering::text, ',' order by cc.ordering::text) as cchapter_orders from canonicalbibleverse cv, canonicalbiblechapter cc, canonicalbiblebook cb, bibleverse v, (select * from canonicalbibleverse_bibleverse where bibleverse_id in (2944137,2944136,2944135,2944134,2944133,2944132,2944131,2944130,2944129,2944128,2944127,2944126,2944125,2944124,2944123,2944122,2944121,2944120,2944119,2944118,2944117,2944116,2944115,2944114,2944113,2944112,2944111,2944110,2944109,2944108,2944107,2944106,2944105,2944104,2944103,2944102,2944101,2944100,2944099,2944098)) as cvv where v.id in (2944137,2944136,2944135,2944134,2944133,2944132,2944131,2944130,2944129,2944128,2944127,2944126,2944125,2944124,2944123,2944122,2944121,2944120,2944119,2944118,2944117,2944116,2944115,2944114,2944113,2944112,2944111,2944110,2944109,2944108,2944107,2944106,2944105,2944104,2944103,2944102,2944101,2944100,2944099,2944098) and v.id = cvv.bibleverse_id and cv.id = cvv.canonicalbibleverse_id and cv.chapter_id = cc.id;

select 
  array_to_string(
    array_agg(distinct chapter_id), 
    ','
  ) 
from 
  canonicalbibleverse 
where 
  id in (
    24040, 24041, 24042, 24043, 24044, 24045, 
    24046, 24047, 24048, 24049, 24050, 
    24051, 24052, 24053, 24054, 24055, 
    24056, 24057, 24058, 24059, 24060, 
    24061, 24062, 24063, 24064, 24065, 
    24066, 24067, 24068, 24069, 24070, 
    24071, 24072, 24073, 24074, 24075, 
    24076, 24077, 24078, 24079
  )

select array_to_string(array_agg(distinct chapter_id), ',') from canonicalbibleverse where id in (24040,24041,24042,24043,24044,24045,24046,24047,24048,24049,24050,24051,24052,24053,24054,24055,24056,24057,24058,24059,24060,24061,24062,24063,24064,24065,24066,24067,24068,24069,24070,24071,24072,24073,24074,24075,24076,24077,24078,24079);

select 
  array_to_string(
    array_agg(id), 
    ','
  ) 
from 
  canonicalbiblechapter 
where 
  id in (975) 
  and id not in (
    select 
      distinct chapter_id 
    from 
      canonicalbibleverse 
    where 
      chapter_id in (975) 
      and id not in (
        24040, 24041, 24042, 24043, 24044, 24045, 
        24046, 24047, 24048, 24049, 24050, 
        24051, 24052, 24053, 24054, 24055, 
        24056, 24057, 24058, 24059, 24060, 
        24061, 24062, 24063, 24064, 24065, 
        24066, 24067, 24068, 24069, 24070, 
        24071, 24072, 24073, 24074, 24075, 
        24076, 24077, 24078, 24079
      )
  )

select array_to_string(array_agg(id), ',') from canonicalbiblechapter where id in (975) and id not in (select distinct chapter_id from canonicalbibleverse where chapter_id in (975) and id not in (24040,24041,24042,24043,24044,24045,24046,24047,24048,24049,24050,24051,24052,24053,24054,24055,24056,24057,24058,24059,24060,24061,24062,24063,24064,24065,24066,24067,24068,24069,24070,24071,24072,24073,24074,24075,24076,24077,24078,24079));

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 = 163 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 (
            24040, 24041, 24042, 24043, 24044, 24045, 
            24046, 24047, 24048, 24049, 24050, 
            24051, 24052, 24053, 24054, 24055, 
            24056, 24057, 24058, 24059, 24060, 
            24061, 24062, 24063, 24064, 24065, 
            24066, 24067, 24068, 24069, 24070, 
            24071, 24072, 24073, 24074, 24075, 
            24076, 24077, 24078, 24079
          )
      ) 
      and p.id not in (
        SELECT 
          DISTINCT passage_id 
        FROM 
          chapter_passage 
        WHERE 
          chapter_id in (975, 975) 
        union 
        SELECT 
          DISTINCT passage_id 
        FROM 
          verse_passage 
        WHERE 
          verse_id in (
            24040, 24041, 24042, 24043, 24044, 24045, 
            24046, 24047, 24048, 24049, 24050, 
            24051, 24052, 24053, 24054, 24055, 
            24056, 24057, 24058, 24059, 24060, 
            24061, 24062, 24063, 24064, 24065, 
            24066, 24067, 24068, 24069, 24070, 
            24071, 24072, 24073, 24074, 24075, 
            24076, 24077, 24078, 24079
          ) 
          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 (
                24040, 24041, 24042, 24043, 24044, 24045, 
                24046, 24047, 24048, 24049, 24050, 
                24051, 24052, 24053, 24054, 24055, 
                24056, 24057, 24058, 24059, 24060, 
                24061, 24062, 24063, 24064, 24065, 
                24066, 24067, 24068, 24069, 24070, 
                24071, 24072, 24073, 24074, 24075, 
                24076, 24077, 24078, 24079
              )
          ) 
          and p.id not in (
            SELECT 
              DISTINCT passage_id 
            FROM 
              chapter_passage 
            WHERE 
              chapter_id in (975, 975) 
            union 
            SELECT 
              DISTINCT passage_id 
            FROM 
              verse_passage 
            WHERE 
              verse_id in (
                24040, 24041, 24042, 24043, 24044, 24045, 
                24046, 24047, 24048, 24049, 24050, 
                24051, 24052, 24053, 24054, 24055, 
                24056, 24057, 24058, 24059, 24060, 
                24061, 24062, 24063, 24064, 24065, 
                24066, 24067, 24068, 24069, 24070, 
                24071, 24072, 24073, 24074, 24075, 
                24076, 24077, 24078, 24079
              ) 
              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 (163, 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

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 = 163 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 (24040,24041,24042,24043,24044,24045,24046,24047,24048,24049,24050,24051,24052,24053,24054,24055,24056,24057,24058,24059,24060,24061,24062,24063,24064,24065,24066,24067,24068,24069,24070,24071,24072,24073,24074,24075,24076,24077,24078,24079)) and p.id not  in (SELECT DISTINCT passage_id FROM chapter_passage WHERE chapter_id in (975,975) union SELECT DISTINCT passage_id FROM verse_passage WHERE  verse_id in (24040,24041,24042,24043,24044,24045,24046,24047,24048,24049,24050,24051,24052,24053,24054,24055,24056,24057,24058,24059,24060,24061,24062,24063,24064,24065,24066,24067,24068,24069,24070,24071,24072,24073,24074,24075,24076,24077,24078,24079) 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 (24040,24041,24042,24043,24044,24045,24046,24047,24048,24049,24050,24051,24052,24053,24054,24055,24056,24057,24058,24059,24060,24061,24062,24063,24064,24065,24066,24067,24068,24069,24070,24071,24072,24073,24074,24075,24076,24077,24078,24079)) and p.id not  in (SELECT DISTINCT passage_id FROM chapter_passage WHERE chapter_id in (975,975) union SELECT DISTINCT passage_id FROM verse_passage WHERE  verse_id in (24040,24041,24042,24043,24044,24045,24046,24047,24048,24049,24050,24051,24052,24053,24054,24055,24056,24057,24058,24059,24060,24061,24062,24063,24064,24065,24066,24067,24068,24069,24070,24071,24072,24073,24074,24075,24076,24077,24078,24079) 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 ( 163,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;