Symfony Profiler

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

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

SELECT
  MAX(sl.datemod)
FROM
  ui_string_language sl
  JOIN ui_string s ON s.id = sl.ui_string_id
WHERE
  sl.language_id IN (268, 123)
  AND s.is_active
  AND s.type_id IN (1, 3)

SELECT MAX(sl.datemod)
				FROM ui_string_language sl
				JOIN ui_string s ON s.id = sl.ui_string_id
				WHERE sl.language_id IN (268, 123)
				AND s.is_active AND s.type_id IN (1, 3);

select
  t.id
from
  expositiontranslation t
WHERE
  t.url = 'tcr-jp'
  and (
    t.ispublic
    and not t.restricted_access
  )

select t.id from expositiontranslation t WHERE t.url = 'tcr-jp' and  (t.ispublic and not t.restricted_access) ;

SELECT
  t.id
FROM
  expositionwork w,
  expositiontranslation t
where
  t.url = 'tcr-jp'
  and w.id = t.work_id
  and w.swedenborgtype is not null

SELECT t.id FROM expositionwork w, expositiontranslation t where t.url = 'tcr-jp' and w.id = t.work_id and w.swedenborgtype is not null;

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 = ?
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 = 'tcr-jp' AND t0.ispublic = 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 = 205;

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

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 = ?
  AND t0.url = ?
LIMIT
  1

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 = 45 AND t0.url = 'contents' LIMIT 1;

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 = ?
  AND t0.ordering = ?
LIMIT
  1

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 = 14 AND t0.ordering = '0' LIMIT 1;

select
  case when w.swedenborgtype is null then
    false
  else
    true
  end as sw
from
  expositionwork w,
  expositiontranslation t
where
  t.id = 64323
  and t.work_id = w.id

select case when w.swedenborgtype is null then false else true end as sw from expositionwork w, expositiontranslation t where t.id = 64323 and t.work_id = w.id;

SELECT
  text_style_override
FROM
  language
WHERE
  id = 205

SELECT text_style_override  FROM language WHERE 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 = 64323
    ) 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 = 2246
        and iscorepassage
    )
    or cc.id in (
      select
        chapter_id
      from
        chapter_passage
      where
        passage_id = 2246
    )
  )
  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 = 64323) 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 = 2246 and iscorepassage) or cc.id in (select chapter_id from chapter_passage where passage_id = 2246) ) 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 = 2246
      and tt.translation_id = 64323
      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 = 2246 and tt.translation_id = 64323 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 = 64323
        ) 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 = 2246
      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 = 64323 then
          1
        else
          case when t.language_id in (
            select
              language_id
            from
              expositiontranslation
            where
              id = 64323
          ) 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 = 2246
      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 = 64323) 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 = 2246 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 = 64323 then 1 else case when t.language_id in (select language_id from expositiontranslation where id = 64323) 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 = 2246 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 = 64323
  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 = 64323 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 = 2246 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 = 2246;

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 = 64323
  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 = 64323 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
  credit,
  sourcelink
from
  bibliographicdata b,
  translation_bibliographicdata tb
WHERE
  tb.translation_id = 64323
  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 = 64323 and tb.bibliographicdata_id = b.id and sourcelink is not null and credit is not null;

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 = 64323
  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 = 64323 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
  w.book_id
FROM
  expositionwork w,
  expositiontranslation t
where
  t.id = 64323
  and t.work_id = w.id
limit
  1

SELECT w.book_id FROM expositionwork w, expositiontranslation t where t.id = 64323 and t.work_id = w.id limit 1;

select
  bs.level_id,
  sw.story_id
from
  story_work sw,
  biblestory bs,
  expositiontranslation t
where
  t.id = 64323
  and t.work_id = sw.work_id
  and sw.story_id = bs.id
order by
  bs.level_id
limit
  1

select bs.level_id, sw.story_id from story_work sw, biblestory bs, expositiontranslation t where t.id = 64323 and t.work_id = sw.work_id and sw.story_id = bs.id order by bs.level_id limit 1;

SELECT
  cl.concept_id
FROM
  work_category wc,
  concept_work cl,
  expositiontranslation t
WHERE
  t.id = 64323
  and wc.category_id = 12
  and wc.work_id = t.work_id
  and cl.work_id = t.work_id

SELECT cl.concept_id FROM work_category wc, concept_work cl, expositiontranslation t WHERE t.id = 64323  and wc.category_id = 12 and wc.work_id = t.work_id and cl.work_id = t.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 = ?

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

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 translation_category ON t0.id = translation_category.category_id
WHERE
  translation_category.translation_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 translation_category ON t0.id = translation_category.category_id WHERE translation_category.translation_id = 64323;

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 = 45
  and p.division_id = d.id
  and p.ordering < 0
  and tt.translation_id = 64323
  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 = 45 and p.division_id = d.id and p.ordering < 0 and tt.translation_id=64323 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;