# inaktive artikel in DB löschen

**URL:** <https://forum.shopware.com/t/inaktive-artikel-in-db-loschen/66262>\
**Category:** Administration\
**Created:** [15. April 2020 um 08:46 UTC](https://forum.shopware.com/t/inaktive-artikel-in-db-loschen/66262 "2020-04-15T08:46:46Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![vhafner](https://avatars.discourse-cdn.com/v4/letter/v/5f8ce5/32.png) [@vhafner](https://forum.shopware.com/u/vhafner)\
**Post date:** [15. April 2020 um 08:46 UTC](https://forum.shopware.com/t/inaktive-artikel-in-db-loschen/66262/1 "2020-04-15T08:46:46Z")

</div>

ich versuche nach der offizielle anleitung alle artikel, die nicht mehr aktiv sind, direkt in der DB zu löschen (da recht viele)

habe dazu folgendes statement in phpmyadmin abgesetzt:

DELETE aimr.\*, aim.\*, acta.\*, actpa.\*, actp.\*, act.\*, acor.\*, av.\*, atr.\*, atop.\*, ASiro.\*, ASi.\*, ar.\*, apa.\*, ap.\*, an.\*, aina.\*, ain.\*, aia.\*, ai.\*, aesds.\*, aesda.\*, aesd.\*, adoa.\*, ado.\*, acs.\*, acr.\*, ac.\*, acu.\*, aa.\*, ad.\*, bro.\*, a.\*  
FROM s\_articles AS a&nbsp;  
LEFT JOIN s\_articles\_also\_bought\_ro AS bro ON a.id = bro.article\_id&nbsp;  
LEFT JOIN s\_articles\_details AS ad ON a.id = ad.articleID&nbsp;  
LEFT JOIN s\_articles\_attributes AS aa ON ad.id = aa.articledetailsID&nbsp;  
LEFT JOIN s\_articles\_avoid\_customergroups AS acu ON a.id = acu.articleID&nbsp;  
LEFT JOIN s\_articles\_categories AS ac ON a.id = ac.articleID&nbsp;  
LEFT JOIN s\_articles\_categories\_ro AS acr ON a.id = acr.articleID&nbsp;  
LEFT JOIN s\_articles\_categories\_seo acs ON a.id = acs.article\_id&nbsp;  
LEFT JOIN s\_articles\_downloads AS ado ON a.id = ado.articleID&nbsp;  
LEFT JOIN s\_articles\_downloads\_attributes AS adoa ON ado.id = adoa.downloadID&nbsp;  
LEFT JOIN s\_articles\_esd AS aesd ON a.id = aesd.articleID&nbsp;  
LEFT JOIN s\_articles\_esd\_attributes AS aesda ON aesd.id = aesda.esdID&nbsp;  
LEFT JOIN s\_articles\_esd\_serials AS aesds ON aesd.id = aesds.esdID&nbsp;  
LEFT JOIN s\_articles\_img AS ai ON a.id = ai.articleID&nbsp;  
LEFT JOIN s\_articles\_img\_attributes AS aia ON ai.id = aia.imageID&nbsp;  
LEFT JOIN s\_articles\_information AS ain ON a.id = ain.articleID&nbsp;  
LEFT JOIN s\_articles\_information\_attributes AS aina ON ain.id = aina.informatiONID&nbsp;  
LEFT JOIN s\_articles\_notification AS an ON ad.ordernumber = an.ordernumber&nbsp;  
LEFT JOIN s\_articles\_prices AS ap ON a.id = ap.articleID&nbsp;  
LEFT JOIN s\_articles\_prices\_attributes AS apa ON ap.id = apa.priceID&nbsp;  
LEFT JOIN s\_articles\_relationships AS ar ON a.id = ar.articleID&nbsp;  
LEFT JOIN s\_articles\_similar AS ASi ON a.id = ASi.articleID&nbsp;  
LEFT JOIN s\_articles\_similar\_shown\_ro AS ASiro ON a.id = ASiro.article\_id&nbsp;  
LEFT JOIN s\_articles\_top\_seller\_ro AS atop ON a.id = atop.article\_id&nbsp;  
LEFT JOIN s\_articles\_translations AS atr ON a.id = atr.articleID&nbsp;  
LEFT JOIN s\_articles\_vote AS av ON a.id = av.articleID&nbsp;  
LEFT JOIN s\_article\_configurator\_option\_relations AS acor ON ad.id = acor.article\_id&nbsp;  
LEFT JOIN s\_article\_configurator\_templates AS act ON a.id = act.article\_id&nbsp;  
LEFT JOIN s\_article\_configurator\_template\_prices AS actp ON act.id = actp.template\_id&nbsp;  
LEFT JOIN s\_article\_configurator\_template\_prices\_attributes AS actpa ON actp.id = actpa.template\_price\_id&nbsp;  
LEFT JOIN s\_article\_configurator\_templates\_attributes AS acta ON act.id = acta.template\_id&nbsp;  
LEFT JOIN s\_article\_img\_mappings AS aim ON ai.id = aim.image\_id&nbsp;  
LEFT JOIN s\_article\_img\_mapping\_rules AS aimr ON aim.id = aimr.mapping\_id  
WHERE a.active=0

&nbsp;

&nbsp;

doch leider in zeile 3 beim ersten Left join zeigt er einen fehler an, den ich nicht verstehe: “Unerkanntes schlüsselwort”, dabei beginnt doch dort der left join aus dem beispiel???

kann mir wer helfen?