Log Messages
Info. & Errors 2
Informational and error log messages generated during the execution of the application.
Level | Channel | Message |
---|---|---|
INFO 08:11:32 | request |
Matched route "reading_plan_step_translated" .
[ "route" => "reading_plan_step_translated" "route_parameters" => [ "_controller" => "NCBS\WebsiteBundle\Controller\BibleController::readingPlanStepAction" "_locale" => "en" "readingPlanUrl" => "new-christian-bible" "stepOrder" => "74" "translationUrl" => "croatian" "_route" => "reading_plan_step_translated" ] "request_uri" => "https://dv285zceyyjcw5t4.newchristianbiblestudy.org/app_dev.php/reading-plans/new-christian-bible/74/croatian" "method" => "GET" ] |
INFO 08:11:32 | security | Populated the TokenStorage with an anonymous Token. |
Deprecations 9
Log messages generated by using features marked as deprecated.
Debug 353
Unimportant log messages generated during the execution of the application.
Time | Channel | Message |
---|---|---|
08:11:32 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure" ] |
08:11:32 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest" ] |
08:11:32 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest" ] |
08:11:32 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest" ] |
08:11:32 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::onKernelRequest" ] |
08:11:32 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest" ] |
08:11:32 | event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest" ] |
08:11:32 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest" ] |
08:11:32 | event |
Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest" .
[ "event" => "kernel.request" "listener" => "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest" ] |
08:11:32 | event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController" ] |
08:11:32 | event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelController" ] |
08:11:32 | event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController" ] |
08:11:32 | event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController" ] |
08:11:32 | event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController" ] |
08:11:32 | event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelController" ] |
08:11:32 | event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" .
[ "event" => "kernel.controller" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController" ] |
08:11:32 | doctrine | SELECT id FROM language WHERE shortcode = 'en' limit 1 |
08:11:32 | doctrine | SELECT rs.id, rs.name, rs.text, rs.closing_text, rs.image_file, rs.image_title, rs.video_link, rs.youtube_id, rs.video_notice, case when rl.name is null then r.name else rl.name end as plan_title, rs.ordering as step_order, rs.type_id, rs.work_id, rs.passage_id, rs.explanation_id FROM (select rsa.id, case when rsl.name is null then rsa.name else rsl.name end as name, rsa.readingplan_id, rsa.startverse_id, rsa.endverse_id, rsa.ordering, rsa.type_id, rsa.work_id, rsa.passage_id, rsa.explanation_id, case when rsl.text is null then rsa.text else rsl.text end as text, case when rsl.closing_text is null then rsa.closing_text else rsl.closing_text end as closing_text, i.file as image_file, i.title as image_title, e.location as video_link, e.youtube_id, e.notice as video_notice from readingplanstep rsa left join (select * from readingplanstep_language where language_id = 123) rsl on rsa.id = rsl.readingplanstep_id left join image i on rsa.image_id = i.id left join (select * from embed where visibilitydefault) e on rsa.embed_id = e.id) rs, readingplan r left join (select * from readingplan_language where language_id = 123) rl on r.id = rl.readingplan_id where r.url = 'new-christian-bible' and r.id = rs.readingplan_id and rs.ordering = 74 |
08:11:32 | doctrine | SELECT id FROM language WHERE shortcode = 'en' limit 1 |
08:11:32 | doctrine | SELECT max(sl.datemod) FROM ui_string_language sl, ui_string s WHERE sl.language_id in (123, 123) and s.id = sl.ui_string_id and s.is_active and s.type_id in (1, 3) |
08:11:32 | doctrine | SELECT distinct s.name, sl.text, s.fix_quote FROM ui_string_language sl, ui_string s WHERE sl.language_id = 123 and s.id = sl.ui_string_id and s.is_active and s.type_id in (1, 3) |
08:11:32 | doctrine | SELECT id FROM language WHERE shortcode = 'en' limit 1 |
08:11:32 | doctrine | SELECT rs.id, rs.name, rs.text, rs.closing_text, rs.image_file, rs.image_title, rs.video_link, rs.youtube_id, rs.video_notice, case when rl.name is null then r.name else rl.name end as plan_title, rs.ordering as step_order, cb1.id as book_id, cc1.ordering as start_chapter_order, cv1.ordering as start_verse_order, cc2.ordering as end_chapter_order, cv2.ordering as end_verse_order FROM canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb1, canonicalbibleverse cv2, canonicalbiblechapter cc2, (select rsa.id, case when rsl.name is null then rsa.name else rsl.name end as name, rsa.readingplan_id, rsa.startverse_id, rsa.endverse_id, rsa.ordering, case when rsl.text is null then rsa.text else rsl.text end as text, case when rsl.closing_text is null then rsa.closing_text else rsl.closing_text end as closing_text, i.file as image_file, i.title as image_title, e.location as video_link, e.youtube_id, e.notice as video_notice from readingplanstep rsa left join (select * from readingplanstep_language where language_id = 123) rsl on rsa.id = rsl.readingplanstep_id left join image i on rsa.image_id = i.id left join (select * from embed where visibilitydefault) e on rsa.embed_id = e.id) rs, readingplan r left join (select * from readingplan_language where language_id = 123) rl on r.id = rl.readingplan_id where r.url = 'new-christian-bible' and r.id = rs.readingplan_id and rs.ordering = 74 and cv1.id = rs.startverse_id and cv1.chapter_id = cc1.id and cb1.id = cc1.book_id and cv2.id = rs.endverse_id and cv2.chapter_id = cc2.id |
08:11:32 | doctrine |
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
[ "croatian" true ] |
08:11:32 | doctrine |
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 = ?
[
181
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
7
]
|
08:11:32 | doctrine |
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
[
7
]
|
08:11:32 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 WHERE t0.chapter_id = ? ORDER BY t0.ordering ASC
[
716
]
|
08:11:32 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 WHERE t0.chapter_id = ? ORDER BY t0.ordering ASC
[
715
]
|
08:11:32 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 WHERE t0.chapter_id = ? ORDER BY t0.ordering ASC
[
714
]
|
08:11:32 | doctrine |
SELECT DISTINCT v.id FROM bibleverse v, bibleverse mainv, biblechapter c, biblebook b, bibletranslation t, canonicalbibleverse cv, canonicalbiblechapter cc, canonicalbiblebook cb, canonicalbibleverse_bibleverse cvv WHERE ( (v.id=mainv.id AND v.verse_id IS NULL) OR (v.verse_id=mainv.id) ) AND mainv.chapter_id=c.id AND c.book_id=b.id AND b.translation_id=t.id AND t.enabled AND cv.chapter_id=cc.id AND cc.book_id=cb.id AND cv.id=cvv.canonicalbibleverse_id AND v.id=cvv.bibleverse_id AND t.id=:bible_translation_id AND cb.id=:canonical_book_id AND cc.ordering >= :canonical_first_chapter_ord AND cc.ordering <= :canonical_last_chapter_ord AND (cc.ordering > :canonical_first_chapter_ord OR cv.ordering >= :canonical_first_verse_ord) AND (cc.ordering < :canonical_last_chapter_ord OR cv.ordering <= :canonical_last_verse_ord)
[ "bible_translation_id" => 22 "canonical_book_id" => 7 "canonical_first_chapter_ord" => 3 "canonical_last_chapter_ord" => 5 "canonical_first_verse_ord" => 1 "canonical_last_verse_ord" => 31 ] |
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475245
]
|
08:11:32 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.book_id AS book_id_3 FROM biblechapter t0 WHERE t0.id = ?
[
17775
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475239
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475260
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475183
]
|
08:11:32 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.book_id AS book_id_3 FROM biblechapter t0 WHERE t0.id = ?
[
17773
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475262
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475241
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475259
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475256
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475186
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475181
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475246
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475211
]
|
08:11:32 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.book_id AS book_id_3 FROM biblechapter t0 WHERE t0.id = ?
[
17774
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475206
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475205
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475253
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475192
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475215
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475201
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475225
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475232
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475222
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475207
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475178
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475238
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475213
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475252
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475234
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475204
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475228
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475227
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475191
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475230
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475248
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475244
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475221
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475216
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475214
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475185
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475226
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475255
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475258
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475196
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475240
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475229
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475219
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475199
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475251
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475209
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475187
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475193
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475237
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475220
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475257
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475195
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475179
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475223
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475200
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475261
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475249
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475243
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475208
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475247
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475194
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475188
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475242
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475182
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475250
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475217
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475224
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475212
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475180
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475198
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475197
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475236
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475210
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475218
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475202
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475254
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475235
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475189
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475231
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475184
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475177
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475203
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475233
]
|
08:11:32 | doctrine |
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.id = ? LIMIT 1
[
475190
]
|
08:11:32 | doctrine |
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
[
17775
]
|
08:11:32 | doctrine |
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
[
17773
]
|
08:11:32 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.name AS name_3, t0.url AS url_4, t0.translation_id AS translation_id_5, t0.canonicalization_id AS canonicalization_id_6 FROM biblebook t0 WHERE t0.id = ?
[
1060
]
|
08:11:32 | doctrine | SELECT l.text_style_override FROM language l, bibletranslation bt, biblebook b WHERE b.id = 1060 and b.translation_id = bt.id and l.id = bt.language_id |
08:11:32 | doctrine | select id from readingplan where url = 'new-christian-bible' |
08:11:32 | doctrine | SELECT r.url as plan_url, rs.ordering as step_order FROM readingplan r, readingplanstep rs where r.id = 8 and r.id = rs.readingplan_id and rs.ordering > 74 order by rs.ordering limit 1 |
08:11:32 | doctrine | SELECT r.url as plan_url, rs.ordering as step_order FROM readingplan r, readingplanstep rs where r.url = 'new-christian-bible' and r.id = rs.readingplan_id and rs.ordering < 74 order by rs.ordering desc limit 1 |
08:11:32 | doctrine | SELECT min(rs.ordering) as first_order, max(rs.ordering) as last_order FROM readingplan r, readingplanstep rs where r.url = 'new-christian-bible' and r.id = rs.readingplan_id |
08:11:32 | doctrine | select id from language where shortcode = 'en' |
08:11:32 | doctrine | select language_id from bibletranslation where url = 'croatian' |
08:11:32 | doctrine | select show_bible_chapter_summary from language where id = 181 |
08:11:32 | doctrine | SELECT bs.chapter_id, t.id as translation_id, t.url, t.is_modern, t.translatedtitle as explanationtitle, case when t.language_id = 181 then 2 else case when t.language_id = 123 then 3 else 6 end end as lang_order FROM expositionwork w, expositiontranslation t, expositiontranslationtext tt, story_work sw, biblestory bs WHERE bs.chapter_id = 716 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 (181,123)) and w.ispublic AND t.ispublic order by lang_order, t.is_modern desc, t.islanguagedefault desc limit 1 |
08:11:33 | doctrine |
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.id = ? LIMIT 1
[
16256
]
|
08:11:33 | doctrine |
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 = ?
[
10856
]
|
08:11:33 | doctrine |
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
[
10856
]
|
08:11:33 | doctrine |
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
[
10125
]
|
08:11:33 | doctrine |
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
[
10125
]
|
08:11:33 | doctrine |
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
[
36741
]
|
08:11:33 | doctrine |
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 = ?
[
74828
]
|
08:11:33 | doctrine | SELECT text_style_override FROM language WHERE id = 16256 |
08:11:33 | doctrine | select translationmethod_id from expositiontranslation where id = 16256 |
08:11:33 | doctrine | select t2.id from expositiontranslation t1, expositiontranslation t2 where t1.id = 16256 and t1.work_id = t2.work_id and t2.isoriginal order by case when t2.language_id = 123 then 1 else 2 end |
08:11:33 | doctrine | 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 = 16256 and tbg.bibliographicdata_id = bp.bibliographicdata_id and bp.person_id = p.id |
08:11:33 | doctrine | SELECT t.name FROM texttospeech t, texttospeechlanguage tl WHERE tl.language_id = 123 and t.id = tl.tts_id order by tl.is_standard desc limit 1 |
08:11:33 | doctrine | select language_id from expositiontranslation where id = 16256 |
08:11:33 | doctrine | select array_to_string(array_agg(DISTINCT d.ref_id),',') as ref from expositiontextunit t, expositiontranslationtext tt, expositiondisplayitem d where t.passage_id = 36741 and tt.translation_id = 16256 and t.id = tt.placement_id and d.container_id = tt.id and d.type_id = 2 |
08:11:33 | doctrine | 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 = 123 then case when trans.languagedefault then 3 else 4 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 = 36741 and t.id = tc.textunit_id and rc.id = tc.combinedreference_id and rc.id not in (23173,76995,76997,108368,121685,131198,137831) 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 = 16256 then 1 else case when trans.language_id = 123 then case when trans.islanguagedefault then 3 else 4 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 = 36741 and t.id = tc.textunit_id and rc.id = tc.combinedreference_id and rc.id not in (23173,76995,76997,108368,121685,131198,137831) 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 |
08:11:33 | doctrine | select * from (SELECT distinct on (di.ref_id) di.ref_id, '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, true as is_bibleref, 1 as section_order, (case when trans.language_id in (select language_id from expositiontranslation where id = 16256) then 1 else case when trans.language_id = 123 then 2 else 3 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, expositiontextunit t, expositiontranslationtext tt, expositiondisplayitem di, canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbiblebook cb, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation trans WHERE t.passage_id = 36741 and t.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 = trans.id and trans.enabled order by di.ref_id, priority_order asc, trans.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) || '_' || trans.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 trans.id = 16256 then 1 else case when trans.language_id in (select language_id from expositiontranslation where id = 16256) then 2 else case when trans.language_id = 123 then 3 else 4 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, expositiontextunit t, expositiontextunit t2, expositionpassage p, expositiondivision d, expositiontranslationtext tt, expositiondisplayitem di, expositionwork w, expositiontranslation trans WHERE t.passage_id = 36741 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 t.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 = trans.work_id and trans.url is not null and trans.ispublic and w.ispublic order by di.ref_id, priority_order asc, trans.islanguagedefault desc, trans.isoriginal desc) as e |
08:11:33 | doctrine | 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 = 475262 and v.chapter_id = c.id and c.book_id = b.id and b.translation_id = t.id and t.language_id = l.id |
08:11:33 | doctrine | 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 (475262,475261,475260,475259,475258,475257,475256,475255,475254,475253,475252,475251,475250,475249,475248,475247,475246,475245,475244,475243,475242,475241,475240,475239,475238,475237,475236,475235,475234,475233,475232,475231,475230,475229,475228,475227,475226,475225,475224,475223,475222,475221,475220,475219,475218,475217,475216,475215,475214,475213,475212,475211,475210,475209,475208,475207,475206,475205,475204,475203,475202,475201,475200,475199,475198,475197,475196,475195,475194,475193,475192,475191,475190,475189,475188,475187,475186,475185,475184,475183,475182,475181,475180,475179,475178,475177)) as cvv where v.id in (475262,475261,475260,475259,475258,475257,475256,475255,475254,475253,475252,475251,475250,475249,475248,475247,475246,475245,475244,475243,475242,475241,475240,475239,475238,475237,475236,475235,475234,475233,475232,475231,475230,475229,475228,475227,475226,475225,475224,475223,475222,475221,475220,475219,475218,475217,475216,475215,475214,475213,475212,475211,475210,475209,475208,475207,475206,475205,475204,475203,475202,475201,475200,475199,475198,475197,475196,475195,475194,475193,475192,475191,475190,475189,475188,475187,475186,475185,475184,475183,475182,475181,475180,475179,475178,475177) and v.id = cvv.bibleverse_id and cv.id = cvv.canonicalbibleverse_id and cv.chapter_id = cc.id |
08:11:33 | doctrine | select array_to_string(array_agg(distinct chapter_id), ',') from canonicalbibleverse where id in (16494,16495,16496,16497,16498,16499,16500,16501,16502,16503,16504,16505,16506,16507,16508,16509,16510,16511,16512,16513,16514,16515,16516,16517,16518,16519,16520,16521,16522,16523,16524,16525,16526,16527,16528,16529,16530,16531,16532,16533,16534,16535,16536,16537,16538,16539,16540,16541,16542,16543,16544,16545,16546,16547,16548,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,16559,16560,16561,16562,16563,16564,16565,16566,16567,16568,16569,16570,16571,16572,16573,16574,16575,16576,16577,16578,16579) |
08:11:33 | doctrine | select array_to_string(array_agg(id), ',') from canonicalbiblechapter where id in (714,715,716) and id not in (select distinct chapter_id from canonicalbibleverse where chapter_id in (714,715,716) and id not in (16494,16495,16496,16497,16498,16499,16500,16501,16502,16503,16504,16505,16506,16507,16508,16509,16510,16511,16512,16513,16514,16515,16516,16517,16518,16519,16520,16521,16522,16523,16524,16525,16526,16527,16528,16529,16530,16531,16532,16533,16534,16535,16536,16537,16538,16539,16540,16541,16542,16543,16544,16545,16546,16547,16548,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,16559,16560,16561,16562,16563,16564,16565,16566,16567,16568,16569,16570,16571,16572,16573,16574,16575,16576,16577,16578,16579)) |
08:11:33 | doctrine | 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 = 181 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 (16494,16495,16496,16497,16498,16499,16500,16501,16502,16503,16504,16505,16506,16507,16508,16509,16510,16511,16512,16513,16514,16515,16516,16517,16518,16519,16520,16521,16522,16523,16524,16525,16526,16527,16528,16529,16530,16531,16532,16533,16534,16535,16536,16537,16538,16539,16540,16541,16542,16543,16544,16545,16546,16547,16548,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,16559,16560,16561,16562,16563,16564,16565,16566,16567,16568,16569,16570,16571,16572,16573,16574,16575,16576,16577,16578,16579)) and p.id not in (SELECT DISTINCT passage_id FROM chapter_passage WHERE chapter_id in (716,715,714) union SELECT DISTINCT passage_id FROM verse_passage WHERE verse_id in (16494,16495,16496,16497,16498,16499,16500,16501,16502,16503,16504,16505,16506,16507,16508,16509,16510,16511,16512,16513,16514,16515,16516,16517,16518,16519,16520,16521,16522,16523,16524,16525,16526,16527,16528,16529,16530,16531,16532,16533,16534,16535,16536,16537,16538,16539,16540,16541,16542,16543,16544,16545,16546,16547,16548,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,16559,16560,16561,16562,16563,16564,16565,16566,16567,16568,16569,16570,16571,16572,16573,16574,16575,16576,16577,16578,16579) 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 (16494,16495,16496,16497,16498,16499,16500,16501,16502,16503,16504,16505,16506,16507,16508,16509,16510,16511,16512,16513,16514,16515,16516,16517,16518,16519,16520,16521,16522,16523,16524,16525,16526,16527,16528,16529,16530,16531,16532,16533,16534,16535,16536,16537,16538,16539,16540,16541,16542,16543,16544,16545,16546,16547,16548,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,16559,16560,16561,16562,16563,16564,16565,16566,16567,16568,16569,16570,16571,16572,16573,16574,16575,16576,16577,16578,16579)) and p.id not in (SELECT DISTINCT passage_id FROM chapter_passage WHERE chapter_id in (716,715,714) union SELECT DISTINCT passage_id FROM verse_passage WHERE verse_id in (16494,16495,16496,16497,16498,16499,16500,16501,16502,16503,16504,16505,16506,16507,16508,16509,16510,16511,16512,16513,16514,16515,16516,16517,16518,16519,16520,16521,16522,16523,16524,16525,16526,16527,16528,16529,16530,16531,16532,16533,16534,16535,16536,16537,16538,16539,16540,16541,16542,16543,16544,16545,16546,16547,16548,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,16559,16560,16561,16562,16563,16564,16565,16566,16567,16568,16569,16570,16571,16572,16573,16574,16575,16576,16577,16578,16579) 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 ( 181,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 |
08:11:33 | doctrine | SELECT chapter_id, min(ordering) as min_order, max(ordering) as max_order from canonicalbibleverse WHERE id in (16494,16495,16496,16497,16498,16499,16500,16501,16502,16503,16504,16505,16506,16507,16508,16509,16510,16511,16512,16513,16514,16515,16516,16517,16518,16519,16520,16521,16522,16523,16524,16525,16526,16527,16528,16529,16530,16531,16532,16533,16534,16535,16536,16537,16538,16539,16540,16541,16542,16543,16544,16545,16546,16547,16548,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,16559,16560,16561,16562,16563,16564,16565,16566,16567,16568,16569,16570,16571,16572,16573,16574,16575,16576,16577,16578,16579) group by chapter_id |
08:11:33 | doctrine | select * from (SELECT distinct on (s.id) s.id, s.title, e.description, e.youtube_id, sr.time, s.showtype_id, e.location, case when e.youtube_id is null then 2 else 1 end as video_order, cc.ordering as chapter_order, cb1.ordering as start_verse, cb2.ordering as end_verse, case when e.youtube_id is null then 2 else 1 end as video_order1 FROM show s, embed e, show_bibleref sr left join canonicalbibleverse as cb1 on from_verse_id = cb1.id left join canonicalbibleverse as cb2 on to_verse_id = cb2.id left join canonicalbiblechapter as cc on sr.chapter_id = cc.id WHERE ( (sr.chapter_id in (714,715,716) and from_verse_id is null and to_verse_id is null) or ( to_verse_id is null and sr.from_verse_id in (16494,16495,16496,16497,16498,16499,16500,16501,16502,16503,16504,16505,16506,16507,16508,16509,16510,16511,16512,16513,16514,16515,16516,16517,16518,16519,16520,16521,16522,16523,16524,16525,16526,16527,16528,16529,16530,16531,16532,16533,16534,16535,16536,16537,16538,16539,16540,16541,16542,16543,16544,16545,16546,16547,16548,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,16559,16560,16561,16562,16563,16564,16565,16566,16567,16568,16569,16570,16571,16572,16573,16574,16575,16576,16577,16578,16579) ) or ( to_verse_id is not null and sr.chapter_id = 714 and cb1.ordering <= 1 and cb2.ordering >= 31 ) or ( to_verse_id is not null and sr.chapter_id = 715 and cb1.ordering <= 1 and cb2.ordering >= 24 ) or ( to_verse_id is not null and sr.chapter_id = 716 and cb1.ordering <= 1 and cb2.ordering >= 31 )) and s.id = sr.show_id and e.visibilitydefault and s.embed_id = e.id limit 1) as t order by video_order1 |
08:11:33 | doctrine | select id from language where shortcode = 'en' |
08:11:33 | doctrine | SELECT v.id, cv.ordering as verse_order, scc.ordering as chapter_order, t.id as translation_id, scc.id as cchapter_id, v.chapter_id, 'bible' || '_' || bt.url || '_' || cb.url || '_' || c.ordering || '_' || v.indexdisplay as bible_spec, 'explanation' || '_' || t.url as explanation_spec, bt.url as bible_trans_url, cb.url as book_url, v.indexdisplay as verse_index, case when t.language_id = 181 then 1 else case when t.language_id = 123 then 2 end end as lang_order, bt.language_id FROM (select * from biblestory where level_id = 2) as bs, canonicalbibleverse cv, (select * from canonicalbibleverse_bibleverse where bibleverse_id in (475262,475261,475260,475259,475258,475257,475256,475255,475254,475253,475252,475251,475250,475249,475248,475247,475246,475245,475244,475243,475242,475241,475240,475239,475238,475237,475236,475235,475234,475233,475232,475231,475230,475229,475228,475227,475226,475225,475224,475223,475222,475221,475220,475219,475218,475217,475216,475215,475214,475213,475212,475211,475210,475209,475208,475207,475206,475205,475204,475203,475202,475201,475200,475199,475198,475197,475196,475195,475194,475193,475192,475191,475190,475189,475188,475187,475186,475185,475184,475183,475182,475181,475180,475179,475178,475177)) as cvv, canonicalbiblechapter scc, expositionwork w, expositiontranslation t, expositiontranslationtext tt, story_work sw, biblechapter c, biblebook b, bibletranslation bt, canonicalbiblebook cb, bibleverse v WHERE w.ispublic and t.ispublic and t.language_id in (181,123) and v.id = cvv.bibleverse_id and cv.id = cvv.canonicalbibleverse_id and bs.startverse_id = cv.id and cv.chapter_id = scc.id and v.verse_id is null and sw.story_id = bs.id and w.id = sw.work_id and t.work_id=w.id and v.chapter_id = c.id and b.id = c.book_id and b.translation_id=bt.id and scc.book_id = cb.id and t.id = tt.translation_id and tt.text is not null and tt.text <> '' order by cv.ordering, lang_order, t.is_modern desc, w.ordering, t.islanguagedefault desc limit 1 |
08:11:33 | doctrine | SELECT id FROM language WHERE shortcode = 'en' limit 1 |
08:11:33 | doctrine | SELECT t.id, (case when l.nativename is not null and l.nativename <> '' then l.nativename else l.name end) as language_name, t.name as name, t.url, bk.url as first_book_url, (case when l.nativename is not null and l.nativename <> '' then l.nativename else l.name end) as group_name, (case when language_id = 123 then 1 else case when language_id = 123 then 2 else 3 end end) as group_order, true as has_book, true as has_chapter, l.righttoleft FROM language l, bibletranslation t join ( select distinct on (t2.id) t2.id as translation_id, cb.url from bibletranslation t2, biblebook b, canonicalbiblebook cb where b.translation_id = t2.id and cb.id = b.canonicalization_id order by t2.id, b.ordering) as bk on t.id = bk.translation_id WHERE t.enabled and t.language_id = l.id and t.id in (select distinct translation_id from biblebook b3, biblechapter c3, bibleverse v3 where b3.canonicalization_id = 7 and c3.book_id = b3.id and c3.ordering = 3 and v3.chapter_id = c3.id and v3.indexdisplay = '1') and t.id in (select distinct translation_id from biblebook b3, biblechapter c3, bibleverse v3 where b3.canonicalization_id = 7 and c3.book_id = b3.id and c3.ordering = 5 and v3.chapter_id = c3.id and v3.indexdisplay = '31') order by group_order, language_name, t.name |
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475262
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475261
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475260
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475259
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475258
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475257
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475256
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475255
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475254
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475253
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475252
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475251
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475250
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475249
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475248
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475247
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475246
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475245
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475244
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475243
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475242
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475241
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475240
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475239
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475238
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475237
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475236
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475235
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475234
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475233
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475232
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475231
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475230
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475229
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475228
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475227
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475226
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475225
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475224
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475223
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475222
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475221
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475220
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475219
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475218
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475217
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475216
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475215
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475214
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475213
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475212
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475211
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475210
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475209
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475208
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475207
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475206
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475205
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475204
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475203
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475202
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475201
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475200
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475199
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475198
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475197
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475196
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475195
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475194
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475193
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475192
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475191
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475190
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475189
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475188
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475187
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475186
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475185
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475184
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475183
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475182
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475181
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475180
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475179
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475178
]
|
08:11:33 | doctrine |
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.chapter_id AS chapter_id_3 FROM canonicalbibleverse t0 INNER JOIN canonicalbibleverse_bibleverse ON t0.id = canonicalbibleverse_bibleverse.canonicalbibleverse_id WHERE canonicalbibleverse_bibleverse.bibleverse_id = ?
[
475177
]
|
08:11:33 | doctrine | SELECT l.text_style_override FROM language l, bibletranslation bt, biblebook b WHERE b.id = 1060 and b.translation_id = bt.id and l.id = bt.language_id |
08:11:33 | doctrine | 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 = 475262 and v.chapter_id = c.id and c.book_id = b.id and b.translation_id = t.id and t.language_id = l.id |
08:11:33 | doctrine | select show_bible_verse_highlights from language where id = 181 |
08:11:33 | doctrine | select * from (SELECT distinct on (verse_id, term_text) * from (select cbb.bibleverse_id as verse_id, t.id as term_id, lower(t.text) as term_text, c.url as concept_url, char_length(t.text) as text_len, ct.translatedtitle as title, ct.explanation_id, c.id as concept_id FROM verse_concept vc, term_concept tc, term t, concept c, (select * from canonicalbibleverse_bibleverse where bibleverse_id in (475262,475261,475260,475259,475258,475257,475256,475255,475254,475253,475252,475251,475250,475249,475248,475247,475246,475245,475244,475243,475242,475241,475240,475239,475238,475237,475236,475235,475234,475233,475232,475231,475230,475229,475228,475227,475226,475225,475224,475223,475222,475221,475220,475219,475218,475217,475216,475215,475214,475213,475212,475211,475210,475209,475208,475207,475206,475205,475204,475203,475202,475201,475200,475199,475198,475197,475196,475195,475194,475193,475192,475191,475190,475189,475188,475187,475186,475185,475184,475183,475182,475181,475180,475179,475178,475177)) as cbb, bibleverse bv, (select distinct on (cl.concept_id) cl.concept_id, trans.translatedtitle, trans.id as explanation_id, case when trans.language_id = 181 then 1 else 2 end as ordering from concept_work cl, expositiontranslation trans where trans.language_id in (181, 123) and cl.work_id = trans.work_id order by cl.concept_id, ordering) as ct WHERE cbb.canonicalbibleverse_id = vc.verse_id and tc.concept_id = vc.concept_id and t.id = tc.term_id and c.id = tc.concept_id and t.language_id = 181 and ct.concept_id = c.id and cbb.bibleverse_id = bv.id and case when t.text is not null and (bv.content ~* ('\y' || replace(replace(replace(replace(t.text, ')', '\)'), '(', '\('), ']', '\]'), '[', '\[') || '\y')) then true else false end order by cbb.bibleverse_id, lower(t.text), term_id) as t1) as t order by verse_id, char_length(term_text) desc |
08:11:33 | doctrine | select shortcode, (case when nativename is not null and nativename <> '' then nativename else name end) as name FROM language where shortcode in ('en','sq','bg','zh','hr','cs','nl','fr','ka','de','hi','it','ja','ko','la','mk','ml','me','pt','ru','sr','es','sv','tl','uk','zu') |
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475262
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475261
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475260
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475259
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475258
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475257
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475256
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475255
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475254
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475253
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475252
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475251
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475250
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475249
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475248
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475247
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475246
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475245
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475244
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475243
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475242
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475241
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475240
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475239
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475238
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475237
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475236
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475235
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475234
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475233
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475232
]
|
08:11:33 | doctrine |
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
[
17774
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475231
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475230
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475229
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475228
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475227
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475226
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475225
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475224
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475223
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475222
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475221
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475220
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475219
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475218
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475217
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475216
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475215
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475214
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475213
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475212
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475211
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475210
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475209
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475208
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475207
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475206
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475205
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475204
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475203
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475202
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475201
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475200
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475199
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475198
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475197
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475196
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475195
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475194
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475193
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475192
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475191
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475190
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475189
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475188
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475187
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475186
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475185
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475184
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475183
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475182
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475181
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475180
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475179
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475178
]
|
08:11:33 | doctrine |
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.verse_id = ? ORDER BY t0.ordering ASC
[
475177
]
|
08:11:33 | event |
Notified event "kernel.response" to listener "JMS\I18nRoutingBundle\EventListener\CookieSettingListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "JMS\I18nRoutingBundle\EventListener\CookieSettingListener::onKernelResponse" ] |
08:11:33 | event |
Notified event "kernel.response" to listener "Symfony\Bridge\Monolog\Handler\FirePHPHandler::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Bridge\Monolog\Handler\FirePHPHandler::onKernelResponse" ] |
08:11:33 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse" ] |
08:11:33 | event |
Notified event "kernel.response" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelResponse" ] |
08:11:33 | event |
Notified event "kernel.response" to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse" ] |
08:11:33 | event |
Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse" ] |
08:11:33 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse" ] |
08:11:33 | event |
Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse" ] |
08:11:33 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse" ] |
08:11:33 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SaveSessionListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\SaveSessionListener::onKernelResponse" ] |
08:11:33 | event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" .
[ "event" => "kernel.response" "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse" ] |
08:11:33 | event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest" ] |
08:11:33 | event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest" ] |
08:11:33 | event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelFinishRequest" ] |
08:11:33 | event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest" ] |
08:11:33 | event |
Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest" .
[ "event" => "kernel.finish_request" "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest" ] |
PHP Notices 0
Log messages generated by PHP notices silenced with the @ operator.
There are no log messages of this level.
Container 835
Log messages generated during the compilation of the service container.
Class | Messages |
---|---|
Symfony\Component\DependencyInjection\Compiler\ResolveChildDefinitionsPass
|
78 |
Symfony\Component\DependencyInjection\Compiler\RemovePrivateAliasesPass
|
86 |
Symfony\Component\DependencyInjection\Compiler\ReplaceAliasByActualDefinitionPass
|
98 |
Symfony\Component\DependencyInjection\Compiler\RemoveAbstractDefinitionsPass
|
97 |
Symfony\Component\DependencyInjection\Compiler\InlineServiceDefinitionsPass
|
215 |
Symfony\Component\DependencyInjection\Compiler\RemoveUnusedDefinitionsPass
|
259 |
Symfony\Bundle\FrameworkBundle\DependencyInjection\Compiler\UnusedTagsPass
|
2 |