SQL error: SELECT COUNT(*) AS count FROM `onereddot_product` WHERE `lang` = '1' AND `hidden` = '0' AND (`show_date` = '0000-00-00 00:00:00' OR `show_date` <= '2025-07-17 09:49:08') AND (`hide_date` = '0000-00-00 00:00:00' OR `hide_date` >= '2025-07-17 09:49:08') AND (`parent_id` NOT IN (SELECT product_id FROM `onereddot_product` WHERE (`show_date` != '0000-00-00 00:00:00' AND `show_date` > '2025-07-17 09:49:08') OR (`hide_date` != '0000-00-00 00:00:00' AND `hide_date` < '2025-07-17 09:49:08') OR `hidden` = '1')) AND product_Id IN() AND country_id = 1 AND region_id = 2 AND type_id = 12
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 country_id = 1 AND region_id = 2 AND type_id = 12' at line 10
SQL error: SELECT * FROM `onereddot_product` WHERE `lang` = '1' AND `hidden` = '0' AND (`show_date` = '0000-00-00 00:00:00' OR `show_date` <= '2025-07-17 09:49:08') AND (`hide_date` = '0000-00-00 00:00:00' OR `hide_date` >= '2025-07-17 09:49:08') AND (`parent_id` NOT IN (SELECT product_id FROM `onereddot_product` WHERE (`show_date` != '0000-00-00 00:00:00' AND `show_date` > '2025-07-17 09:49:08') OR (`hide_date` != '0000-00-00 00:00:00' AND `hide_date` < '2025-07-17 09:49:08') OR `hidden` = '1')) AND product_Id IN() AND country_id = 1 AND region_id = 2 AND type_id = 12 ORDER BY title ASC, `seq` DESC, `parent_id` ASC, `title` ASC, `product_id` ASC LIMIT 0, 10
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 country_id = 1 AND region_id = 2 AND type_id = 12 ORDER BY title ASC, `...' at line 10