Trying to cleanup table.. Stuck.. Help..

[DivaVocals]

I'll just say that I wasn't fully engaged either... Gave it a shot without testing..

If you haven't considered it further, (obviously) Ajeh's solution looks cleaner as it uses a bit more of sensible lexicon: Hey here's a list of things on the right, now on the left show me the things in the left that are not in the right...

I don't know the details of when this action is to be performed (deletion of "extra" product entries) (as in multiple times in execution) or how many such entries are to be removed, or the overall load on the system for any of the above three functional methods, but, if infrequently run, whatever works and accomplishes the desired task. :)

Well thanks for the help.. I can now move forward with the SBA conversion I'm working on..

Now this brings to light a VERY big gap in SBA.. There appears to be a lack of data integrity checks.. There should be some kind of check so that removing products SHOULD also remove them from the SBA table.. Same is true of attributes.. This same site I had products in the BA table with attribute IDS that no longer existed..

[mc12345678]

Or using your specific results of your query.

Delete from products_with_attributes_stock pwas
Where pwas.products_id in (
SELECT UNIQUE pwas1.products_id 
FROM   products_with_attributes_stock pwas1
LEFT OUTER JOIN products p
  ON (p.products_id = pwas1.products_id)
  WHERE p.products_id IS NULL
)

Though I think this later version is a bit more consuming than the earlier... Ideally left inner joins should be performed rather than outer joins... The first version does that (and ought to provide you the same results as what you posted), this second uses your outer join method. I threw in the unique statement just to be sure, probably doesn't need it.

and this doesn't work either..

Well thanks for the help.. I can now move forward with the SBA conversion I'm working on..

Now this brings to light a VERY big gap in SBA.. There appears to be a lack of data integrity checks.. There should be some kind of check so that removing products SHOULD also remove them from the SBA table.. Same is true of attributes.. This same site I had products in the BA table with attribute IDS that no longer existed..

Already taken care of in the branch mc12345678_sba154 of the version for ZC 1.5.3/1.5.4.

Both cases actually. So, at least people that install it anew will have all the benefits; however, those that have used the old version(s) may need to do what you have done, though may also include it into the "setup"/conversion.