Artikel löschen laut der Wiki

[rockky]

Hi,

kann mir bitte jemand verraten welcher dieser befehle NUR für dass löschen der Sonderangebote zuständig ist?

Artikel löschen

Mit folgenden SQL-Befehlen können alle Artikel vollständig gelöscht werden.

TRUNCATE `products`;
TRUNCATE `products_attributes`;
TRUNCATE `products_attributes_download`;
TRUNCATE `products_content`;
TRUNCATE `products_description`;
TRUNCATE `products_graduated_prices`;
TRUNCATE `products_images`;
TRUNCATE `products_notifications`;
TRUNCATE `products_options`;
TRUNCATE `products_options_values`;
TRUNCATE `products_options_values_to_products_options`;
TRUNCATE `products_to_categories`;
TRUNCATE `products_vpe`;
TRUNCATE `products_xsell`;
TRUNCATE `products_xsell_grp_name`;
TRUNCATE `reviews`;
TRUNCATE `reviews_description`;
TRUNCATE `specials`;

Denke mal der letzte aber bin mir da nicht so sicher.

Alternative, wie lösche ich NUR die Sonderangebote?

Vielen Dank
Grüße
Charlie

Linkback: https://www.modified-shop.org/forum/index.php?topic=27150.0

[thisisrob]

Hmm, die SQL Struktur von modified verwundert mich erneut...
wieso werden keine constraints verwendet?

egal..

hier dein Code zum löschen aller Artikel, die als Sonderangebot gelistet sind:
!!Die Artikel werden also auch "normal" gelöscht!!

Code: [Auswählen]

DELETE FROM `products` WHERE products_id = ( SELECT DISTINCT products_id FROM specials);
DELETE FROM `products_attributes` WHERE products_id = ( SELECT DISTINCT products_id FROM specials);
DELETE FROM `products_content` WHERE products_id = ( SELECT DISTINCT products_id FROM specials);
DELETE FROM `products_description` WHERE products_id = ( SELECT DISTINCT products_id FROM specials);
DELETE FROM `products_graduated_prices` WHERE products_id = ( SELECT DISTINCT products_id FROM specials);
DELETE FROM `products_images` WHERE products_id = ( SELECT DISTINCT products_id FROM specials);
DELETE FROM `products_notifications` WHERE products_id = ( SELECT DISTINCT products_id FROM specials);
DELETE FROM `products_to_categories` WHERE products_id = ( SELECT DISTINCT products_id FROM specials);
DELETE FROM `products_xsell` WHERE products_id = ( SELECT DISTINCT products_id FROM specials);
DELETE FROM `reviews` WHERE products_id = ( SELECT DISTINCT products_id FROM specials);
DELETE FROM `reviews_description` WHERE reviews_id = (SELECT reviews_id FROM reviews WHERE products_id = ( SELECT DISTINCT products_id FROM specials));
TRUNCATE `specials`;
Das hier ist nur zum löschen der Sonderangebote:

Code: [Auswählen]

TRUNCATE `specials`;
 

[rockky]

Vielen Dank, hat funktioniert

Schönen Tag,
Grüße
Charlie