SELECT * FROM `waregroup` WHERE `waregroup`.devfilter IS TRUE and `WareGroupID` = 1
SELECT * FROM (
SELECT wn.*, (
SELECT COUNT(g.GoodsID)
FROM goods AS g
WHERE g.wareGroupID=1
AND g.warenameid=wn.warenameid
AND (`g`.`Disabled` <> 1 OR `g`.`Disabled` IS NULL)
AND `g`.`GoodsID` < '60000'
)
AS KolVo FROM warename AS wn) AS tmpx
WHERE KolVO>0 order by `WareNameLV`
select `g`.*
from
(select `g`.*, `skladb`.WebActionPrice(`ga`.`Price`*1, '0') AS ORDERPrice, ga.Actioncomment AS ORDERCommment, CAST(ga.Checked AS UNSIGNED INTEGER) as `checked`
from `goods` as `g` LEFT JOIN `skladb`.goodsaction AS ga ON (ga.goodsid=g.goodsid and ga.userid=20 AND ga.Checked=1)
where (`g`.`WareNameID` = '526' or warenameid in (select warenameid from websearchgroupwn where websearchgroupid='0'))
and `g`.`GoodsID` < '60000'
and (`g`.`Disabled` <> 1 OR `g`.`Disabled` is NULL) ) as `g`
group by `g`.`GoodsID`
order by `g`.`checked` desc, `g`.`GoodsID`
limit 40, 10
select SQL_CALC_FOUND_ROWS `g`.*
from
(select `g`.*, `skladb`.WebActionPrice(`ga`.`Price`*1, '0') AS ORDERPrice, ga.Actioncomment AS ORDERCommment, CAST(ga.Checked AS UNSIGNED INTEGER) as `checked`
from `goods` as `g` LEFT JOIN `skladb`.goodsaction AS ga ON (ga.goodsid=g.goodsid and ga.userid=20 AND ga.Checked=1)
where (`g`.`WareNameID` = '526' or warenameid in (select warenameid from websearchgroupwn where websearchgroupid='0'))
and `g`.`GoodsID` < '60000'
and (`g`.`Disabled` <> 1 OR `g`.`Disabled` is NULL) ) as `g`
group by `g`.`GoodsID`
order by `g`.`checked` desc, `g`.`GoodsID`
limit 1
SELECT FOUND_ROWS() as cnt;
SELECT cc.`GoodsID` AS id
FROM catalogcode_cut AS ccc
LEFT JOIN catalogcode AS cc ON cc.`CatalogCodeID` = ccc.`catalogcodeid`
WHERE code_cut = '4'
