Remove Unused Manufacturers

I'm using this:

SELECT * FROM manufacturers LEFT JOIN products ON manufacturers.manufacturers_id = products.manufacturers_id WHERE products.manufacturers_id IS NULL

How can I delete the records returned?

What about ONLY retrieving those you want?

I'm using the manufacturerestabmod from here and have changed the query in manufacturers_tabs.php from

$manufacturers_tab_query = "select m.manufacturers_id, m.manufacturers_name from " .TABLE_MANUFACTURERS . " m, " . TABLE_MANUFACTURERS_INFO . " md where m.manufacturers_id=md.manufacturers_id and md.languages_id=" . (int)$_SESSION['languages_id']. $order_by;

to

$manufacturers_tab_query = 
"select distinct m.manufacturers_id, m.manufacturers_name 
from " .TABLE_MANUFACTURERS . " m, " .TABLE_PRODUCTS . " p, " . TABLE_MANUFACTURERS_INFO . " md 
where m.manufacturers_id=md.manufacturers_id 
and p.manufacturers_id=m.manufacturers_id
and md.languages_id=" . (int)$_SESSION['languages_id']. $order_by;

I haven't thoroughly tested it yet but it seems to be working fine so far.

You know there's an admin option to only display Manufacturers with (active) products right?

Yes but it is VERY slow with hundreds of manufacturers and several thousand products. I think we're in better shape now.

solarflare:

You know there's an admin option to only display Manufacturers with (active) products right?

I thought I'd seen it somewhere but I cannot find it again.........

Configuration->Maximum Values->Manufacturers List - Verify Product Exist

Lou:

I thought I'd seen it somewhere but I cannot find it again.........

Thanks, doesn't work for me because I'm using the manufacturerestabmod but it's good to know!

Hallo, happy new year!

benn600:

I'm using this:

How can I delete the records returned?

Did you find an answer?