Note: delete unsused manufacturers from opencart database

DELETE manufacturer, manufacturer_description, manufacturer_to_store FROM manufacturer
LEFT JOIN manufacturer_description ON manufacturer_description.manufacturer_id = manufacturer.manufacturer_id
LEFT JOIN manufacturer_to_store ON manufacturer_to_store.manufacturer_id = manufacturer.manufacturer_id
WHERE manufacturer.manufacturer_id NOT IN (SELECT DISTINCT manufacturer_id FROM product)