Multiple Shop with all_products page

[lelijk]

Hi all,

First of all THANKS for this great contribution.

My question is: I want to integrate the all_products page within the multiple shop system but get lost with the query that get the products..........the query is:

$listing_sql = "select p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id  $where order by pd.products_name";

 

The problem I have overhere is that I've tried about 30/40 combinations to make this multishop-compatible but.............I'm a PHP/SQL NOOB!!! :blink:

 

Can anyone please help me with this one?

Thanks in advance!

Chris