A PHP Error was encountered

Severity: Warning

Message: mysqli::query(): (HY000/3024): Query execution was interrupted, maximum statement execution time exceeded

Filename: mysqli/mysqli_driver.php

Line Number: 305

Backtrace:

File: /home/elibrary/public_html/application/core/MY_Model.php
Line: 184
Function: get

File: /home/elibrary/public_html/application/models/Book_model.php
Line: 826
Function: get_rows

File: /home/elibrary/public_html/application/controllers/Detail.php
Line: 258
Function: book_search

File: /home/elibrary/public_html/index.php
Line: 315
Function: require_once

Database Error

A Database Error Occurred

Error Number: 3024

Query execution was interrupted, maximum statement execution time exceeded

SELECT `angel_book`.*, GROUP_CONCAT( DISTINCT blangs.language_id) as language_ids, GROUP_CONCAT( DISTINCT subject.name_english) as subjects, GROUP_CONCAT( DISTINCT subject.id) as subject_ids, GROUP_CONCAT( DISTINCT language.name_english) as language_names, GROUP_CONCAT( DISTINCT author.name_english) as author_names, GROUP_CONCAT( DISTINCT author.slug) as author_slugs, GROUP_CONCAT( DISTINCT author.name_hindi) as author_names_hindi, GROUP_CONCAT( DISTINCT bc.category_id) as category_ids, 0 as `book_downloads`, 0 as `book_wishlist`, 0 as `book_readlist`, COUNT(DISTINCT(book_read.id)) as book_read, 0 as `popular_count`, `p`.`name_english` as `publisher`, `p`.`slug` as `publisher_slug`, GROUP_CONCAT( DISTINCT translator.name_english) as translator_names, GROUP_CONCAT( DISTINCT translator.slug) as translator_slugs, GROUP_CONCAT( DISTINCT compiler.name_english) as compiler_names, GROUP_CONCAT( DISTINCT compiler.slug) as compiler_slugs, GROUP_CONCAT( DISTINCT editor.name_english) as editor_names, GROUP_CONCAT( DISTINCT editor.slug) as editor_slugs FROM `angel_book` LEFT JOIN `angel_book_language` as `blangs` ON `blangs`.`book_id` = `angel_book`.`id` LEFT JOIN `angel_language` as `language` ON `blangs`.`language_id` = `language`.`id` AND `language`.`is_visible` = 1 LEFT JOIN `angel_book_subject` as `b_subject` ON `b_subject`.`book_id` = `angel_book`.`id` LEFT JOIN `angel_subject` as `subject` ON `subject`.`id` = `b_subject`.`subject_id` AND `subject`.`is_visible` = 1 LEFT JOIN `angel_book_author` as `b_author` ON `b_author`.`book_id` = `angel_book`.`id` LEFT JOIN `angel_person` as `author` ON `author`.`id` = `b_author`.`author_id` AND `author`.`is_visible` = 1 LEFT JOIN `angel_book_category` as `bc` ON `bc`.`book_id` = `angel_book`.`id` LEFT JOIN `angel_publisher` as `p` ON `p`.`id` = `angel_book`.`publisher` AND `p`.`is_visible` = 1 LEFT JOIN `angel_book_translator` as `b_translator` ON `b_translator`.`book_id` = `angel_book`.`id` LEFT JOIN `angel_person` as `translator` ON `translator`.`id` = `b_translator`.`translator_id` AND `translator`.`is_visible` = 1 LEFT JOIN `angel_book_compier` as `b_compiler` ON `b_compiler`.`book_id` = `angel_book`.`id` LEFT JOIN `angel_person` as `compiler` ON `compiler`.`id` = `b_compiler`.`compiler_id` AND `compiler`.`is_visible` = 1 LEFT JOIN `angel_book_editor` as `b_editor` ON `b_editor`.`book_id` = `angel_book`.`id` LEFT JOIN `angel_person` as `editor` ON `editor`.`id` = `b_editor`.`editor_id` AND `editor`.`is_visible` = 1 LEFT JOIN `angel_book_read` as `book_read` ON `book_read`.`book_id` = `angel_book`.`id` WHERE `angel_book`.`is_display` = 1 AND bc.sub_category_id = 0 GROUP BY `angel_book`.`id` HAVING `category_ids` LIKE '3' OR `category_ids` LIKE '%,3' OR `category_ids` LIKE '3,%' OR `category_ids` LIKE '%,3,%' ORDER BY `angel_book`.`id` DESC LIMIT 6

Filename: core/MY_Model.php

Line Number: 184