Remove Unused Manufacturers

[benn600]

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?

[Lou]

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.

[solarflare]

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

[benn600]

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

[Lou]

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.........

[solarflare]

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

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

[Lou]

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

[orange_juice]

Hallo, happy new year!

I'm using this:



How can I delete the records returned?

Did you find an answer?