Read

SELECT kidbo_Chapter.idChapter, kidbo_Chapter.title, kidbo_Chapter.chapterNum, kidbo_Page.pageNum FROM `kidbo_Chapter` INNER JOIN kidbo_Part ON kidbo_Part.idPart = kidbo_Chapter.idPart INNER JOIN kidbo_Page ON kidbo_Page.idChapter = kidbo_Chapter.idChapter WHERE kidbo_Part.idBook= AND kidbo_Part.idFormat= AND kidbo_Chapter.isDel=0 AND kidbo_Part.isDel=0 AND kidbo_Page.isDel=0 AND kidbo_Chapter.isDel=0 GROUP BY kidbo_Chapter.idChapter ORDER BY partNum, chapterNum
(0):
#FileLineCall
0 /home/KIDOONS/htdocs/libs/DB/Connections/MySQLConnection.php 36 KIDOONS\DB\Connections\MySQLConnection->_query("SELECT kidbo_Chapter.idChapter, kidbo_Chapter.title, kidbo_Chapter.chapterNum, kidbo_Page.pageNum FROM `kidbo_Chapter` INNER JOIN kidbo_Part ON kidbo_Part.idPart = kidbo_Chapter.idPart INNER JOIN kidbo_Page ON kidbo_Page.idChapter = kidbo_Chapter.idChapter WHERE kidbo_Part.idBook= AND kidbo_Part.idFormat= AND kidbo_Chapter.isDel=0 AND kidbo_Part.isDel=0 AND kidbo_Page.isDel=0 AND kidbo_Chapter.isDel=0 GROUP BY kidbo_Chapter.idChapter ORDER BY partNum, chapterNum");
1 /home/KIDOONS/htdocs/libs/DB/DBObject.php 66 KIDOONS\DB\Connections\MySQLConnection->executeQuery("SELECT kidbo_Chapter.idChapter, kidbo_Chapter.title, kidbo_Chapter.chapterNum, kidbo_Page.pageNum FROM `kidbo_Chapter` INNER JOIN kidbo_Part ON kidbo_Part.idPart = kidbo_Chapter.idPart INNER JOIN kidbo_Page ON kidbo_Page.idChapter = kidbo_Chapter.idChapter WHERE kidbo_Part.idBook= AND kidbo_Part.idFormat= AND kidbo_Chapter.isDel=0 AND kidbo_Part.isDel=0 AND kidbo_Page.isDel=0 AND kidbo_Chapter.isDel=0 GROUP BY kidbo_Chapter.idChapter ORDER BY partNum, chapterNum");
2 /home/KIDOONS/htdocs/libs/DataObjects/kidbo/Book.php 71 KIDOONS\DB\DBObject->search(array("fields" => array(0 => "kidbo_Chapter.idChapter", 1 => "kidbo_Chapter.title", 2 => "kidbo_Chapter.chapterNum", 3 => "kidbo_Page.pageNum"), "tables" => array(0 => array(0 => NULL, 1 => "kidbo_Part", 2 => "INNER JOIN", 3 => array(0 => "kidbo_Part.idPart = kidbo_Chapter.idPart")), 1 => array(0 => NULL, 1 => "kidbo_Page", 2 => "INNER JOIN", 3 => array(0 => "kidbo_Page.idChapter = kidbo_Chapter.idChapter"))), "where" => array(0 => "kidbo_Part.idBook=", 1 => "kidbo_Part.idFormat=", 2 => "kidbo_Chapter.isDel=0", 3 => "kidbo_Part.isDel=0", 4 => "kidbo_Page.isDel=0"), "group_by" => "kidbo_Chapter.idChapter", "order" => "partNum, chapterNum"));
3 /home/KIDOONS/htdocs/libs/DataObjects/kidbo/Book.php 114 KIDOONS\kidbo\DataObjects\Book->getChapters();
4 /tmp/KIDOONS/htdocs/_smarty_c/%%B4^B49^B49E8133%%book-enter.tpl.php 48 KIDOONS\kidbo\DataObjects\Book->getAbridgedText();
5 /home/KIDOONS/htdocs/libs/Smarty/Smarty.class.php 1886 include("/tmp/KIDOONS/htdocs/_smarty_c/%%B4^B49^B49E8133%%book-enter.tpl.php");
6 /tmp/KIDOONS/htdocs/_smarty_c/%%FC^FC8^FC85A2EA%%book.tpl.php 20 Smarty->_smarty_include(array("smarty_include_tpl_file" => "/home/KIDOONS/htdocs/share/formats/site/bookPortal/templates/book-enter.tpl", "smarty_include_vars" => arra)));
7 /home/KIDOONS/htdocs/libs/Smarty/Smarty.class.php 1886 include("/tmp/KIDOONS/htdocs/_smarty_c/%%FC^FC8^FC85A2EA%%book.tpl.php");
8 /tmp/KIDOONS/htdocs/_smarty_c/%%B2^B2F^B2FCADFA%%page_display.tpl.php 32 Smarty->_smarty_include(array("smarty_include_tpl_file" => "bookPortal/templates/book.tpl", "smarty_include_vars" => arra)));
9 /home/KIDOONS/htdocs/libs/Smarty/Smarty.class.php 1273 include("/tmp/KIDOONS/htdocs/_smarty_c/%%B2^B2F^B2FCADFA%%page_display.tpl.php");
10 /home/KIDOONS/htdocs/libs/Smarty/Smarty.class.php 1123 Smarty->fetch("/home/KIDOONS/htdocs/share/formats/site/bookPortal/templates/page_display.tpl", NULL, NULL, TRUE);
11 /home/KIDOONS/htdocs/share/www/index.php 103 Smarty->display("/home/KIDOONS/htdocs/share/formats/site/bookPortal/templates/page_display.tpl");