Database_Exception [ 1064 ]: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND product.lotup_flg = 0 AND product.rate IN (0,1) AND product.display_flg = 1 ' at line 6 [ SELECT product.*,rank.total as ranking_count FROM ib_product as product LEFT JOIN ib_product_sub_kind AS sub_kind ON sub_kind.product_id = product.id AND sub_kind.del_flg = 0 LEFT JOIN (SELECT ra.product_id as product_id ,sum(ra.count) as total FROM ib_product_ranking as ra WHERE ra.del_flg = 0 AND ra.created >= '2024-03-22 15:09:54' AND ra.created <= '2024-03-29 15:09:54' GROUP BY ra.product_id) as rank ON rank.product_id = product.id WHERE product.del_flg = 0 AND (product.product_kind = '3' OR sub_kind.kind = '3') AND product.type = 0 AND AND product.lotup_flg = 0 AND product.rate IN (0,1) AND product.display_flg = 1 AND product.display_start_date <= '2024-03-29 15:09:54' GROUP BY product.id ORDER BY ranking_count desc,product.purchase_count desc,product.bookmark_count desc,product.delivery_date desc,product.created desc LIMIT 8 ]

MODPATH/database/classes/Kohana/Database/MySQLi.php [ 171 ]

166 			{
167 				// This benchmark is worthless
168 				Profiler::delete($benchmark);
169 			}
170 
171 			throw new Database_Exception(':error [ :query ]', [
172 				':error' => $this->_connection->error,
173 				':query' => $sql
174 			], $this->_connection->errno);
175 		}
176 
  1. MODPATH/database/classes/Kohana/Database/Query.php [ 251 ] » Kohana_Database_MySQLi->query(arguments)

  2. APPPATH/classes/Model/Product.php [ 1117 ] » Kohana_Database_Query->execute()

  3. APPPATH/classes/Controller/Store.php [ 903 ] » Model_Product::search(arguments)

  4. SYSPATH/classes/Kohana/Controller.php [ 84 ] » Controller_Store->action_search()

  5. {PHP internal call} » Kohana_Controller->execute()

  6. SYSPATH/classes/Kohana/Request/Client/Internal.php [ 98 ] » ReflectionMethod->invoke(arguments)

  7. SYSPATH/classes/Kohana/Request/Client.php [ 114 ] » Kohana_Request_Client_Internal->execute_request(arguments)

  8. SYSPATH/classes/Kohana/Request.php [ 993 ] » Kohana_Request_Client->execute(arguments)

  9. APPPATH/bootstrap.php [ 413 ] » Kohana_Request->execute()

  10. DOCROOT/index.php [ 111 ] » require(arguments)

Environment