Symfony Profiler

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

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

SELECT 
  max(sl.datemod) 
FROM 
  ui_string_language sl, 
  ui_string s 
WHERE 
  sl.language_id in (348, 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 (348, 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 = 348 
      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 = 348 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 = 'white-horse-in-book-of-revelation-japanese' AND t0.isPublic = 1 AND t0.type_id = 1 LIMIT 1;

select 
  t.id 
from 
  expositiontranslation t 
WHERE 
  t.url = 'white-horse-in-book-of-revelation-japanese' 
  and (
    t.ispublic 
    and not t.restricted_access
  )

select t.id from expositiontranslation t WHERE t.url = 'white-horse-in-book-of-revelation-japanese' and  (t.ispublic and not t.restricted_access) ;

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 = 46;

SELECT 
  e0_.id AS id_0, 
  e0_.ordering AS ordering_1, 
  e0_.title AS title_2, 
  e0_.swedenborgSection AS swedenborgsection_3, 
  e0_.division_id AS division_id_4 
FROM 
  expositionpassage e0_, 
  expositiondivision e1_, 
  expositionwork e2_ 
WHERE 
  e0_.swedenborgSection = ? 
  AND e0_.division_id = e1_.id 
  AND e1_.work_id = e2_.id 
  AND e2_.id = ? 
  AND e2_.isPublic = true

SELECT e0_.id AS id_0, e0_.ordering AS ordering_1, e0_.title AS title_2, e0_.swedenborgSection AS swedenborgsection_3, e0_.division_id AS division_id_4 FROM expositionpassage e0_, expositiondivision e1_, expositionwork e2_ WHERE e0_.swedenborgSection = '2' AND e0_.division_id = e1_.id AND e1_.work_id = e2_.id AND e2_.id = 46 AND e2_.isPublic = true;

SELECT 
  text_style_override 
FROM 
  language 
WHERE 
  id = 205

SELECT text_style_override  FROM language WHERE id = 205;

SELECT 
  credit, 
  sourcelink 
from 
  bibliographicdata b, 
  translation_bibliographicdata tb 
WHERE 
  tb.translation_id = 19428 
  and tb.bibliographicdata_id = b.id 
  and sourcelink is not null 
  and credit is not null

SELECT credit, sourcelink from bibliographicdata b, translation_bibliographicdata tb WHERE tb.translation_id = 19428 and tb.bibliographicdata_id = b.id and sourcelink is not null and credit is not null;

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.id = ?

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.id = 13;

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 = 46 
  and p.division_id = d.id 
  and p.ordering < 20 
  and tt.translation_id = 19428 
  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 = 46 and p.division_id = d.id and p.ordering < 20 and tt.translation_id=19428 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 = 46 
  and p.division_id = d.id 
  and p.ordering > 20 
  and tt.translation_id = 19428 
  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 = 46 and p.division_id = d.id and p.ordering > 20 and tt.translation_id=19428 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 = 19428 
  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 = 19428 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 = 205

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

SELECT 
  'bible_' || t.url || '_' || cb.url || '_' || cc.ordering as link_spec, 
  (
    case when t.language_id in (
      select 
        language_id 
      from 
        expositiontranslation 
      where 
        id = 19428
    ) then 2 else case when t.language_id = 123 then 3 else 4 end end
  ) as priority_order, 
  cb.url as book_url, 
  t.url as trans_url, 
  cc.ordering as chapter_order 
FROM 
  canonicalbibleverse cv, 
  canonicalbiblechapter cc, 
  canonicalbiblebook cb, 
  biblebook b, 
  bibletranslation t 
WHERE 
  (
    cv.id in (
      select 
        verse_id 
      from 
        verse_passage 
      where 
        passage_id = 10700 
        and iscorepassage
    ) 
    or cc.id in (
      select 
        chapter_id 
      from 
        chapter_passage 
      where 
        passage_id = 10700
    )
  ) 
  and cv.chapter_id = cc.id 
  and cc.book_id = cb.id 
  and b.canonicalization_id = cb.id 
  and b.translation_id = t.id 
  and (
    t.enabled 
    and not t.restricted_access
  ) 
order by 
  priority_order asc, 
  t.languagedefault desc 
limit 
  1

SELECT 'bible_' || t.url || '_' || cb.url || '_' || cc.ordering as link_spec, (case when t.language_id in (select language_id from expositiontranslation where id = 19428) then 2 else case when t.language_id = 123 then 3 else 4 end end) as priority_order, cb.url as book_url, t.url as trans_url, cc.ordering as chapter_order  FROM canonicalbibleverse cv, canonicalbiblechapter cc, canonicalbiblebook cb, biblebook b, bibletranslation t WHERE (cv.id in (select verse_id from verse_passage where passage_id = 10700 and iscorepassage) or cc.id in (select chapter_id from chapter_passage where passage_id = 10700) ) and cv.chapter_id = cc.id and cc.book_id = cb.id and b.canonicalization_id = cb.id and b.translation_id = t.id and  (t.enabled and not t.restricted_access)  order by priority_order asc, t.languagedefault desc limit 1;

select 
  di1.text as footnote, 
  array_to_string(
    array_agg(
      di3.text 
      order by 
        di3.tu_order, 
        di3.ordering
    ), 
    ' '
  ) as footnote_text 
from 
  expositiondisplayitem di1, 
  (
    select 
      di2.text, 
      di2.ordering, 
      di2.containingitem_id, 
      tu.ordering as tu_order 
    from 
      expositiondisplayitem di2, 
      expositiontranslationtext tt, 
      expositiontextunit tu 
    where 
      tu.passage_id = 10700 
      and tt.translation_id = 19428 
      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.tu_order, di3.ordering),' ') as footnote_text from expositiondisplayitem di1, (select di2.text, di2.ordering, di2.containingitem_id, tu.ordering as tu_order from expositiondisplayitem di2, expositiontranslationtext tt, expositiontextunit tu where tu.passage_id = 10700 and tt.translation_id = 19428 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 
  * 
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 = 19428
        ) 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 = 10700 
      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 = 19428 then 1 else case when t.language_id in (
          select 
            language_id 
          from 
            expositiontranslation 
          where 
            id = 19428
        ) 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 = 10700 
      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 = 19428) 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 = 10700 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 = 19428 then 1 else case when t.language_id in (select language_id from expositiontranslation where id = 19428) 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 = 10700 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 
  tt.toc_text, 
  wt.startpassage_id, 
  p.swedenborgsection as startpassagenum, 
  p2.swedenborgsection as endpassagenum, 
  t.url as translation_url, 
  d.url as division_url, 
  p.ordering as startpassageorder, 
  p2.ordering as endpassageorder, 
  (
    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 link_spec 
from 
  expositiontranslationtoc tt, 
  expositionwork w, 
  expositiontranslation t, 
  expositiondivision d, 
  expositionpassage p, 
  expositionworktoc wt 
  left join expositionpassage p2 on wt.endpassage_id = p2.id 
where 
  tt.translation_id = 19428 
  and tt.worktoc_id = wt.id 
  and wt.startpassage_id = p.id 
  and tt.translation_id = t.id 
  and p.division_id = d.id 
  and t.work_id = w.id 
order by 
  p.ordering 
limit 
  1

select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (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 link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 19428 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering limit 1;

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 = 10700 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 = 10700;

select 
  tt.toc_text, 
  wt.startpassage_id, 
  p.swedenborgsection as startpassagenum, 
  p2.swedenborgsection as endpassagenum, 
  t.url as translation_url, 
  d.url as division_url, 
  p.ordering as startpassageorder, 
  p2.ordering as endpassageorder, 
  (
    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 link_spec 
from 
  expositiontranslationtoc tt, 
  expositionwork w, 
  expositiontranslation t, 
  expositiondivision d, 
  expositionpassage p, 
  expositionworktoc wt 
  left join expositionpassage p2 on wt.endpassage_id = p2.id 
where 
  tt.translation_id = 19428 
  and tt.worktoc_id = wt.id 
  and wt.startpassage_id = p.id 
  and tt.translation_id = t.id 
  and p.division_id = d.id 
  and t.work_id = w.id 
order by 
  p.ordering 
limit 
  1

select tt.toc_text, wt.startpassage_id, p.swedenborgsection as startpassagenum, p2.swedenborgsection as endpassagenum, t.url as translation_url, d.url as division_url, p.ordering as startpassageorder, p2.ordering as endpassageorder, (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 link_spec from expositiontranslationtoc tt, expositionwork w, expositiontranslation t, expositiondivision d, expositionpassage p, expositionworktoc wt left join expositionpassage p2 on wt.endpassage_id = p2.id where tt.translation_id = 19428 and tt.worktoc_id = wt.id and wt.startpassage_id = p.id and tt.translation_id = t.id and p.division_id = d.id and t.work_id = w.id order by p.ordering 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 = ? 
  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 = 'arcana-coelestia-japanese' AND t0.isPublic = 1 AND t0.type_id = 1 LIMIT 1;

select 
  t.id 
from 
  expositiontranslation t 
WHERE 
  t.url = 'arcana-coelestia-japanese' 
  and (
    t.ispublic 
    and not t.restricted_access
  )

select t.id from expositiontranslation t WHERE t.url = 'arcana-coelestia-japanese' and  (t.ispublic and not t.restricted_access) ;

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 = ?