Help needed at combining two Queries

[zdavatz]

Hi

 

This was to difficult for me:

 

I am trying to combine these two AddOns:

 

This Query is from the Manufacturer Multilanguage - http://www.oscommerce.com/community/contributions,3521:

 

$manufacturers_query = tep_db_query("select ma.manufacturers_id, mi.manufacturers_name from " . TABLE_MANUFACTURERS . " ma," . TABLE_MANUFACTURERS_INFO . " mi where ma.manufacturers_id = mi.manufacturers_id and mi.languages_id = " . (int)$languages_id . " order by mi.manufacturers_name");

 

This Query is from the "Empty Manufacturers" AddOn - http://addons.oscommerce.com/info/5476 - :

$manufacturers_query = tep_db_query("select distinct " . TABLE_MANUFACTURERS . ".manufacturers_id, " . TABLE_MANUFACTURERS .

".manufacturers_name, products_id, products_status from " . TABLE_MANUFACTURERS . ", " . TABLE_PRODUCTS . " where " .

TABLE_MANUFACTURERS . ".manufacturers_id = " . TABLE_PRODUCTS .

".manufacturers_id and " . TABLE_PRODUCTS . ".products_status = 1 group

by manufacturers_name");

 

What I want to do is combine the two above queries but I have not yet figured out how to do it! I want Multilanguage Manufacturers but I also do not want the Manufacturer name to show if all the products of the manufacturer are set to inactive.

 

Thank you for any Feedback and help.

 

Best

Zeno

[zdavatz]

Ok, this one brings me no more errors but the empty manufacturers are still being showed:

 

$manufacturers_query = tep_db_query("select ma.manufacturers_id,

mi.manufacturers_name, tp.products_status from " . TABLE_MANUFACTURERS . " ma," .

TABLE_MANUFACTURERS_INFO . " mi," . TABLE_PRODUCTS . " tp where

ma.manufacturers_id = mi.manufacturers_id and tp.products_status = 1 and

mi.languages_id = " . (int)$languages_id . " group by

mi.manufacturers_name");

 

More thinking to do!

 

Zeno

[zdavatz]

Ok, got it! Thank you for your help and your add-ons summitt and howard.

 

$manufacturers_query = tep_db_query("select ma.manufacturers_id,

mi.manufacturers_name, tp.products_status from " . TABLE_MANUFACTURERS .

" ma," . TABLE_MANUFACTURERS_INFO . " mi," . TABLE_PRODUCTS . " tp where

ma.manufacturers_id = mi.manufacturers_id and tp.manufacturers_id =

ma.manufacturers_id and tp.products_status = 1 and

mi.languages_id = " . (int)$languages_id . " group by

mi.manufacturers_name");

 

Best

Zeno