SELECT COUNT(DISTINCT bcv) AS count_verses, COUNT(*) AS count_occurences, book_no, chapter_no
			FROM {bible_index}
			WHERE is_within_group = 0 AND lemma = :L
			GROUP BY book_no, chapter_no
			ORDER BY book_no, chapter_no
		

ERROR

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'bible_index} WHERE is_within_group = 0 AND lemma = 'в' GROUP BY book_no' at line 2

#0 /var/www/html/bibel/WebApp/core/DB/class.DB.php(171): DB::HandleError()
#1 /var/www/html/bibel/WebApp/modules/Strongs/class.Strongs.php(324): DB::Query()
#2 /var/www/html/bibel/WebApp/modules/Strongs/class.Lemmas.php(274): Strongs::BuildBibleStats()
#3 /var/www/html/bibel/WebApp/modules/Strongs/class.LemmaInfo.php(25): Lemmas::GetLemmaInfo()
#4 /var/www/html/bibel/WebApp/modules/Panels/class.ContentTypesBase.php(97): LemmaInfo::FromUrl()
#5 /var/www/html/bibel/WebApp/modules/Panels/page.Layout.php(14): ContentTypesBase::GetElementFromUrl()
#6 /var/www/html/bibel/WebApp/core/Core/class.Core.php(292): require('...')
#7 /var/www/html/bibel/WebApp/core/Core/class.Core.php(224): Core::RenderPage()
#8 /var/www/html/bibel/WebApp/core/Core/class.Core.php(177): Core::ExecuteMappedRequest()
#9 /var/www/html/bibel/WebApp/index.php(5): Core::ExecuteRequest()
#10 {main}
Buchname
Buchname
Zurück
Zurück