SELECT *, (SELECT `brand_name` FROM `brand_info` WHERE `idx`=`goods_info`.`brand`) AS `brand_name`, (SELECT `real_file_name` FROM `goods_file_data` WHERE `goods_info_idx`=`goods_info`.`idx` AND `image_type`='thumb') AS `thumb`, (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`, (SELECT GROUP_CONCAT(`color_code` SEPARATOR '|rnqnswk|') FROM `goods_join_dbcolor` WHERE `goods_info_idx`=`goods_info`.`idx`) AS `dbcolor`, (SELECT `sale_price` FROM `timesale_join_goods` WHERE `goods_info_idx`=`goods_info`.`idx` AND `timesale_info_idx` IN (SELECT `idx` FROM `timesale_info` WHERE `s_date`<=DATE_FORMAT(NOW(), '%Y-%m-%d') AND `e_date`>=DATE_FORMAT(NOW(), '%Y-%m-%d'))) AS `sale_price`, 0 AS `zzim_count`, (SELECT SUM(`count`) FROM `goods_option_data` WHERE `goods_info_idx`=`goods_info`.`idx` AND `del_flag`='n' AND `use_flag`='y') AS `stock` FROM `goods_info` WHERE flag_sale = 'y' AND `idx`= AND `flag_access`='all'

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 'AND `flag_access`='all'' at line 1

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /pw_newbonto10g/www/_model/class.db_query.php on line 101 Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in /pw_newbonto10g/www/_model/class.db_query.php on line 102
SELECT A.`idx`, B.`code_name`, B.`code_value`, CONCAT('/_public/uploadFiles/icon/', B.`real_file_name`) AS `real_file_name` FROM `goods_join_icon` A JOIN `icon_data` B ON A.`icon_data_idx`=B.`code_idx` WHERE A.`goods_info_idx`= ORDER BY B.`onum` ASC

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 'ORDER BY B.`onum` ASC' at line 1

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in /pw_newbonto10g/www/_model/class.db_query.php on line 74 - 떠날땐 본토샵