SELECT *, (SELECT `real_file_name` FROM `goods_file_data` WHERE `goods_info_idx`=`goods_info`.`idx` AND `image_type`='thumb') AS `thumb`, (SELECT `real_file_name` FROM `goods_file_data` WHERE `goods_info_idx`=`goods_info`.`idx` AND `image_type`='detail') AS `detail`, (SELECT GROUP_CONCAT(`real_file_name` SEPARATOR '|rnqnswk|') FROM `goods_file_data` WHERE `goods_info_idx`=`goods_info`.`idx`) AS `upfiles`, (SELECT GROUP_CONCAT(`real_file_name` SEPARATOR '|rnqnswk|') FROM `goods_file_data` WHERE `goods_info_idx`=`goods_info`.`idx` AND `image_type`='sub') AS `upfiles_view`, 0 AS `zzim_count`, (SELECT SUM(`stock`) FROM `option_data` WHERE `goods_info_idx`=`goods_info`.`idx` AND `use_flag`='y') AS `stock` FROM `goods_info` WHERE `idx`=
There is an error in the transmitted query. ERROR_CODE 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 '' at line 1