UPDATE oxarticles SET oxweight = 0
where oxparentid = “” and oxid IN (
SELECT oxobjectid from oxobject2category
where oxcatnid = ‘KATEGORIEID‘
)
*oxweight = 0 & KATEGORIEID bitte entsprechend anpassen (Tabellenspalte: oxcategories__oxid).
UPDATE oxarticles SET oxweight = 0
where oxparentid = “” and oxid IN (
SELECT oxobjectid from oxobject2category
where oxcatnid = ‘KATEGORIEID‘
)
*oxweight = 0 & KATEGORIEID bitte entsprechend anpassen (Tabellenspalte: oxcategories__oxid).