rollback.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 '"Sm" AND `price` > "0" AND ( (opendate <= '2024-07-24 05:01:46' OR opendate...' at line 1object(mysqli_sql_exception)#8 (8) { ["message":protected]=> string(228) "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 '"Sm" AND `price` > "0" AND ( (opendate <= '2024-07-24 05:01:46' OR opendate...' at line 1" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(1064) ["file":protected]=> string(63) "/var/www/vhosts/4-bridal.jp/public_html/libs/class.DataBase.php" ["line":protected]=> int(150) ["trace":"Exception":private]=> array(5) { [0]=> array(3) { ["file"]=> string(63) "/var/www/vhosts/4-bridal.jp/public_html/libs/class.DataBase.php" ["line"]=> int(150) ["function"]=> string(12) "mysqli_query" } [1]=> array(5) { ["file"]=> string(64) "/var/www/vhosts/4-bridal.jp/public_html/ctrl/class.ControlDB.php" ["line"]=> int(227) ["function"]=> string(5) "Query" ["class"]=> string(8) "DataBase" ["type"]=> string(2) "->" } [2]=> array(5) { ["file"]=> string(64) "/var/www/vhosts/4-bridal.jp/public_html/ctrl/class.ControlDB.php" ["line"]=> int(65) ["function"]=> string(8) "getLimit" ["class"]=> string(9) "ControlDB" ["type"]=> string(2) "->" } [3]=> array(5) { ["file"]=> string(68) "/var/www/vhosts/4-bridal.jp/public_html/template/category/header.php" ["line"]=> int(184) ["function"]=> string(8) "getTable" ["class"]=> string(9) "ControlDB" ["type"]=> string(2) "->" } [4]=> array(4) { ["file"]=> string(58) "/var/www/vhosts/4-bridal.jp/public_html/marriage/index.php" ["line"]=> int(12) ["args"]=> array(1) { [0]=> string(68) "/var/www/vhosts/4-bridal.jp/public_html/template/category/header.php" } ["function"]=> string(12) "require_once" } } ["previous":"Exception":private]=> NULL ["sqlstate":protected]=> string(5) "42000" }
Invalid query:

Whole query: 
SELECT *  FROM 4cb_pairproduct_tbl a WHERE ('name'  IS NOT NULL AND `status` = "1" AND `category_id` = "214" AND `design_id`  "Sm" AND `price` > "0" AND   ( (opendate <= '2024-07-24 05:01:46' OR opendate IS NULL OR opendate="" ) )  AND ( (closedate >= '2024-07-24 05:01:46' OR closedate IS NULL OR closedate="" ) )   ) ORDER BY `priority` DESC , `registdate` DESC , `id` DESC