SELECT * FROM `container_properties`as `cp`, `container_rel` as `cr` WHERE `cr`.`prod_id` IN () AND `cr`.`prop_id`=`cp`.`id` order by `model_subcat_id`
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 `cr`.`prop_id`=`cp`.`id` order by `model_subcat_id`' at line 1