2025-03-02 11:46:33 --- EMERGENCY: Database_Exception [ 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 '-12,12' at line 1 [ SELECT c1.id, c1.`recommended`, c1.`viewed`, c1.`region_id`, c1.`street_id`, c1.`created_at`, c1.`prod_square`,  (SELECT fpv1.`value_en` FROM `feature_product` AS fp1 LEFT JOIN `variants` AS fpv1 ON fpv1.`id` = fp1.`val` WHERE fp1.`product_id` = c1.`id` AND fp1.`feature_id` = 2 LIMIT 0,1) AS objtype,(SELECT fp2.`val` FROM `feature_product` AS fp2 WHERE fp2.`product_id` = c1.`id` AND fp2.`feature_id` = 25 LIMIT 0,1) AS objyear,(SELECT fp3.`val` FROM `feature_product` AS fp3 WHERE fp3.`product_id` = c1.`id` AND fp3.`feature_id` = 6 LIMIT 0,1) AS objbedrooms,(SELECT fp4.`val` FROM `feature_product` AS fp4 WHERE fp4.`product_id` = c1.`id` AND fp4.`feature_id` = 7 LIMIT 0,1) AS objbaths,(SELECT mcatn.`category_id` FROM `category_product` AS mcatn WHERE mcatn.`product_id` = c1.`id` LIMIT 0,1) AS mcat_id, c1.`price_gel`, c1.`price_usd`, AVG(c_rat.`rating`) AS prat, c1.`title_en` AS title, c1.`banner_text_en` AS banner_text, c1.`bannertext2_en` AS bannertext2, c1.alias, c2.name AS bname, c1.image_id AS main_img_id, c1.sq_image_id AS sqr_img_id, c4.filename AS main_image, c5.filename AS sqr_image FROM products AS c1 INNER JOIN `category_product` AS cpt ON cpt.`product_id` = c1.`id` AND cpt.`category_id` IN (-1,582,583,591) INNER JOIN `categories` AS cptt ON cptt.id = cpt.`category_id` LEFT JOIN `product_reviews` AS c_rat ON c_rat.`product_id` = c1.`id` AND c_rat.`status` = 1 LEFT JOIN images AS c4 ON c4.id = c1.image_id LEFT JOIN images AS c5 ON c5.id = c1.sq_image_id LEFT JOIN brands AS c2 ON c2.id = c1.brand_id WHERE c1.`id` IN (-1,262,265,268,271,279,284,286,287,288,291,292,293,294,295,296,297,301,302,303,305,307,308,311,318,319,320,321,322,323,324,325,326,327,328,329,330,332,341,342,343,345,346,349,350,351,353,354,361,362,363,364,365,367,368,369,370,371,373,374,375,376,377,378,379,380,381,382,383,385,386,387,388,389,392,393,394,395,397,398,399,401,402,405,406,408,409,410,411,413,414,417,418,419,420,421,424,426,427,437,438,441,442,447,448,452,454,455,456,458,459,460,463,464,465,466,467,471,476,477,478,480,481,482,483,485,486,488,493,495,496,505,507,512,520,522,533,534,536,539) AND c1.status = 1 GROUP BY c1.id ORDER BY c1.`sort_order` ASC, c1.id DESC,c1.created_at DESC LIMIT -12,12 ] ~ MODPATH/database/classes/Kohana/Database/MySQLi.php [ 171 ] in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2025-03-02 11:46:33 --- DEBUG: #0 /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php(251): Kohana_Database_MySQLi->query(1, 'SELECT c1.id, c...', false, Array)
#1 /var/www/batumihome/data/www/batumihome.ge/application/classes/Controller/Index/Catalog.php(197): Kohana_Database_Query->execute()
#2 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Controller.php(84): Controller_Index_Catalog->action_filter()
#3 [internal function]: Kohana_Controller->execute()
#4 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Catalog))
#5 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#6 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#7 /var/www/batumihome/data/www/batumihome.ge/public/index.php(120): Kohana_Request->execute()
#8 {main} in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251