img
img
img
img
shape
shape


.1.SQL: SELECT DISTINCT `G`.`idgoods`, `G`.`goods_idgoods`, `G`.`name`, IF(ExtractValue(`G`.`xml`, '//root/g/nostock')=1,'ناموجود',`G`.`valuecanchange`) as `valuecanchange`, IFNULL((select CONCAT("[",min(`GG`.`value`),"-",max(`GG`.`value`),"]") from `goods` `GG` where `GG`.`goods_idgoods` = `G`.`idgoods`),format(`G`.`value`,0)) as `value`, IF(IFNULL((select CONCAT("[",min(`GA`.`value`),"-",max(`GA`.`value`),"]") from `goods` `GA` where `GA`.`goods_idgoods` = `G`.`idgoods`),true),"افزودن به سبد خرید","انتخاب سایز") as `addtobasket_message`, IF(IFNULL((select CONCAT("[",min(`GB`.`value`),"-",max(`GB`.`value`),"]") from `goods` `GB` where `GB`.`goods_idgoods` = `G`.`idgoods`),true),true,false) as `addtobasket_flag`, format(`G`.`value` / cast(ExtractValue(`G`.`xml`, '//root/g/uqty2') AS DECIMAL(10,2)),0) as `v`, if(isnull(`favoritegoods`.`goods_idgoods`),false, true) as `fav`, `G`.`xml` FROM `goods` G LEFT JOIN `favoritegoods` ON (`favoritegoods`.`goods_idgoods`=`G`.`idgoods`) and (`favoritegoods`.`user_iduser`=302 ) LEFT JOIN `goods_has_ordertype` X ON `X`.`goods_idgoods` = `G`.`idgoods` WHERE `G`.`template` = 1 and `G`.`active`=1 and ((`G`.`goods_idgoods`=0) OR ()) and `X`.`ordertype_idordertype` = 1 and ExtractValue(`G`.`xml`, '//root/g/ct') REGEXP REPLACE(REPLACE(IF(''='','1',''),'_','.'),',','|') -- and `G`.`name` like "%%" ORDER BY cast(ExtractValue(`G`.`xml`, '//root/g/priority') AS DECIMAL(10,2)) DESC LIMIT ,9; Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) and `X`.`ordertype_idordertype` = 1 and ExtractValue(`G`.`xml`, '' at line 16 iduser: _SESSION['iduser']:
بالا