.2.SQL: SELECT
`g`.`idgoods`,
IF((select count(`ga`.`idgoods`) from `goods` `ga` where `ga`.`goods_idgoods` = `g`.`idgoods`) > 0,1,IF(`g`.`goods_idgoods`=0,0,1)) as `needsdropdown`,
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`,
IF(IFNULL((select CONCAT("[",min(`GB`.`value`),"-",max(`GB`.`value`),"]") from `goods` `GB` where `GB`.`goods_idgoods` = `g`.`idgoods`),true),
IF(`g`.`goods_idgoods`=0,'',(select GROUP_CONCAT(CONCAT('')) from `goods` `gg` where `gg`.`goods_idgoods`=`g`.`goods_idgoods`)) ,
(select GROUP_CONCAT(CONCAT('')) from `goods` `gg` where `gg`.`goods_idgoods`=`g`.`idgoods`)
) as ext2, `g`.`name` as `name`,
`g`.`unit`,
IFNULL((select CONCAT("[",min(`GG`.`value`),"-",max(`GG`.`value`),"]") from `goods` `GG` where `GG`.`goods_idgoods` = `g`.`idgoods`),format(`g`.`value`,0)) as `value`,
`g`.`cost`,
`g`.`overhead`,
`g`.`discount`,
`g`.`orderpoint`,
`g`.`valuecanchange`,
`g`.`template`,
`g`.`set`,
`g`.`salefromstock`,
`g`.`individuallynosaleflag`,
`g`.`barcode`,
`g`.`note`,
`g`.`grossweight`,
`g`.`packedweight`,
`g`.`length`,
`g`.`width`,
`g`.`height`,
`g`.`goodstype_idgoodstype`,
`g`.`active`,
`g`.`qty`,
`g`.`decimalflag`,
`g`.`quantityflag`,
ExtractValue(`g`.`xml`, '//root/g/html') as `html`,
(SELECT
group_concat(
CONCAT(
CONCAT('
',`name`,'
'),
CONCAT('
',`HTML`,'
'),
'
')
)
FROM `swatch` `s`
WHERE
((ExtractValue(`g`.`xml`, '//root/g/ct') COLLATE utf8_persian_ci) REGEXP REPLACE(REPLACE(ExtractValue(`s`.`xml`, '//root/c/sc'),'_','.'),',','|'))
and IF( LENGTH(TRIM(`s`.`HTML`))>0,true,false)
) as `swatch_html`
FROM `goods` `g`
WHERE `g`.`idgoods`=745;
Error:
iduser:
_SESSION['iduser']:
محصولات مرتبط
.2.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
and `X`.`ordertype_idordertype` = 1
and ExtractValue(`G`.`xml`, '//root/g/ct') REGEXP REPLACE(REPLACE((select ExtractValue(`x`.`xml`, '//root/g/related') from `goods` `x` where `x`.`idgoods` = 745 ),'_','.'),',','|')
ORDER BY cast(ExtractValue(`G`.`xml`, '//root/g/priority') AS DECIMAL(10,2)) DESC
Error:
iduser:
_SESSION['iduser']:
